This tutorial assumes you already know what Two-Way Sync is and how to configure it. If not, please review the How Two-Way Sync Works tutorial first.
1. Choose the Products - Region Catalog Prices template
From the home page, select the Update Products category in the template filter bar and click Create on the Products - Region Catalog Prices template. If you are configuring a spreadsheet from scratch, click New Spreadsheet, select Two-Way Sync as the sync direction, and then choose the Products - Region Catalog Prices template.
2. Understand region catalogs
Region catalogs (also called price lists) let you set different prices for different markets or customer groups in Shopify. For example, you might have a Europe catalog with EUR prices and a North America catalog with USD prices. The Products - Region Catalog Prices template adds one set of price columns per catalog, so you can update all of them from a single spreadsheet.
In the Format Data step, open Manage Columns and scroll to the catalog sections. Each catalog in your Shopify store appears as a group with three fields: Published, Price, and Compare At Price. Check the ones you need. The resulting column names follow the pattern Price (Catalog Name Region Catalog) and Compare At Price (Catalog Name Region Catalog).
3. Update catalog prices in the spreadsheet
After the first export runs, you will see one row per product variant with the current catalog prices filled in. Edit the cells for the variants and catalogs you want to update. The following fields are required and must not be modified:
- Id (Product) — The Shopify product ID. Exported automatically; do not modify it.
- Id (Variant) — The Shopify variant ID. Exported automatically; do not modify it.
Enter prices as plain numbers without currency symbols; for example 24.99. To remove a compare-at price for a catalog, clear that cell completely. Only rows where you change at least one cell will be processed on import.
4. Validate and import
Once your prices are ready, go back to eCommix and click Sync next to your spreadsheet. In the modal, click Validate first to preview which rows will be updated before anything is sent to Shopify.
After validation, check the STATUS column in the sheet. Rows ready to import show VALIDATED: Variant will be updated. Once satisfied, click Import to push the changes to Shopify.
After the import finishes, the STATUS column updates to UPDATED for each successfully saved row. If you are not familiar with the Sync flow, the How Two-Way Sync Works tutorial walks you through it step by step.
To update base variant prices (the default price, not market-specific), see the Updating Product Prices from Google Sheets tutorial.
