Hi there Shopify Community,
I have a question regarding the importing and exporting of products/inventory via the excel function. The question(s) are:
1. If I update the sheet with information, i.e. new stock, and delete old stock entries etc, does the program also "delete" those stock items I have deleted in excel on shopify once imported.
2. Does in create duplicate items?
3. Is there a way to delete the whole inventory and re-build a new one from scratch if required?
Thank you for getting in touch and for outlining your questions. I will answer each one below.
I hope I have answered your questions but please do let me know if you have any further queries!
Victor | Shopify Social Care
I believe Victor from Shopify provided a very specific answer to solve your problem. So I just want to show you an article that I found about inventory exporting on Shopify. Hope it could help you!
Just wanted to chime in and add to what @Victor was suggesting for updating inventory. Parabola can help you bulk update existing inventory items, adjust existing inventory levels, and reset inventory levels.
Here's more info about our Shopify integration capabilities.
Hope this helps!
In regards to the 1st question, what would you suggest as a solution?
I receive a new product list from my supplier every day, and if an item is out of stock/discontinued they do not include it in the new CSV. Now I don't import a new product list to Shopify daily, but when I do finally import a new product list, items that were previously published on Shopify but that are NOW out of stock/discontinued are not overwritten and then they just end up floating aimlessly around my site.
My product list has 10000 items so it's virtually impossible to know which items are out of stock/discontinued at any given time - it could be 5 items, 50, or it could be 500, or etc. What work-around would you suggest? Do I need to completely delete all of my old products every time I need to import a new list of products?
Is there a way for Shopify to add 1 more option when importing that says replace all products and make this new product list the only active collection of products or something to that effect?