· DataEase · Tutorials  · 3 min read

Bulk Update Multi-Currency Pricing

Setting fixed, rounded prices per market/currency manually can be extremely time-consuming. DataEase makes it easy: export your product variants, edit dynamic market price columns, and import them back to Shopify—all without relying on exchange-rate conversions.

🎯 Goal

Set fixed, rounded prices per market/currency for many variants at once—without relying on exchange-rate conversions—by editing dynamic multi-currency price columns and importing with DataEase.

📋 Step-by-Step Instructions

1. Export Products with Variants

In DataEase, go to New Export → Products. Include at least:

Identifiers:

  • id
  • variantId (recommended)
  • Optional: handle, variantSKU

Base price:

  • variantPrice (and optionally compareAtPrice)

Dynamic market price columns:

  • They appear per market/currency exactly as in your store (e.g., prices: {Market Name} / Price, prices: {Market Name} / CompareAtPrice)

You can also filter the scope (e.g., by Collection ID, tags, vendor).

2. Prepare Per-Currency Prices in Excel/Sheets

Open the exported file in Excel or Google Sheets. Decide on your rule (percentage uplift, fixed delta, smart rounding):

+10%: =ROUND([basePrice]*1.10, 2)

+2.00: =ROUND([basePrice]+2, 2)

.99 rounding: =ROUND([basePrice]*1.10, 0)-0.01

Then paste results into the target market columns (e.g., prices: EU / Price).

Tip: Keep currency-appropriate decimals (usually 2).

3. Edit the File

For each row you want to update:

  • Set variantCommand = UPDATE for rows you change
  • Fill market/currency price cells you want to override (e.g., prices: US / Price, optional ... / CompareAtPrice)
  • (Optional) Update the base variantPrice too, if your default currency changes
  • To remove a manual override and return a market to dynamic conversion, clear that market’s price cell

When done, save the file as .xlsx or .csv.

4. Import & Validate

  1. In DataEase, start New Import
  2. Upload your edited file
  3. Map columns (Variant ID or unique SKU → variant; market price fields)
  4. Run Validation

Fix anything flagged in Validation Status (e.g., non-numeric values, missing identifiers, duplicate SKUs).

5. Verify

After the job completes, spot-check a few products in Shopify Markets and on the storefront (switch currency/market) to confirm the new fixed prices are displayed.

📝 Important Notes

  • Column names are dynamic. Use them exactly as exported (they reflect your Markets setup)
  • Fixed market prices override exchange-rate pricing. Clearing a market’s cell reverts it to conversion rules
  • Prefer variantId for matching; use SKU only if it’s unique and stable
  • If you also maintain compare-at pricing per market, fill the matching ... / CompareAtPrice columns

💡 Minimal CSV Examples

Set EU and UK fixed prices:

variantId,variantCommand,prices: EU / Price,prices: UK / Price
gid://shopify/ProductVariant/111,UPDATE,24.99,21.99
gid://shopify/ProductVariant/112,UPDATE,29.99,26.99

Add compare-at for a promo in CA:

variantId,variantCommand,prices: Canada / Price,prices: Canada / CompareAtPrice
gid://shopify/ProductVariant/555,UPDATE,19.99,24.99

Remove a manual override (fallback to conversion):

variantId,variantCommand,prices: US / Price
gid://shopify/ProductVariant/777,UPDATE,

🎉 That’s it!

Your multi-currency prices are now updated in bulk.
If you run into any issues or have questions, feel free to contact our support team.

Share: