How to undo a bad product CSV import in Shopify

First: work out what the import actually did

1. Stop anything that might import again. If a sync app, a supplier feed or a scheduled import produced the file, pause it before you start fixing.
2. Open the file you imported. It is the best record of the damage: every handle in it is a product that was created or changed, and every column in it is a field that may have been overwritten.
3. Check which option you chose. If you ticked Overwrite products with matching handles, existing products with those handles were changed. If you didn’t, Shopify ignored rows for existing handles, and the import only added products.
4. Look for blank cells. With overwrite on, a blank cell in a non-required column replaces the existing value with a blank (Shopify’s own example is a blank Vendor column wiping the vendor). Columns that aren’t in the file at all are left alone.
5. Protect sales now. If prices were overwritten with wrong values, set those products to Draft until they’re fixed so nobody checks out at the wrong price.

If the import added products you didn’t want

Without the overwrite option, a bad file usually shows up as duplicates: the same item again under a slightly different handle. In Products, sort by creation date (newest first), select the products the import created, and archive or delete them. Archiving is safer if you aren’t sure, because it can be reversed.

Option 1: re-import a backup from before (best if you have one)

Shopify’s help centre tells you to back up your products before importing. If you exported a CSV first, it is your undo file.

1. Open the export from before the import and confirm it has the correct old values.
2. Keep only the rows for products the bad import touched (the handles in the bad file), and only the columns it overwrote. Anything else you leave in will also be applied.
3. Don’t sort the file in Excel or Numbers. Shopify warns that a sorted file can break the links between products and their image rows.
4. Go to Products → Import, choose the file and tick Overwrite products with matching handles.
5. Try it on two or three products first, then import the rest and spot-check prices, variants and tags.

Watch out: an old export also holds old values for anything that changed legitimately since, such as stock levels from orders. Remove those columns before you import.

Option 2: no backup? Rebuild the old values

• Your supplier’s or previous import file. If this import replaced an earlier one, the earlier file often holds the correct values.
• Recent orders show the price each product last sold at.
• Other channels. A Google Merchant Center feed, a marketplace listing or a cached copy of your product page may still show the old title, description or price.
• Fix in bulk. Once you have the values, select the affected products, open Bulk edit, add the columns you need and correct them in one pass. Keep a list so nothing is missed.

Option 3: an app that recorded the “before”

A product history app records each product’s previous values as changes happen, whether they come from the admin, the bulk editor or another app. Imports that update existing products trigger Shopify’s product-update notifications, which is what these apps record. It can then put those values back without a backup file. The limit is the same for every such app: it can only restore changes made after it was installed.

Our app, UndoGuard, is one of these. It tracks titles, descriptions, tags, status, visibility, prices, compare-at prices and SKUs, emails you when many products change at once, and restores changed fields in one click on paid plans. It never overwrites a field that was edited again after the import. On the Plus plan, Select this bulk edit ticks every change from that burst of edits so you can undo them together.

What it can’t do after a bad import: delete products the import created, recreate variants the import removed, or restore images, metafields or stock at multiple locations. Those need a backup or a manual fix.

How to import safely next time

• Export first, every time. Products → Export → all products, as CSV. That file is your undo.
• Only include the columns you mean to change (plus Handle). Missing columns are left alone; blank ones are wiped when overwriting.
• Test with a few rows before importing the whole file.
• Keep files under 15 MB, and split larger ones.
• Get alerted when many products change at once, so a bad import is caught in minutes, not when customers notice.

Common questions