Bulk edit Shopify compare-at prices

Shopify uses a variant’s compare-at price as the original price shown beside a lower selling price. For example, if Price is $80 and Compare-at price is $100, your storefront can show $100 crossed out beside the $80 sale price.

With Mixtable Spreadsheet Editor, you can see every variant’s price and compare-at price together, update many values with a spreadsheet, review the pending changes, and sync them to Shopify when the sale is ready.

Create a worksheet with product variants

If you are starting from the Mixtable dashboard:

1. Open your Mixtable dashboard and click Create spreadsheet at the top of the page. If you haven't created a spreadsheet yet, click Browse all templates below the dashboard's suggestions instead. In the Create spreadsheet window, find Full Product Info under Products, or type its name in the search box, and click it. Mixtable creates the spreadsheet and fills it with data from your Shopify store.
2. Open the Products (with variants) worksheet

The template includes the regular Price column. Add Compare-at price if it is not already present.

Add the Shopify Compare-at price column

1. Click ＋ Shopify data in the header row of an empty column, or choose Column > Add Shopify data… from the menu bar. The field picker opens and asks What should column E show?, with your column’s letter in place of E
2. Type Compare-at price in the search box, or click Pricing in the list of sections on the left
3. Click Compare-at price. The panel on the right explains the field and shows an example from your worksheet
4. Click Save Column

Mixtable loads the current Shopify compare-at price for every variant into the new column.

Bulk update compare-at prices for a Shopify sale

Each row represents one product variant. Update the Price and Compare-at price cells for the variants you want to put on sale.

For a normal sale display:

• Price should contain the lower sale price
• Compare-at price should contain the higher original price
• The compare-at price must be higher than the price for Shopify themes to present it as a markdown

You can type values directly, paste a block of prices from Excel or another spreadsheet, drag values down, or use formulas. If only part of your catalog is going on sale, turn on the worksheet Filter and narrow the visible rows before editing.

Preview and sync the price changes to Shopify

Edits stay as draft changes in Mixtable until you intentionally send them to Shopify.

1. Click Preview at the top right of the spreadsheet
2. Check the affected variants, fields, and pending values
3. Correct any unexpected prices in the worksheet
4. Click Sync when the preview is correct

This review step is especially important when a pasted range or formula changes many Shopify variants at once.

End a sale and remove compare-at prices

When the promotion ends:

1. Restore the normal values in the Price column. If you didn’t keep a copy, right-click a variant’s Price cell and choose View cell history to see its price before the sale
2. Clear the corresponding Compare-at price cells if you no longer want an original price displayed
3. Click Preview and confirm both fields
4. Click Sync

Do not clear the compare-at prices without checking the Price column. If the lower sale prices remain, the products will still sell at those lower prices.

Compare-at price troubleshooting

The product does not look discounted on the storefront

Confirm that the variant’s Compare-at price is higher than its Price. Also check how your Shopify theme displays sale pricing, because storefront presentation is controlled by the theme.

I see more than one row for a product

That is expected. Compare-at price is stored per variant, so a product with several sizes or colors has one row for each variant. Update every variant that should participate in the sale.

I need different compare-at prices for an international market

The standard Compare-at price field is the store’s base variant value. For fixed market-specific prices, use the international market compare-at price guide.

The changes are visible in Mixtable but not Shopify

Cell edits are drafts. Open Preview, then click Sync to send the approved values to your store.