I used an Excel spreadsheet with the proper 29 columns to import a new inventory of items. I used the New Quantity column (Row Z) and chose the option to overwrite the old inventory.
Unfortunately, my inventory now shows all items being 'Sold Out' and non of the items show any quantity at all.
I started over and put my quantities in the Current Quantity column (Row Y) and did the same overwrite of our inventory.
Same thing...no quantities, and the red 'Sold Out' button is on every item in the library.
I even did a test spreadsheet with only one item and imported that. Likewise, it showed zero quantity using the New Quantity/Z column. So I tried it again with Current Quantity/Y and it was likewise showing no inventory.
But now, when I look at that lone item in my Item Library, it shows that the SKU is already being used...?? For a one item library?? How is that possible??
What is going on with the quantity problem?? Which column should be used for uploading a whole new inventory spreadsheet...New/Z or Current/Y Quantity column?? Is there a way to clear the cache in our Item library and start fresh??
HELP!!! I need this solved tonight for an opening tomorrow!!!
