How To: Deleting product variants using a CSV file

Shopify Discussion

Topic summary

This guide explains how to bulk delete product variants in Shopify using CSV files, which is useful when working with multiple products (single-product deletions are better handled through bulk actions in the admin).

Export Process:

  • Navigate to Products in Shopify admin and click Export
  • Choose which products to export (current page, all products, selected items, or filtered results)
  • Select CSV format based on your editing tool (Excel/Numbers format or plain text)

Editing the CSV:

  • Always keep a backup copy of the original CSV before making changes
  • To delete all variants: Select and delete all variant rows, then change Option1 Name to “Title” and Option1 Value to “Default Title”. Delete values in Option2/Option3 columns if applicable
  • To delete specific variants: Select and delete only the desired variant rows. Optionally delete the variant option column values if removing entire option sets

Import Process:

  • Return to Products and click Import
  • Upload the edited CSV file
  • Select “Overwrite current products with same handle” (existing values will be used for missing columns)
  • Review details and complete the import

If import issues occur, consult Shopify’s troubleshooting resources for common CSV import problems.

Summarized with AI on November 20. AI used: claude-sonnet-4-5-20250929.
1

If you only need to delete the variants of a single product, it is best to use a bulk action directly in the Shopify admin. If you need to delete variants from multiple products, then you can use a CSV file to make the changes in bulk.

Steps### Export your Products1. From your Shopify admin, go to Products.

  1. Note: If you want to export only some of your products, then you can filter your product list to view and select specific products for export.
  2. Click Export.
  3. From the dialog box, choose the products you want to export:
  4. Select which type of CSV file you want to export:
    • CSV file for Excel, Numbers, or another spreadsheet program. Use this format if you plan to use a spreadsheet program to edit your product CSV file.
    • Plain CSV file. Use this format if you plan to use a plain-text editor with your product CSV file.
  5. Click Export products.

Edit your CSV file

Caution: A CSV import will overwrite your existing products. Keep a copy of your original CSV and make any changes in a new copy so that you will have a backup.

**Deleting multiple variants:**1. Select the variant or variants that you want to delete.

  1. Delete the selected rows.
  2. Optional: If you need to delete all the variants and the variant option, then delete the value in the Option2 Name column or Option2 Name and Option3 Name columns.

**Deleting all variants:**1. Select all variant rows.

  1. Delete the selected rows.
  2. Delete the values in the Option2 Name, Option2 Value, Option3 Name, and Option3 Value columns if applicable.
  3. Change the Option1 Name column value to Title and the Option1 Value column value to Default Title.

**Import your edited CSV file:**1. From your Shopify admin, go to Products.

  1. Click Import.
  2. Click Add file, and then select the CSV file that you want to import.
  3. Select Overwrite any current products that have the same handle. Existing values will be used for any missing columns. This will update the products.
  4. Click Upload and continue.
  5. Review the details about the import, and then click Import products.

If you run into any issues with your import, take a look through Solutions to common product CSV import problems. For more information on Variants review the Shopify Help Center.

1 Like