Catalog Undo › Guides

How to undo a bad CSV product import in Shopify

You imported a product CSV with "Overwrite products with matching handles" ticked, and now descriptions are blank, prices are wrong or variants are gone. This guide explains why imports go wrong, what Shopify can and can't do, and how to put things back.

Disclosure: this guide is published by the makers of Catalog Undo, a Shopify app for this problem. It's described once, at the end.

What Shopify can and can't do

From Shopify's CSV import guide:

Why the damage happened

Most bad imports come from one of these rules, all from Shopify's CSV import and CSV format pages:

What was in the file What Shopify did
A column that was present but blank "the matching value in the product list is overwritten as blank"
A column that was missing entirely "the value in the product list remains the same"
Variant columns (such as SKU) without Option1 name / Option1 value "a new default variant is created and existing variants are deleted"
Changed Option1/2/3 value columns existing variant IDs are deleted and new ones created, which "can break third-party dependencies on variant IDs"
A file sorted in Excel or Numbers products can lose their image links, and "your product's images will be lost"

Knowing which row applies tells you which fields to restore.

Step 0: stop it getting worse

  1. Don't re-import the same file, or a quick fix, until you know what changed.
  2. Export the current state: Products → Export → All products. This is your "after" file.
  3. If an app or integration produced the file, pause it so it doesn't import again.

Step 1: restore from your pre-import backup

If you exported before importing (or have any export from before):

  1. Compare the before and after files to see which columns the import damaged.
  2. Copy the before file and delete every column except Title, URL handle (Handle in older exports) and the damaged columns. Columns you leave out are left alone, so edits made since the import are safe.
  3. If any damaged column is a variant field (price, SKU, barcode, weight), keep the Option1 name / Option1 value columns (and Option2/3 if used), or the import replaces your variants.
  4. Blank cells overwrite. If a product had no value in a column you're restoring, its cell is blank in the backup too, which is correct. But check you haven't introduced blanks by deleting rows or cells.
  5. Don't sort. Test with 2–3 products, check them in admin, then import the rest with "Overwrite products with matching handles" ticked.

If variants were deleted and recreated, restoring the columns brings back the values but not the old variant IDs. Reconnect anything that used them (inventory apps, marketplace feeds, subscription apps), and re-enter inventory per location: don't paste in old stock numbers.

Step 2: no backup?

Rebuild only the damaged columns, from:

Then follow Step 1 from point 2.

Next time

  1. Export all products immediately before any import, with the date in the filename.
  2. Import only the columns you mean to change: Title, URL handle, the option columns if you touch variants, and the changed columns.
  3. Import 5 products first and check them.

Doing this with Catalog Undo

Catalog Undo keeps a version history of your products, variants, metafields and collections from the moment it's installed. An import usually shows up on its home page as a single bulk-change card within a few minutes (a long import shows a card that grows until it finishes). You preview exactly what will be put back, run a dry run against your live store, then run the undo.

The honest limits:

See Catalog Undo on the Shopify App Store


Shopify Help Center pages checked on October 24, 2026. Admin menu names change from time to time.

Sources: Importing products with a CSV file · Using CSV files · Exporting products · Activity logs