How to Bulk Edit Shopify Prices Per Market

Shopify Markets lets you sell into a dozen countries from one store. What it does not give you is a way to see a dozen countries' prices at once. Each market has its own price list, each price list opens in its own screen, and the only bulk tool is a percentage adjustment off your base price.

A percentage is fine until it isn't. Exchange rates move. Local competitors sit at a price point you need to match. Some markets carry duty you absorb and some do not. And a blanket +12% produces prices like €34.87, which no European shopper has ever seen on a shelf.

This guide covers the alternative: all your markets as columns in one sheet, every price explicit, edited together and synced back in one pass.

How market pricing is actually stored

This matters, because it explains why the admin feels the way it does.

Your primary market price is not a price list entry at all — it is the variant's own price, the one you see on the product page. Every other market is an entry in that market's price list, a separate object with its own currency and its own adjustment rules.

So "change the price in Germany" and "change the price" are two genuinely different operations on two different parts of Shopify. SheetSync exports both as plain columns and works out which is which on the way back in:

• Price (Primary) and Compare At Price (Primary) — your base variant price
• Price - Germany, Price - Japan, and so on — that market's price list entry
• A matching Compare At Price - <Market> for each

A single-market store gets plain Price and Compare At Price columns instead, with no suffixes. The sheet shape follows your store.

What you can do once the markets sit side by side

Price to local psychology, not to a formula

A conversion gives you €34.87. What you want is €34.95, or €35. With every market in a column you can round the way each market expects — =CEILING(D2, 1) - 0.05 for one, =ROUND(D2, 0) for another — and see all of them in one view before you commit.

Catch the markets that drifted

Add a column comparing each market back to base at today's rate. Anything more than a few percent off is a price you set eight months ago and forgot. Sort by that column and the stale markets rise to the top.

Protect margin per market

Landed cost differs by destination — shipping, duty, local fulfilment. Put the per-market cost in its own column and conditionally format any price that falls below your floor. You find the loss-making market before your accountant does.

Run a sale in one country only

Set Compare At Price - France to the old price and drop Price - France. The strikethrough appears for French shoppers and nowhere else. When the sale ends, clear the compare-at column for that market and it reverts.

Open a new market properly

Copy your base price column, apply the conversion, round to local convention, adjust the twenty products where you know the local market is tougher, and sync. A launch price list that is actually considered, built in minutes rather than skipped because there was no time.

Step by step

1. Open Pricing Sync in SheetSync and connect your Google account.
2. Create or connect a pricing spreadsheet. SheetSync reads your store's markets and builds a column pair for each, so the headers always match your real setup.
3. Export. Every variant arrives as a row, every market as columns.
4. Edit — formulas, conditional formats, rounding rules, pasted competitor data.
5. Paste formula output as values in the price columns.
6. Sync back. SheetSync writes the primary market to the variant and every other market to its price list.
7. Check the sync log, then open a product and switch markets in admin to confirm.

The rules that keep a bad cell from becoming a bad price

Pricing is the one sheet where a typo costs real money, so the sync is deliberately strict:

• A cell that is not a number is rejected, never guessed. TBC, ask Dave or 12.3.4 is reported as an error on that row and nothing is written for it. A typo can never silently become a free product.
• Currency symbols and thousands separators are tolerated. A leading £, $ or €, plus spaces and commas, are stripped before the number is read, so pasted data does not need cleaning first.
• A blank price means "leave this alone". It does not zero the price — a product with no price cannot be sold, so a blank is treated as no instruction. This also means clearing a cell is not how you remove a market price.
• A blank compare-at price does clear it. That is how you end a sale: empty the compare-at cell for that market.
• A price of 0.00 syncs, but is flagged. It comes through as a warning rather than an error, because free products are occasionally intentional and you should have to look at it.
• A variant missing from the sheet is left untouched. Deleting a row is not a way to delete a price.

Practical notes

Currency belongs to the market, not the cell. Write 34.95 in the Japan column, not ¥34.95. The price list carries the currency.

Rounding is yours to control. Wrap conversions in ROUND so you never ship a price with four decimal places behind it.

Stage a large repricing. Filter to one market, sync, confirm on the storefront with that market selected, then do the next. Reversing one market is easy; reversing nine at once is not.

Keep the dated copy. Duplicate the tab before a rate update. It is the cheapest rollback you will ever have.

Who this is for

Stores selling into several countries where a flat percentage is too blunt: brands matching local competitors, anyone absorbing duty into shelf price, and teams whose pricing is agreed in a spreadsheet and then re-keyed into Shopify market by market. If your pricing meeting ends in a spreadsheet, that spreadsheet can be the thing that updates the store.

Selling the same catalogue in several languages too? The same approach applies to content — see bulk translating Shopify products.