Blog

How to put Shopify prices back after a Black Friday sale

14 November 2026 · 10 min read · Wren Commerce

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

  1. 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.
  2. If you edit prices, export all products first and keep the file with the date in its name.
  3. Tag every product you change, so you can find them again.
  4. Put prices back with a file that holds only the rows and columns you changed, never the cost per item.
  5. Export again afterwards and compare with the snapshot: every row that differs is a price that didn't go back.
  6. Check the places a CSV doesn't reach: fixed market prices, POS and Google.
  7. 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 dateLower the price, set a compare-at price
When the sale endsStops by itself. Product prices were never changedNothing happens. You put every price back
Strikethrough "was" priceNot on the product page by default: the saving shows in the cart and at checkout, unless your theme or an app displays itYes, everywhere the product is shown
Shopify POSOnly at POS Pro locations, and only if you tick Also offer on Point of Sale on the discountYes, the till simply has the new price
Google ShoppingCan show as a promotion, but only online discounts with an end date are sentShows as a sale price, synced from the compare-at price
LimitsA store can have at most 25 active automatic discounts, including ones created by appsNone, 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:

  1. In the admin, go to Products › Export, choose All products and a CSV file, and export. Shopify emails you the file.
  2. Rename it with the date, like 2026-11-20-prices-before-bfcm.csv, and put a copy somewhere other than your downloads folder.
  3. 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

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.

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:

  1. Open the before file and delete every row for products you didn't change. Your tag list tells you which ones to keep.
  2. Delete the rows of anything you changed on purpose during the sale (Step 4), and fix those by hand.
  3. Delete every column except these: URL handle, Title, every Option name and Option value column, Price and Compare-at price.
  4. 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:

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:

  1. Export all products again, the same way as before.
  2. 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.
  3. 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:

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:

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