Deleting inventory using csv

TamaHelp
New Member
2 0 0
Hi, I was wondering if there's a way to delete items using the inventory import csv option, I am aware of how to update inventory levels and can update them to 0 , but I assume that would leave the inventory still showing in my control panel.
I've read the relevant articles linked here : https://help.shopify.com/en/manual/products/import-export/using-csv
 
But wasn't sure if this was possible.
Also, just want to make sure I understand it correctly.
The handle on my page are SKU's and I can get a list of SKU's which have sold out from my supplier, so the only issue is getting rid of the product listings.
 
0 Likes
gina-gregory
Shopify Expert
710 48 176

I don't think it's possible using Shopify's native import/export system, but you can delete products with the Excelify app using a CSV.

https://excelify.io/documentation/products/#command

0 Likes
Renars
Shopify Partner
120 18 120

Hello @TamaHelp and @gina-gregory 

Renars here from Excelify.
Thank you for suggesting Excelify!

@TamaHelp If you are open to using apps, then you sure can easily bulk delete Products with Excelify.
The process is quite simple, you can export your Products using Excelify app and export only Basic Columns.
You can also click on the "Filters" button to export only specific items not all. As if you do not wish to update other items then you do not need to include those in the file.

In the exported file you would have the "Command" column. In this column set value to "DELETE" for any Products, you wish to delete. Then import the file back into Shopify with Excelify and Those Products will get deleted.

You can also use Shopify exported file and just add the "Command" column to the file. The app will be able to find existing Product and delete it by "Handle" as they are always unique in Shopify.

Here we also do have a great tutorial on how to bulk delete Products in Shopify.

I hope this helps, if you have any more questions or issues, feel free to reach out to us directly.

 

Matrixify | Bulk Import Export Update | https://apps.shopify.com/excel-export-import | https://matrixify.app