Portal | Homepage | Blog

Amazon Mapping. Converting prices to different currency


RMS can handle multiple currencies. These are stored in the exchangerate table. We can multiply the price in a price field (Price, WebPrice, PriceA, PriceB, PriceC) by the exchange rate of a currency in RMS.
You need to determine which id the currency you are converting to has.

<MAPPING TARGET="product_pricea">case when (PAM_WebPrice &gt; 0) then (PAM_WebPrice * (SELECT exchangerate from currency where id=2)) else (price* (SELECT exchangerate from currency where id=2) )end</MAPPING>

Amazon 501. Frequently Asked Questions (FAQ)