How to set Shopify international compare-at pricing

Managing Shopify international pricing for products can be a complex task for Shopify merchants. Shopify’s interface does not make the task easy. Mixtable simplifies this process by allowing you to view and edit Shopify product information in bulk. Functioning like Excel while running in your browser, Mixtable is a practical tool for businesses operating in multiple Shopify markets. In this guide, we will discuss how Mixtable can help you set Compare At Prices for your products when selling them in Shopify’s international markets.

Note: Keep in mind that markets can only be created within Shopify, not Mixtable. After you’ve created a market you can edit individual Compare At Prices in that market from Mixtable.

Note: You can set a Compare-At Price for a variant only if that variant also has a fixed international price established for the same market.

Add a column to show international Compare At prices for your product variants

First, create a Products - Complete (with Variants) worksheet in your Mixtable workbook to manage your product variants. Then, to add a column showing the Compare At prices for a Shopify market, follow these steps:

1. Open your Products - Complete (with Variants) worksheet in Mixtable
2. Right-click on the header of a column that isn’t yet mapped for syncing (these columns have a grey background, while columns set for data syncing have a light green background)
3. When you right-click, a context menu will appear. Choose the Shopify Sync Settings option.
4. Select the International Market Prices option. You’ll now see a dropdown listing the markets you have defined in Shopify. Select the one whose prices you’d like to load into the column.
5. In the Select data for selected market dropdown select Compare At Price
6. Repeat steps 2-5 for each market you wish to edit.

Set a Compare At Price for a variant for a given Shopify market

After creating columns for each market’s Compare At Price you can now set this price for your selected variants. To do this, enter the desired price directly into the corresponding cell in the respective market’s column. Note that the currency symbol in the cell needs to be the symbol of the currency specified for the market (e.g., EUR). After making your changes start the sync and Mixtable will set the Compare At Price for the given variant.

Remove Compare At Prices for a market

If you need to remove a Compare At Price for a Shopify market simply clear the value of the cell containing the Compare At Price, by pressing Backspace/Delete for example. Start a sync from Mixtable to Shopify and we’ll remove the Compare At Price value for the variants whose cells you modified.

International price updates from Shopify to Mixtable

There may be instances when you need to synchronize international market Compare At Prices from Shopify to Mixtable. Regrettably, automatic updates from Shopify to Mixtable for this are not available due to the absence of a mechanism in Shopify to notify Mixtable of changes. In this case, you must manually initiate the synchronization.

To do this, follow these steps:

1. Right-click on the header of a column displaying international prices for the desired market
2. Choose Shopify Sync Settings from the context menu that appears
3. A dialog box will open, presenting a button to synchronize the international Compare At Prices for the market with Mixtable
4. Click on this button, and Mixtable will initiate the data download process, eventually displaying the updated information in the worksheet