Articles on: Frequently Asked Questions (FAQ)

Fixed rate Currency Converter

Convert supplier product prices from a foreign currency into your store's native currency by setting up a fixed exchange rate multiplier using Price Conditions. This ensures your Shopify product listings reflect accurate, converted prices based on your supplier's source feed.


Available on: ✔️ Add | ✔️ Update



How to Set Up Fixed Rate Currency Conversion


Go to App → Feed Settings → Step 4: Field Mapping


  1. Look Up Exchange Rate: Open an external converter such as Google Currency Converter to check the current conversion rate between your supplier's currency and your store currency (e.g., 1 EUR = 1.08 USD).

Google Currency Converter

  1. Locate Price Field: Find the Price field in your field mapping list.
  2. Open Smart Settings: Click the Smart Settings (gear icon) next to the Price field to open the configuration modal.
  3. Add Conversion Condition: Click Add Condition, select Any from the condition dropdown, and input your conversion formula multiplier (e.g., *1.08).

Add Price Condition Multiplier

  1. Save Settings: Click Save Settings to apply the fixed rate conversion across all incoming prices.


Always calculate the multiplier formula as: Target Store Currency / Supplier Source Currency.



Price Condition Currency Conversion Breakdown


1. Universal Multiplier (Flat Rate)

Using the Any condition applies the specified exchange rate multiplier across every product in the feed, regardless of its original price.


For example, if your supplier quotes €100 and the conversion formula is *1.08, the resulting Shopify price will be $108.00.


To incorporate a profit markup (e.g., 20%) alongside currency conversion, combine the exchange rate and markup into a single multiplier (e.g., 1.08 * 1.20 = 1.296).


2. Tiered and Multi-Condition Pricing

Stock Sync allows you to add multiple conditional formulas to handle different price brackets or margins alongside your currency conversion.


Condition rules are evaluated sequentially from top to bottom until a matching condition is met.


Condition (If)

Price / Formula (Then)

Result / Explanation

Any

*1.08

Multiplies all supplier prices by 1.08 to convert EUR to USD.

< 20

*1.08 + 5

Converts EUR to USD and adds a $5 shipping buffer for lower-priced items.

20 - 100

*1.08 * 1.25

Converts EUR to USD and applies a 25% profit margin.

> 100

*1.08 * 1.15

Converts EUR to USD and applies a 15% profit margin for higher-tier products.



Key Rules & Technical Details


  • Fixed vs. Live Rates: Stock Sync applies a static fixed rate multiplier; it does not automatically fetch real-time fluctuating market rates. Update the multiplier manually if market exchange rates shift.
  • Automatic Symbol Stripping: Stock Sync automatically strips common currency symbols (such as $, €, £, ¥) from raw feed cells before computing the formula.
Priority sequence: Raw Source Price → Price Condition / Currency Multiplier (*1.08) → Price Rounding Rules → Final Shopify Price.



Troubleshooting Steps


  • Issue: Converted prices display unexpectedly high or low amounts. → Solution: Check your multiplier math to confirm you multiplied by the target currency exchange rate rather than dividing or inverting the currency pair.
  • Issue: The formula fails to calculate during the feed process. → Solution: Ensure there are no spaces or unsupported symbols in the formula field (e.g., use *1.08 instead of x1.08 or * 1.08).
  • Issue: Converted price has too many decimal places (e.g., $108.3456). → Solution: Enable Price Rounding in the Price field Smart Settings to round values to two decimal places or to specific endings like .99.



Good Articles to Continue


Updated on: 04/11/2026

Was this article helpful?

Share your feedback

Cancel

Thank you!