Skip to content

How to bulk edit compare-at prices in Shopify

Updated 30 Oct 2026 · 7 min read · Markdown

Compare-at price is a variant field, and the free admin bulk editor edits it. Products, select the products, Bulk edit, add the compare-at price column through Columns if it is not shown, enter the values, Save. For a large catalog, export the product CSV, edit the Compare-at price column, and import with "Overwrite products with matching handles".

The field is easy; the sale around it is not. A sale is two numbers per variant, the old price moving to compare-at and the price dropping, and it has a start, an end and a cleanup. This guide follows that order. For the other fields Shopify can bulk edit, see the overview of Shopify bulk edit methods.

Sale preview with old price, new price and compare-at price per variant
Price and compare-at move together. A preview that shows only one of them hides half the change.

What compare-at price does

Compare-at price is the "was" price. When it is higher than the price, most themes show it struck through next to the price, often with a sale badge. When it is empty, or not higher than the price, the variant shows as full price.

It lives on the variant, next to price, so a product with five sizes has five of them. Count variants, not products, before you start. And it is a display field, not a discount: discount codes and automatic discounts apply at checkout and never touch this column. A sale that must end on its own at midnight is a discount, not a compare-at edit.

Start a sale

Before anything else, export the current prices and compare-at values. That file is how the sale ends, and nobody regrets having it.

In the admin: Products, filter to the products on sale, select them, Bulk edit. Shopify's bulk editing page names price, SKU and compare-at price among the fields you can edit. Add the column through Columns if it is not shown. Edit two columns per variant: copy the current price into compare-at, then type the sale price. Save. Rows that fail stay marked; fix them and Save again. Nothing can be undone after Save.

By CSV: export, edit Price and Compare-at price, import with "Overwrite products with matching handles". Each variant is its own row with the URL handle repeated, so a formula runs per row. Keep only URL handle, Title, the option columns, Price and Compare-at price in the file. Keep the option columns: without them Shopify deletes the existing variants and creates a default one.

Two checks before Save or import. Filter for variants that already have a compare-at above price; a sale on top of a markdown is often below cost. And put the sale on every size: a sale applied at product level and fixed by hand per size is how one size stays at full price. See bulk editing variants for that side.

Percent off across a collection

The bulk editor has no formula. A 20 percent sale on 300 variants is 600 typed values, so a percentage has to be worked out somewhere first.

In a spreadsheet, the sale formula is compare-at = old price, price = old price times 0.8, rounded the way you want. Round in the sheet: 23.992 is not a price. A blank Price cell imports as 0.00, so filter for empty prices before importing. There is also a Compare-at price / International column; leave it out of the file unless you use it, because an included blank column is a column of clears.

Ablestar, Hextom and Matrixify run "set compare-at to current price, then lower price by 20 percent" as one task with filters, and several can schedule the end. Check whether a task skips variants already on sale and whether ending it restores the compare-at values that were there before, including empty ones. Backup windows and scheduling depend on app and plan.

In ApiMate the sale is a sentence: "20 percent off the Summer collection, never below cost." It copies each variant's price into compare-at and lowers the price, rounded half-up. A price that would fall below unit cost plus the margin you name is held at the floor; a variant with no room above cost is skipped, and so is one already on sale. Variants with no unit cost get the full discount under their own heading. Every row is shown before anything is written, and the free plan covers small jobs.

RouteDoes the mathFloor at costEnds the sale
Admin bulk editorNoNoBy hand, from your export
CSVIn the sheetIf you add the formulaRe-import the old file
Bulk-edit appYesDepends on appOften scheduled
ApiMateYesYesUndo on the task

End a sale

Ending is the start in reverse: the compare-at value goes back into Price and compare-at is cleared. In the bulk editor that is two columns again. By CSV, put the old price in Price and leave Compare-at price blank; with overwrite on, a blank cell in an included column is written as blank, which is what clears it here.

Order matters if you kept no export. Compare-at is then the only record of the old price, and clearing it first loses it. Copy it into Price, then clear.

In ApiMate, the end of a sale is Undo on the sale task, not a second sale. It writes back the exact old price and old compare-at for every variant, including a compare-at that was empty before. For other ways back after a bad write, see how to undo a bulk edit in Shopify.

Find stale compare-at prices

Most compare-at problems are not the sale; they are what is left after it. A price lowered for a reason that is not a sale (a cost drop, a competitor) keeps its old compare-at, and the store shows a permanent sale nobody planned. A price raised above an old compare-at, say from 40 with compare-at 50 to 55, leaves a "was" price lower than the price; depending on the theme it shows nothing or a struck-through price cheaper than the current one.

After any price change, filter for compare-at at or below price and clear those. ApiMate flags both cases on ordinary price changes and asks whether to clear them; the bulk price update case shows a full run.

Decide the end before the start

By hand, re-import, app schedule or Undo: pick one before the first price changes, and keep the pre-sale export either way.

SituationPriceCompare-atWhat to do
Start a saleLower itOld priceEdit both in one pass
End a saleBack to old priceClear itEdit both in one pass
Permanent price cut, no saleLower itClear it if setCheck for old compare-at values first
Price riseRaise itClear it if below new priceFilter for compare-at under price after

Every row edits two fields. A job that edits one is usually the mistake.

Questions

Can I bulk edit compare-at prices in Shopify?+

Yes. The admin bulk editor edits compare-at price per variant, and the product CSV has a Compare-at price column for large catalogs.

How do I remove compare-at prices from many products?+

In the bulk editor, clear the compare-at cells and Save. By CSV, include the Compare-at price column with blank cells and import with overwrite on; a blank cell clears the value.

How do I put many products on sale in Shopify?+

Copy each variant's current price into compare-at, then lower the price. The bulk editor needs both typed by hand; a CSV or an app can do the arithmetic.

Why does my product still show as on sale?+

Its compare-at price is still higher than its price. Clear the compare-at value, or set it equal to or below the price.

Is compare-at price the same as a discount?+

No. Compare-at changes the displayed price on the product. Discount codes and automatic discounts apply at checkout and leave the product price as it is.

Explore More

Related

Run this on your own catalog

Install from the Shopify App Store. Every write shows its rows before it runs, and applied jobs can be reverted from history.