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.

International prices for Shopify variants in a spreadsheet

First, create a Products (with variants) worksheet in your Mixtable spreadsheet 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 drop-down, select Price
6. Repeat steps 2-4 for each market you wish to edit.

Pro-tip: Use the International Prices pre-built template

Use the pre-built spreadsheet to load your international prices with one click from the Mixtable dashboard.

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

Automatic updates from Shopify to Mixtable are not available for international market prices. Shopify does not notify Mixtable when prices change outside of Mixtable (for example, when a market rule recalculates a price). You must trigger the download manually.

Whenever a worksheet contains at least one international market price column, click the Market & B2B prices download button in the Shopify sync widget to pull the current prices from Shopify and update the relevant cells in your worksheet.

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.