Start Free Trial
Start Free Trial

Bulk update Shopify Product price by Market (International Multi-Currency Pricing)

Featured image - bulk import, export, manage update Shopify Product Variant Market pricing 3

Using the Matrixify app you can bulk update, import, and export Shopify Product international pricing for your Shopify Markets.
Shopify Markets can be set up in your store for various use-cases such as the ability to manage international and region-specific pricing, set different currencies for various countries for multi-currency pricing, and more.
However managing these Product prices can be a time-consuming task, especially when you have large international Markets set up in your store. But don’t worry, we’ve got you covered!

In this tutorial, we’ll guide you through the process of exporting your current Product Market prices, making bulk changes in an Excel or CSV file, and then importing the updated multi-currency prices back into Shopify.
This will save you hours of manual work and ensure your Product international pricing is always up-to-date.

This tutorial is for bulk updating Market-specific Product international prices. To update regular prices you can look into our tutorial Bulk update Shopify product prices.

So, let’s dive in and start optimizing your Market pricing management process!

Steps in short

  1. Export Products with Basic Columns, Variants and Pricing by Market.
  2. Update pricing in the exported file.
  3. Save and import your file to bulk update Shopify Product Market prices.

1. Export Shopify products with Market pricing

To begin with, you’ll need to export your Shopify Products along with their international pricing.

In the Matrixify app Home page find the Export section and click “New Export” to open the New Export page.

In the “Format” section, it is suggested to select “Matrixify: Excel” format. This will be Excel XLSX file that is easy to understand and work on.
You can also select “Matrixify: CSV” format for CSV file, but they are not as user-friendly and should only be used if your amounts of data are close to or over Excel limits.

In the “Select Sheets” dropdown, choose “Products” and click on the section to open it.
Now you need to select a few specific columns:

  • from “Basic Columns” group select ID and Handle.
  • from “Inventory / Variants” group select Variant ID.
  • from “Pricing by Markets” group select all columns – Included / ..., Price / ... and Compare At Price / ....
  • you can also select any other columns you might need that can help you to identify Products, and their variants or set correct Market prices, such as Title, Variant SKU, Variant Price(for regular Product variant price), and many more. See Matrixify Product documentation explaining each column from the Matrixify Products template.

1 - bulk export Shopify Products with Market international regional multi-currency pricing

If you don’t need to export all Products, you can apply filters to export only the Products you need.
You can set filters by clicking the “Filter” button when creating your export.

Once you’ve selected the necessary options, click the “Export” button.
The app will then generate a file containing your Shopify Products along with the selected columns and Market pricing.

Note that exporting Products with Market pricing is very slow and speed is affected by the number of Markets in the store.

2. Update Market pricing in the exported file

Once the export has finished, click on the “Download Exported File” button to download your Excel file.
In this file you will see your exported Products and also columns indicating if the Product has been included in each Market and the Product fixed price for that Market if it is set.

The exported file will only have fixed prices for Market pricing. Relative automated prices are being set dynamically by Shopify.

See that the exported file has multiple rows, each row is a different Shopify Product Variant.
Each Market in the file has 3 columns:

  • Included / <Market> – indicates if the Product is or is not included in the specific Market. The value for this column is filled in only the Products first row because individual Product Variants cannot be included or excluded for the Market, only the whole Product can.
  • Price / <Market> – Shopify Product Variant currency-specific price in the Shopify Market.
  • Compare At Price / <Market> – Shopify Product Variant currency-specific compare at price in the Shopify Market.

1.2 - bulk exported Excel XLSX CSV Shopify Products with Market international regional multi-currency pricing

Now you can edit the file to change your Shopify Market pricing.

To set if Shopify Product is or is not included in a specific Market, you would need to change the value in the Included / <Market> column to TRUE for included in the Market and FALSE to not be included in Market.

If the Product is included in the Market then you can set the Price and Compare at Price columns to the value you wish for each Product Variant.
You can leave the price and compare at price fields empty in which case you will not have a fixed price set for Product Variant in the Market and Shopify will calculate the price automatically based on the adjustments you have set up in the Markets settings in your store.

2 - bulk exported Excel XLSX CSV Shopify Products with Market international regional multi-currency pricing

Once all the changes you need have been made, you can save the file.
Make sure that the sheet/tab name in the file remains as “Products” as it was exported. This will ensure that Matrixify detects the sheet correctly when importing.

3. Import file to bulk update Shopify Market prices

Now that the import file is set up, go into the Matrixify app in your Shopify store.

In the app Home page Import section, you can upload your file.
Wait for the app to analyze the file’s data and ensure that the app correctly detected the import as Products and that the Product count is correct.

See our “How it works” page for more details about the import process.

3 - bulk import update change set manage Shopify Products with Market international regional multi-currency pricing Excel XLSX CSV

If all looks correct, press the “Import” button and start the import.
Once your import is finished, head into your Shopify Admin -> Settings -> Markets section where you can open and view your Markets as well as Shopify Product Variant pricing in each Market.

4 - update Shopify Product Variant market prices bulk import

Good to know!