Loading....

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:

https://thecomputerpeeps.com/images/snaps/dean/15/AMBIGUOUS_COLUMN_UPC_CODE_LIBERTY.png

You then won’t see any of your items:

https://thecomputerpeeps.com/images/snaps/dean/15/2017-11-19_1829.png

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

https://thecomputerpeeps.com/images/snaps/dean/15/2017-11-19_1832.png

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:

https://thecomputerpeeps.com/images/snaps/dean/15/2017-11-19_1834.png

As always, if you have any questions or if you’d like us to help, just let us know!

I've been helping consignment & resale store-owners since 2003. I started The Computer Peeps in February of 2010. After 15 years of working with consignment stores, I understand the unique challenges consignment & resale storeo-wners face. From electrical issues in old building or strip malls, to advocating for them when their consignment software keeps crashing. I now manage over 400 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 *

*
*

Time limit is exhausted. Please reload CAPTCHA.

*

Back To Top