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.

Important: Compare-at price belongs to the Shopify product variant, even when a product has only one variant. Use a Products (with variants) worksheet for this task.

Create a worksheet with product variants

If you are starting from the Mixtable dashboard:

1. Click Create Spreadsheet
2. Select the Full Product Info template
3. Choose the connected Shopify store if prompted
4. 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. Select an empty column with a non-green header
2. Click the green button in that column header
3. Select Shopify data fields
4. Find and select Compare at Price
5. 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.

Tip: Before lowering prices, copy the current Price values into Compare at Price. This preserves the original prices beside the new sale prices and makes it easier to restore them later.

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 changes
2. Check the affected variants, fields, and pending values
3. Correct any unexpected prices in the worksheet
4. Click Sync to Shopify 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
2. Clear the corresponding Compare at Price cells if you no longer want an original price displayed
3. Click Preview changes and confirm both fields
4. Click Sync to Shopify

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 changes, then click Sync to Shopify to send the approved values to your store.

You're ready!

Mixtable is an online spreadsheet designed to sync data with Shopify. It looks, feels, and behaves like Excel (including formulas), but runs in your browser. With Mixtable you can:

• Bulk add products to collections, edit metafields, add or remove tags;
• Change product prices, including international prices, and review price history;
• Manage customers with a spreadsheet CRM for Shopify;
• Use Excel features like sort ascending or descending, find-replace, filter, and more.

Best of all, you can sync changes back to Shopify with a single click. Find out more about the Mixtable suite of products here.