How can I delete all products except those sold at least once?

Shopify Discussion

Topic summary

Main issue: Delete all Shopify products while keeping only those that have sold at least once.

Suggested approach: Export all product records to a CSV file, then filter or remove rows for products with zero quantity sold. After editing, re-import the updated CSV back into Shopify so the store updates automatically.

Rationale: Manually deleting product categories is described as challenging; using CSV enables bulk changes with shortcuts.

Technical note: CSV (comma-separated values) is a spreadsheet-style file that can be opened in tools like Excel or Google Sheets to sort/filter data (e.g., by quantity sold) and delete unwanted rows.

Process outline:

  • Export product CSV from Shopify.
  • Filter for products with zero quantity sold.
  • Remove those product rows.
  • Import the cleaned CSV to update the store.

Status: No confirmation or additional feedback provided; the discussion remains open with a single proposed method and no reported outcomes.

Summarized with AI on January 2. AI used: gpt-5.
1

Is there any way to delete all products, keeping only those that have sold at least once?

2

Hello @jtemzusa ,

Manually deleting the Shopify product categories will be a challenging job for you. We assume that you have added all product records in the CSV file. Hence, you need to export the CSV and in that, filter or remove the products with zero quantity sold. In this, there are different shortcuts to do so. Now, after updating, import that CSV file back in the Shopify database and automatically your online store will get updated.