How to put Shopify prices back after a Black Friday sale
Black Friday is on 27 November this year and Cyber Monday on the 30th. The sale is the easy part. The week after is when the problems surface: half the catalogue still on sale, a "revert" file that overwrote prices you'd changed on purpose, a fixed price in one country that nobody remembered, and a "was" price that's no longer legal to show in the EU.
This guide is the routine that avoids all of that, using Shopify alone: choose a sale method that needs the least undoing, save a dated snapshot before you touch anything, put back only what you changed, and then prove everything went back. There's a free checking sheet that compares your before and after exports and lists every price that didn't.
The short version
- If the sale is a simple percentage off, use an automatic discount with an end date. It never changes product prices, so there's nothing to put back.
- If you edit prices, export all products first and keep the file with the date in its name.
- Tag every product you change, so you can find them again.
- Put prices back with a file that holds only the rows and columns you changed, never the cost per item.
- Export again afterwards and compare with the snapshot: every row that differs is a price that didn't go back.
- Check the places a CSV doesn't reach: fixed market prices, POS and Google.
- Keep the files. In the EU they're your evidence for the next "was" price.
Step 1: Pick the sale method that needs the least undoing
There are two native ways to run a sale in Shopify, and they behave very differently when it ends:
| Automatic discount (or code) with an end date | Lower the price, set a compare-at price | |
|---|---|---|
| When the sale ends | Stops by itself. Product prices were never changed | Nothing happens. You put every price back |
| Strikethrough "was" price | Not on the product page by default: the saving shows in the cart and at checkout, unless your theme or an app displays it | Yes, everywhere the product is shown |
| Shopify POS | Only at POS Pro locations, and only if you tick Also offer on Point of Sale on the discount | Yes, the till simply has the new price |
| Google Shopping | Can show as a promotion, but only online discounts with an end date are sent | Shows as a sale price, synced from the compare-at price |
| Limits | A store can have at most 25 active automatic discounts, including ones created by apps | None, but every changed variant is one more thing to put back |
The rule of thumb: if the offer is "20% off this collection", use an automatic discount with an end date and you can skip most of this guide. Edit prices only when you need the strikethrough on the product page, the sale at a POS Lite till, or different discounts per item that would blow through 25 automatic discounts.
If you do edit prices, the rest of this guide is for you.
Step 2: Before you touch a price, save a dated snapshot
Shopify doesn't keep a history of your old prices that you can roll back to. Your snapshot is the only record of what "normal" was, so take it before the first edit:
- In the admin, go to Products › Export, choose All products and a CSV file, and export. Shopify emails you the file.
- Rename it with the date, like
2026-11-20-prices-before-bfcm.csv, and put a copy somewhere other than your downloads folder. - If you sell in more than one market with fixed prices, check those are in the file too (next section). If they aren't, export them from the market's catalog.
Where fixed market prices live. The product CSV only includes Price / [Market] and Compare At Price / [Market] columns for a market when exactly one of its active catalogs isn't shared with another market. For any other market with fixed prices, the prices live in its catalog, and Markets › Catalogs can export a catalog as CSV. Markets priced by a percentage adjustment follow your base price and need nothing extra.
Tag what you change. As you put each product on sale, add a tag like bfcm-2026. In the bulk editor you can add Tags as a column. Later, filtering by that tag shows exactly what to put back, and nothing else.
Step 3: Set the sale price so it can be undone cleanly
- Price becomes the sale price. Compare-at price becomes the normal price, which Shopify shows crossed out. Shopify only shows a sale when the compare-at price is higher than the price.
- Leave cost per item alone. Your cost doesn't change because you're on sale. If you include cost in your sale and revert files, a supplier price change that lands mid-sale gets rolled back with everything else. Our cost per item guide explains why that number needs to stay right.
- Selling in the EU? The crossed-out price has a legal limit. When you announce a price reduction, Article 6a of the EU Price Indication Directive requires you to show the "prior" price: the lowest price you applied in the 30 days before the reduction. If you raised a price in early November, the compare-at price can't be the new, higher one. Your snapshot shows what each price was.
Use the bulk editor for this: tick the products, click Bulk edit, and add Price, Compare-at price and Tags as columns. Each row is a variant.
Step 4: Write down anything you change during the sale
Most revert disasters come from changes made while the sale is on: a supplier price rise you passed on, a new product added at a sale price, a permanent price cut on a slow seller. A revert file built from the old snapshot would quietly undo all of them.
- Keep a short list: product, what changed, and whether it's permanent or part of the sale.
- If you change several prices mid-sale, take another dated export, so you have a record of what each price was on which day. In the EU, that's the record behind your next 30-day prior price.
- New products added during the sale won't be in your "before" snapshot. Note their normal price when you add them.
Step 5: Put the prices back, and only those
For a few dozen variants, use the bulk editor. Filter products by your bfcm-2026 tag, open them in the bulk editor with Price and Compare-at price as columns, and type the normal prices back from your snapshot. Clear the compare-at price unless the product was already on sale before Black Friday.
For more, import a trimmed copy of your snapshot. The safe way to build it:
- Open the before file and delete every row for products you didn't change. Your tag list tells you which ones to keep.
- Delete the rows of anything you changed on purpose during the sale (Step 4), and fix those by hand.
- Delete every column except these: URL handle, Title, every Option name and Option value column, Price and Compare-at price.
- Import it from Products › Import, with Overwrite products with matching handles ticked.
Or let our free price restore tool build the file. Add your before export and a fresh one, untick anything you changed on purpose, and it gives you a revert file with exactly those rows and columns, plus a one-product test file. It runs in your browser, so the exports aren't uploaded anywhere.
Three rules from Shopify's CSV guide make or break this file:
- Never drop the option columns. If you overwrite with the option columns missing, Shopify says a new default variant is created and your existing variants are deleted. That's the one mistake you can't undo by importing again: Shopify notes that new variant IDs can break apps and integrations that depend on the old ones.
- A blank cell writes a blank. Every cell in a column you include is applied, empty or not. That's what you want for compare-at prices you're clearing, and exactly what you don't want anywhere else. Columns you delete are left as they are.
- Keep every row of a product you include, and keep the headers exactly as exported.
Try the file on one product first. Import a copy that holds a single product with several variants, check it in the admin, and only then import the rest.
Then the fixed market prices. If a market's fixed prices were in your product CSV, they come back with the import (keep those columns too). If they live in a catalog, put them back in that catalog, or import the catalog CSV you exported before the sale.
Step 6: Prove every price went back
Don't check by clicking through products. Compare files:
- Export all products again, the same way as before.
- Put the before and after exports side by side and compare each variant's Price and Compare-at price. The price restore tool does it with the two files as they are, or use the free sheet below: paste both, and it lists every variant whose price or compare-at price differs, plus any that disappeared.
- Every line it flags is one of three things: a price that didn't go back, a compare-at price left behind, or a change you made on purpose. Mark the last kind so they stop showing.
Then check the three places a product export doesn't cover:
- Other markets. Use the country selector on your store to view a few sale products in each market with fixed prices.
- POS. Scan a couple of sale items at the till. Product prices are shared, so if the admin is right, POS is too. If you used an automatic discount at POS, check it has ended.
- Google. Your sale prices reached Google through your product data, so they clear when the corrected prices sync. Check Merchant Center a day later for any product still showing a sale price.
Step 7: Keep the files, especially if you sell in the EU
Your dated exports are the only record of what you charged when. Two reasons to keep them:
- The next sale's "was" price. The prior price is the lowest price in the 30 days before a reduction. If you run a Christmas sale on, say, 15 December, the 30 days before it include Black Friday, so the lowest price is likely your Black Friday price, not your normal one. A "was €40, now €30" that ignores a €28 Black Friday price is the kind of claim the EU rule exists to stop. The European Commission's reading is broad, and even general "sale" announcements can be covered.
- Proof, if anyone asks. Showing a reduction means being able to show the price history behind it.
Rules differ between countries, and the UK and others have their own guidance on "was" prices. This guide isn't legal advice, so if you sell abroad, check the rules where your customers are.
After the rush: a good sale leaves gaps on the shelves just before the Christmas orders. Our guides on deciding what to reorder and receiving the stock when it arrives pick up from here. If you offered free shipping, the shipping cost report shows which sale orders cost more to ship than the customer paid.
Free price check sheet
Download the free price check sheet (Excel). Paste seven columns from your before export and the same seven from your after export: URL handle, Option1 value, Option2 value, Option3 value, SKU, Price and Compare-at price. The sheet matches every variant by handle and options, then marks each one OK, Price not back, Compare-at left on, Compare-at missing or Missing in after export, and counts them. Type Y next to a variant you changed on purpose and it's marked Changed on purpose instead. A worked example is filled in. It opens in Excel, Google Sheets and Numbers.
Questions merchants ask
Does Shopify put prices back automatically after a sale?
Only if the sale was an automatic discount or a code with an end date: those never touch product prices. Lowered prices and compare-at prices stay until you change them, by hand, by CSV, or with an app that schedules the revert.
How do I see which products are still on sale?
Compare an export from after the sale with your snapshot from before it. Any variant whose Price differs, or that still has a compare-at price it didn't have before, wasn't put back. The free sheet does the comparison.
Can a CSV import delete my variants?
Yes, if you import with overwrite and leave out the option columns. Keep URL handle, Title and every Option name and value column in the file, and test on one product first.
Should I put back the cost per item too?
No. Leave cost out of both the sale and the revert. If a supplier's price changed during the sale, a revert that includes cost would undo it. If costs did move, our guide to updating prices when supplier costs rise covers that separately.
Quick checklist
- Simple percentage-off sales run as automatic discounts with an end date.
- All products exported, with the date in the filename, before the first price edit.
- Fixed market prices saved too, from the CSV or the catalog.
- Every product you change is tagged
bfcm-2026. - EU compare-at prices are the lowest price of the last 30 days.
- Changes made during the sale are written down.
- Revert file: only tagged rows, only handle, title, option, price and compare-at columns, tested on one product.
- After export compared with the before export, and every flagged row explained.
- Markets, POS and Google checked.
- All dated exports kept.