Hello Folks!
So I am having an issue.
We recently setup a new store, with a limited selection of products, and ergo, not the entire Headquarter's worth of items in the database.
However, somehow, this new store managed to get assigned quantities of items if doesn't have in it's database, but HQ asserts it has. I tried to run a Inventory Wizard 190, but it doesn't populate a full list of items. Also, adjusting the store quantities via a worksheet does not work, either. The only thing that's worked so far is to manually visit each item in maintenance mode and clear them one by one. However, with over 20,000 items in inventory, it'd be a MASSIVE time sink to do.
I was curious as to what table HQ might store it's Store Quantities values at, so I could maybe just use a SQL command to eliminate all inventory from that store (It's not open yet, and not inventory has been transferred to it), or if another method exists for clearing all these phantom items out of HQ, since they are not present at the store level database
*This post is locked for comments
I have the same question (0)
