How to undo or roll back a Shopify CSV price import

First, stop and take stock

Before you fix anything, slow down for a few minutes:

• Do not run more imports from the same file.
• Write down which products were in the import and roughly when it ran.
• Check what actually went wrong. Price imports fail in different ways: the wrong prices on the right products, prices on the wrong variants (often a SKU mix-up), or, if the file was missing option columns, variants that were deleted and created again.
• If the error is serious, such as prices far below cost while orders are coming in, consider making the affected products unavailable while you fix them.

Wrong prices on the right variants can be fully fixed with another import. The other two cases may also need manual repairs in Shopify admin: a variant that was created again has a new ID, and a price import cannot give it the old one back.

Option 1: Import a rollback file

A rollback file has the same layout as the file you imported, with the same products and variants, but with the original prices. It is the cleanest way to undo, because it touches exactly what the import touched and nothing else.

1. Open the rollback file and compare a few rows with your backup: the same handles, the same option values and the old prices.
2. In Shopify admin, go to Products, click Import, choose the rollback file and select Overwrite products with matching handles.
3. Read the preview. Cancel if it mentions new products or new variants.
4. Import one small product first and check it in Shopify admin, then import the rest.
5. Export your products again and compare the prices with your backup from before the bad import.

Option 2: Rebuild the old prices from your backup export

If you have the full export you made before the import, but no rollback file, you can make one from it.

Do not simply import the whole backup again. It contains every column for every product, including descriptions, tags, status and SEO fields. Importing it would put all of those back to the backup’s values, and quietly undo any good changes made since.

Build a smaller file instead:

1. Make a copy of the backup, and leave the original untouched.
2. Keep only the rows of the products that were in the bad import, with all variant rows of each product.
3. Keep the handle, title, option name and value columns, and the price column. Delete the other columns completely rather than emptying them: with the overwrite option, Shopify keeps the existing values for columns that are not in the file, while a blank cell in an included column can clear that field.
4. If the bad import also changed the compare-at price, keep that column from the backup too.
5. Do not sort or edit the option values. Together with the handle, they identify each variant.
6. Import it as in Option 1, starting with one small product.

Take care when you edit the backup in a spreadsheet. Saving a CSV from Excel can drop leading zeros and reformat numbers. Open the saved file in a plain text editor and spot-check a few rows before you import it.

Option 3: No backup? Rebuild from what you have

Without a file from before the import, there is no single place that holds the old prices. These sources can help:

• The supplier’s previous price list and the rule you used before. The same cost with the same markup or margin, rounded the same way, gives the same price. The markup and margin calculator can check a few of them.
• Recent orders, which show what customers paid for each variant (before discounts).
• Any older product export, from you or a teammate. Use only its prices, not its other columns.
• Your own records, such as pricing spreadsheets, quotes or listings on other sales channels.

Put the rebuilt prices into a minimal file as in Option 2, review it, test it on one product and import it. Then take a full export straight away, so you have a backup next time.

What a rollback cannot fix

Re-importing prices is useful, but it is not a time machine:

• It restores prices, not your whole store. If someone changed one of those prices by hand after the bad import, the rollback file sets it back to the old price as well. Fields that are not in the file stay as they are now.
• It is not a transaction. If the rollback import stops partway, some products will be restored and others will not. Export again and check.
• Unit price display. A price-only import can switch off unit-price display for products that use unit pricing, and putting the price back does not switch it on again. Check those products in Shopify admin.
• Orders already placed keep the price they were placed at. Decide separately how to handle them.
• Recreated variants keep their new IDs.

Make the next undo easy

• Export a full product CSV right before every import, and keep it untouched.
• Create the rollback file at the same time as the import file, from the same fresh export.
• Import one small product first, and read Shopify’s preview before you confirm.
• Keep the files together with a short note: the date, the supplier file and the pricing rule you used.

The full process is in the guide to updating Shopify prices from a supplier CSV.

How Supplier Update Guard handles rollback

Supplier Update Guard creates the rollback file for you, in the same step as the import file. Both come from the same fresh export, cover the same affected products with all of their variants, and contain only handle, title, options and price. The import file holds the approved new prices and the rollback file holds the original ones. Alongside them you get a change report that lists every old and new price, and a review summary of what you approved.

It is still a best-effort recovery, not a full backup. The rollback file restores the prices in that file only, later changes in Shopify admin can complicate it, and you should keep your full export as an independent backup. Products that use unit pricing are blocked from the import for the reason above. The tool guide describes the backup, import and rollback steps in detail.