If you’re seeing the Ambiguous Column Name ‘UPC_CODE’ Error when viewing items in a Retail Vendor account in Liberty, this post is for you.
There’s a bug in Liberty, where if you try to sort any of the columns on the Inventory tab in a Retail Vendor account, from that point forward, you’ll see an error when you click on the Inventory tab:
You then won’t see any of your items:
I’ll let you do a Google search for SQL queries and how Ambiguous Column Name relates, but to get right to it, you’ll need to delete a Registry Key to fix this…then make sure you never try to sort columns in a Retail Vendor account. 🙂
The Registry Key in question is:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ResaleWorld.com\RWD\Grids\TclFrmRetailClient\dbgrdRetail
You can safely delete this key, but please, if you do not feel comfortable doing this or if the Windows Registry *frightens* you, don’t you dare touch a thing! 😀
Once you’ve deleted that key and restarted Liberty, the datagrid will be functional again and you’ll be able to view your items in a Retail Vendor account:
As always, if you have any questions or if you’d like us to help, just let us know!
Dean
I am a Software Developer, System Administrator, and consignment software specialist. I currently manage hundreds of consignment workstations, point of sale systems, and database servers all across North America and I am the developer of Peeps' Software, Peeps2Go, and Peeps' Consignor Login for iOS and Android. I've been helping consignment & resale store-owners since 2003. I started The Computer Peeps in February of 2010. Peeps' Software launched in 2016 and is now on hundreds of systems all across North America. I have successfully converted dozens of stores from all of the major consignment software systems. After 20 years of working with consignment stores, I understand the unique challenges consignment & resale store-owners face. From electrical issues in old buildings or strip malls, to advocating for them when their old consignment software keeps crashing.