Liberty Ambiguous Column Name ‘UPC_CODE’ Error

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!

I am a consignment software specialist, System Administrator for hundreds of consignment workstations across North America, and developer of Peeps' Software! I've been helping consignment & resale store-owners since 2003. I started The Computer Peeps in February of 2010. After 18+ years of working with consignment stores, I understand the unique challenges consignment & resale store-owners face. From electrical issues in old building or strip malls, to advocating for them when their consignment software keeps crashing. I now manage hundreds of computer systems, servers & websites for store-owners all across North America and I am the developer/programmer of Peeps' Software -- the only software written FOR consignment & resale stores specifically.

Leave a Comment

Your email address will not be published. Required fields are marked *


Back To Top