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:
- No cancel, no import history. "Product imports started with a CSV file can't be canceled once they begin, and you can't view a history of past imports."
- The activity log is the only trail. Shopify points you to the store activity log to review recent changes made by an import. That log is view-only, can't be exported and shows at most 250 results. It has no revert option.
- Shopify expects you to have a backup. "Before you start your import, make sure that you have a backup of your product data."
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
- Don't re-import the same file, or a quick fix, until you know what changed.
- Export the current state: Products → Export → All products. This is your "after" file.
- 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):
- Compare the before and after files to see which columns the import damaged.
- Copy the before file and delete every column except
Title,URL handle(Handlein older exports) and the damaged columns. Columns you leave out are left alone, so edits made since the import are safe. - If any damaged column is a variant field (price, SKU, barcode, weight), keep the
Option1 name/Option1 valuecolumns (and Option2/3 if used), or the import replaces your variants. - 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.
- 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:
- The file you imported. If it was an export from another store or a supplier, the source system may still hold the right values.
- Order exports, for titles, SKUs and prices of anything that sold.
- Other channels: Google Merchant Center, marketplaces, an ERP or supplier sheets.
- The Internet Archive (web.archive.org), for descriptions and images.
Then follow Step 1 from point 2.
Next time
- Export all products immediately before any import, with the date in the filename.
- Import only the columns you mean to change:
Title,URL handle, the option columns if you touch variants, and the changed columns. - 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.
- Only the fields the import touched are reverted. Fields edited again after the import are kept unless you choose otherwise.
- Steps that remove data (for example a variant the import created) need a separate confirmation.
- The undo can itself be undone: the app saves the current version of every affected item first.
- On the paid plans you can also export your catalog as a Shopify import CSV at any time.
The honest limits:
- It can't undo an import that ran before it was installed. Install it before you need it.
- Undoing a whole import in one step is on the paid plans (Starter at $6.99/month and Pro at $14.99/month, both with a 14-day free trial). On the Free plan (daily snapshot, 7-day history, up to 500 products) you can restore products one at a time from the daily snapshot.
- Inventory quantities aren't restored, and variants deleted by the import come back with new IDs.
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