Guide

How to Check Your Shopify Prices Came Back After Black Friday

A ten-minute spreadsheet check that confirms every price and compare-at price went back after a sale, plus the four problems it usually finds.

4 min read · Updated 2026-11-05

The sale ended, the banner is down, and you want to close the laptop. Before you do, spend ten minutes confirming that every price actually went back. A wrong price after a sale rarely announces itself. It sits in the store until a customer notices, or until you check your margins next month.

This check works for any sale, however you ran it. All you need is a spreadsheet.

Want the longer version? The checklist for checking every price after any sale covers matching variants that have no SKU, prices edited mid-sale, and a free tool that compares the two files for you.

Step 1: Save a "before" file before the sale starts

  1. In Shopify admin, go to Products and click Export.
  2. Choose all products and export as a CSV for Excel, Numbers, or other spreadsheet programs.
  3. Keep four columns: Handle, Variant SKU, Variant Price, Variant Compare At Price.
  4. Save it as prices-before.csv, and also paste it into a Google Sheets tab named before.

Do not edit this file again. It is your record of what "correct" means. No before file? Your next best reference is an older export, a supplier price list, or last week's backup. It is slower and less exact, but better than checking by eye.

Step 2: Export again after the sale ends

Repeat the export once the sale has finished, keeping the same four columns, and paste it into a second tab named after. Check both tabs use the same column order: Handle in A, SKU in B, Price in C, Compare At in D.

Step 3: Compare the two files

In the after tab, add these formulas in row 2 and fill them down. Before price in E2: =XLOOKUP($B2, before!$B:$B, before!$C:$C, "missing"). Before compare-at in F2: =XLOOKUP($B2, before!$B:$B, before!$D:$D, "missing").

Prefer VLOOKUP? =VLOOKUP($B2, before!$B:$C, 2, FALSE) and =VLOOKUP($B2, before!$B:$D, 3, FALSE) do the same job.

Then a status flag in G2: =IF(E2="missing","NEW",IF(OR(ROUND(C2-E2,2)<>0, D2&""<>F2&""),"CHECK","OK"))

Filter column G to everything that is not OK. A price off by one cent counts, and so does a compare-at price that changed. If some variants have no SKU, add Option1 Value to both exports and match on Handle plus that column instead. Some rows will be flagged on purpose, such as products you repriced permanently. Everything else should be zero.

Four things this check usually finds

WhatWhy it matters
Leftover compare-at pricesStill above the price, the product looks on sale when it is not. At or below the price, the sale badge disappears or looks inconsistent.
A timezone surpriseMidnight UTC is 7:00 PM the previous day in New York in November. A sale set to end at midnight can end the evening before for US customers.
Merchant Center disagreeingFeeds can lag behind the revert and Google flags a price mismatch. Check Diagnostics again on Tuesday.
Variants only partly changedSort by Handle and look for products where some rows are OK and others are CHECK. Product pages hide this.

What about Shopify Rollouts?

In October 2026 Shopify added Rollouts, which can switch a catalog on and off on a schedule. That is useful for timing. But Shopify's help documentation states that it does not save a copy of the catalog as it was at that moment, so the before file from Step 1 is still yours to keep, and it is still the thing you compare against.

Or let this be automatic

If you would rather not do the spreadsheet work every sale, that is what SaleGuard is built for. Before a sale it backs up the whole store's prices. At the scheduled time it puts them back, then reads every variant back from Shopify and checks it matches the backup to the cent. If something is wrong, one click restores the backup. There is a free plan, so you can try it on a smaller sale first.

The habit

However you run the sale: save a record before, compare after.

Keep a recovery plan before you change prices

SaleGuard snapshots your original prices, previews every change, schedules the sale, and restores automatically when it ends. Install SaleGuard from the Shopify App Store to use it on your next promotion.

Add to Shopify — free