What is the proper way of fixing the duplicate itemlookupcode.
1 of my stores in a HQ setup happens to have different items with the same itemlookupcode. However, when browsing the store db, the HQID and ID fields in the item table are different.