PPCDATAFEED

How to convert product prices to another currency in a feed

A rule with Currency converter: take price, from EUR to USD, at the Lithuanian Bank or Stripe rate. Rates refresh themselves; you get a 2-decimal number.

Open in the app →About this feature

Selling abroad from a store that exports one currency? Convert the prices in the feed for that market instead of keeping a second price list.

  1. Open the data source, go to Rules and click Add rule - for example “Price in USD”.
  2. Under Then pick the field to write - price, or a new one such as price_usd (New columns in the Products tab) - and choose Currency converter.
  3. Set Price to price, From EUR, To USD and the Rate: Lithuanian Bank (daily official rates) or Stripe (live market rate). Check rate shows the rate the rule would use now.
  4. Check Preview changes, then Save rule.
Rule “Price in USD”: if All, then  Currency converter - Price price, From EUR, To USD, Rate Lithuanian Bank, Check rate

Example

Preview changes: price_usd 99.03 for price 89.00, 72.21 for 64.90, 132.41 for 119.00
  • price 89.00 EUR → price_usd 99.03 (at the Bank of Lithuania rate of the day, 1 EUR = 1.1127 USD)
The result is the amount only, without a currency code. Add the code in the export's Fields (for example price_usd + USD), and keep each market in its own export - see Create a feed export.

Still stuck? Write to info@ppcdatafeed.com - we answer ourselves and can set it up with you.