One of the stores was showing an item in the database for 12.99 that should have been 4.99. I looked at the store database and found 2 items with the same itemlookupcode for two different prices. So I check HQ to see if I have the same thing in HQ. I am showing only the correctly priced item in HQ, however upon further examination, I discovered that I have some other items that are showing duplicate lookup codes in HQ.
Any ideas of what could have caused this to happen and how I can fix it???