Bulk delete all products except certain products specified by product name

[Derelicte]

My store is way too big so I want to delete all products I have had in my store over the past year that have not made any sales. I exported all my sales to excel and got a list of all of my product names that have 1+ sale.

The logic I want to execute is:

if product name is contained in the list I provide

then keep product

else delete product

Is this possible in Shopify or are there any apps that I can download that can achieve this?

[Blair]

Hey @Derelicte!

Thank you for reaching out to the Community. 

The product CSV only allows for the addition and modification of products, but cannot delete products. You can certainly look to some apps listed below to help achieve this:

- Matrixify 

- Bulk Product Edit & CSV Import

- Exportible - Order Export 

[Derelicte]

I figured out a way to do it. I exported a list of all my product sales and put it into excel, then I just went through my website catalog and added to the list of all items I want to keep in my store and not delete. Then I exported my product catalog list and I am using excel formulas to flag my whole catalog list as keep or not keep and then using bulk product edit app to create a tag on all my catalog products as keep or not keep then I am going to go to the Shopify bulk product editor and select delete all products with tag as not keep