How to set Shopify international 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 markets. In this guide, we will discuss how Mixtable can help you efficiently edit international prices for global markets, improving your e-commerce operations.

Note: Keep in mind that markets can only be created within Shopify, not Mixtable.

Add a column to show international prices for your variants

First, create a Products with Variants worksheet in your Mixtable workbook to manage your product variants and their respective international prices. To add columns for the international prices of each market you want to edit, follow these steps:

1. Open your Products 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 Price
6. Repeat steps 2-4 for each market you wish to edit.

Set a fixed international price for a variant

After creating columns for each market’s international prices you can now set fixed prices for your product 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 price for the given variant to its fixed value.

Reset Fixed International Prices to Automatically Calculated Prices

If you need to change a fixed international price back to an automatically calculated price, simply clear the value of the cell containing the fixed international price, by pressing Backspace/Delete for example. Once you initiate a Mixtable to Shopify sync the fixed price will reset back to the calculated one.

International price updates from Shopify to Mixtable

There may be instances when you need to synchronize international market prices from Shopify to Mixtable, such as after updating the calculated price for a specific market. Regrettably, automatic updates from Shopify to Mixtable 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 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