Skip to content

NewSchedule your Black Friday sale: prices drop at the start and go back by themselves. See how

Bulkvane

Shopify compare-at price: what it is and how to set it in bulk

Compare at price meaning on Shopify: the original price, shown struck through. Why a sale doesn't show, and how to set or clear compare-at prices in bulk.

The Bulkvane teamPublished 3 min read

What the compare-at price does

Every variant has a price and an optional compare-at price. The price is what the customer pays. The compare-at price is what it used to cost, or what it costs elsewhere. Shopify's themes show a sale badge and the struck-through compare-at price only when the compare-at price is higher than the price.

PriceCompare-at priceWhat shoppers see
36.9949.0036.99 with 49.00 struck through (a sale)
49.00(empty)49.00 (no sale)
49.0045.0049.00 (no sale, because compare-at isn't higher)

Why your sale price isn't showing

  • The compare-at price is lower than or equal to the price. Bulkvane warns you about this in the import preview: “Compare-at price isn't higher than the price, so no sale will be shown.”
  • It's set on one variant but not the others: each variant has its own compare-at price.
  • The CSV used a decimal comma or a currency symbol, and the value didn't import. Bulkvane reads “49,00 €” as 49.00 and tells you.
  • Your theme hides it on collection pages. Check the theme's settings for sale badges.

Set compare-at prices in bulk with a CSV

  1. Export the products with Bulkvane (or Shopify), with the Variant Price and Variant Compare At Price columns.
  2. In the spreadsheet, copy the Variant Price column into Variant Compare At Price. That's the old price.
  3. Put the sale price in Variant Price. For 20% off: =ROUND(X2*0.8, 2), filled down and pasted back as values.
  4. Import with Update only, check every old and new price in the preview, and apply.

The free price update template has the columns ready. To end the sale, undo the import (prices and compare-at prices go back), or import a file with only the ID, Variant ID and an empty Variant Compare At Price column in Replace mode (Replace clears every empty cell, so leave other columns out).

Or without a spreadsheet

A Bulkvane price rule does the same in one form: choose the products, “Change by a percentage” -20, round up to .99, and Compare-at price → Show the old price struck through. If the new price is lower, the old one becomes the compare-at price. The same form can also Remove compare-at prices to end a sale.

For a sale with an end date, a sale campaign sets the compare-at prices at the start and restores everything at the end, by itself.

Frequently asked questions

What is compare-at price in Shopify?

The original price of a variant. When it's higher than the price, Shopify themes show the variant on sale, with the compare-at price struck through.

How do I remove compare-at prices in bulk?

Use a Bulkvane price rule with Compare-at price → Remove it. Or export the products with only the ID, Variant ID and Variant Compare At Price columns, empty the compare-at column, and import with Replace mode, which clears empty cells.

Is compare-at price the same as a discount?

No. A compare-at price changes how the product's price is shown; a discount is applied in the cart and at checkout. You can use both.

Can the compare-at price be lower than the price?

Shopify will save it, but no sale is shown. Bulkvane flags it in the import preview so it doesn't go unnoticed.

Related guides

How to bulk edit Shopify productsFree CSV templatesBrowse the help center

Preview every change.Undo any import for 30 days.

Install free