Skip to main content

How to convert all product prices to a new currency using our Pricing rule?

In this tutorial, you’ll learn how to convert your entire product catalog to a different currency using the “Modify price by percent (%)” pricing rule.

Written by Melanie

When to use this rule

Currently, our app does not support automatic currency conversion. However, you can still achieve this by using a workaround with our Pricing Rules feature. Simply follow the steps below to convert your product prices based on the current exchange rate.

Use this method when you want to automatically convert all product prices from one currency to another (for example, EUR → USD or USD → EUR) based on the current exchange rate.

Example 1: EUR → USD

Let’s see if you have products priced in EUR and wants to sell them in USD.

Step 1: Find the exchange rate

Look up the current currency conversion rate like for example. 1 EUR = 1.17 USD

Step 2: Calculate the percentage value

Since the pricing rule works with percentages, you’ll need to convert the exchange rate into a percentage modifier using this formula:

({Currency Exchange Rate} - 1) * 100

Using our example:

(1.17 - 1) * 100 = 0.17 * 100 = 17

So the percentage value you’ll use in the rule is 17

Step 2: Create a pricing rule

Go to your pricing rules and select Modify price by percent (%)

Step 4: Set the multiplier

  • Set the multiple value to: 1.17

This means all product prices will be multiplied by 1.17, effectively converting EUR → USD.

Step 5: Add filters (optional)

You can apply this rule only to specific products by using filters such as:

  • Product category

  • Brand

  • Tags

  • Price range

Example 2: USD → EUR

If a seller wants to convert prices from USD to EUR, the process is the same but reversed.

Step 1: Find the exchange rate

For example USD to EUR exchange rate and you'll get like 1 USD = 0.85 EUR

Step 2: Calculate the percentage value

Use the same formula:

({Currency Exchange Rate} - 1) * 100

Calculation example:

(0.85 - 1) * 100 = -0.15 * 100 = -15

So the percentage value for the rule will be -15

Step 2: Create a pricing rule

Go to your pricing rules and select Modify price by percent (%)

Step 3: Set the multiplier

  • Set the multiple value to: 0.85

This will convert all USD prices into EUR.

Step 4: Apply filters (optional)

As needed, restrict the rule to specific products or collections.

Important notes

  • Always use the current exchange rate for accuracy.

  • Review rounding settings if your platform supports them.

  • You can create multiple rules for different product groups or currencies.

Did this answer your question?