Bulk edit Shopify Compare At prices

The Compare At price field in Shopify is a feature used by store owners to display the original price of a product alongside a sale price. This field typically highlights discounts and attracts customers by showing the price difference. When a Compare At Price is set higher than the actual selling price, the product appears on sale on the Shopify storefront.

This guide will help you set up a column in your Mixtable spreadsheet to map to this field and show you how to use it to update the Compare At Price values in your Shopify products.

Note: In Shopify the Compare At Price value lives with the variants of products, and that each product has at least one variant. Therefore in the instructions below we’ll be working with a Products (with variants) worksheet.

How to set up the Compare At price in a spreadsheet column

• After installing the Mixtable Spreadsheet Editor app, navigate to a Mixtable workbook connected to your Shopify store.

• Select the Products (with variants) worksheet from your workbook. Add one if one does not already exist in your workbook.

• Right-click on the header of an empty column where you want to show the Compare At prices for your variants.

  • Select the Shopify sync settings menu option
  • In the mapping dialog, select the Core Field type radio button
  • Select the Compare At Price field from the dropdown

How to update the Compare At prices in bulk and sync to Shopify

In the Compare At Price column, set the desired “compare at” price for your products’ variants in the row representing each variant you want to update. When you’ve done so, press the Sync sheet to Shopify button, and Mixtable will set the new Compare At prices in your store.

How to use the Compare At prices in Shopify

Best practices for using Compare-at prices to show discounts in Shopify include:

• During sales periods such as Black Friday, Christmas, and the like.
• Offer discounts on stock that stayed for too long (e.g., over 6 months) in the warehouse or whose expiry date is approaching.
• Use compare at pricing discounts to promote new goods you’d like your users to try.

Be careful not to overuse the Compare at prices and discounts:

• Users may get used to seeing discounted prices and not purchase at regular prices anymore.
• Discounts may also devalue your goods’ perceived quality in the customers’ eyes, so be careful to maintain a healthy balance.

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.