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:
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!