PriceGrid

Blog · 19 October 2026

How to take a percentage off Shopify prices, with the old price crossed out

"20% off" is the most common sale there is, and shoppers expect to see it: the old price crossed out, the new one next to it, on the product page and in every collection. Here are the ways to do that in Shopify, what each one shows, and how to make sure the prices go back afterwards.

Two ways to run a percentage sale

1. A discount: simplest, but often invisible until checkout

An automatic discount (Discounts → Create discount → Amount off products) takes a percentage off selected products or collections, with a start and an end date. Shopify ends it exactly on time, and your prices never change, so there's nothing to restore.

The catch is visibility. Whether shoppers see the reduced price on product and collection pages depends on your theme. Many themes show it only in the cart or at checkout, so a shopper browsing your collection sees full prices and no "sale" at all.

2. A price change with compare-at: visible everywhere

To show the sale on every page, in search and in product feeds, change the price itself and put the old price in the compare-at price field. Themes show the compare-at price crossed out next to the price. Shopify's admin doesn't do the arithmetic for you, though: the bulk editor sets the values you type, so "20% off" means working out each variant's new price yourself.

Doing a percentage price change by hand, with a CSV

  1. Export the products (Products → Export, CSV for Excel or plain CSV). Keep a copy of this file untouched: it's your record of the original prices.
  2. In a working copy, keep Handle, the option columns (or Variant SKU), Variant Price and Variant Compare At Price. Delete the other columns so the import can't change anything else.
  3. Copy the price into compare-at for every row whose compare-at is empty or lower than the price. Leave rows that already have a higher compare-at alone, or the crossed-out price would drop.
  4. Calculate the sale price with a formula such as =ROUND(price*0.8, 2) for 20% off. Round to two decimals, or to a price ending you use (like .99), consistently.
  5. Check a handful of rows, especially products whose variants have different prices.
  6. Import the working copy with "Overwrite products with matching handles", and spot-check a few products in your store.

When the sale ends, do the reverse from your untouched export: put the original prices back and clear (or restore) the compare-at prices. This is the step that most often goes wrong, so schedule the time for it before the sale starts. See how to schedule a sale that ends on time and why sale prices sometimes don't switch back.

Things to check before a percentage sale

Doing it with PriceGrid

In PriceGrid, type -20% in a product's price cell and every variant gets 20% off its own price, rounded to the cent (-5 takes off a fixed amount instead). The margin column updates as you type. When you save, the review step lists every variant with its old and new price, and the option Show the current price as the compare-at price fills in the crossed-out price for each variant whose price goes down, keeping any higher compare-at a variant already has. Choose Run a sale with a start and an end, and PriceGrid puts every price and compare-at price back when it ends. If a price was changed somewhere else during the sale, it stops for that variant and tells you instead of overwriting it.

PriceGrid is a Shopify app for editing prices in bulk, taking a percentage off whole products, scheduling price changes, and running sales that put the original prices back on their own. It's free to start.

See PriceGrid on the Shopify App Store