Currency conversion for Google Shopping Feed in Magento

When generating Google Shopping Feeds you need to make sure to use the correct currency for the target country. Thus, if you are planning for instance to target Great Britain make sure to use GBP as currency for prices in the Products Feed. This can be easily achieved by using the Magento extension Wyomind Data Feed Manager. It will automatically convert from the default currency currently set to the one specified in the product pattern configuration.

Enable conversion currencies

For instance, let’s say EUR is your default currency. Then you first need to ensure that your target currencies are enabled in the Magento backend via System -> Configuration -> Currency Setup: Magento Currency Setup

Automatic currency conversion for Products Feed

In order for the automatic conversion to work you need to ensure that built-in the conversion web service ran at least once. Thus, either run the web service manually or better set it up to run on a regular basis through your cron setup: Magento Currency Conversion Webservice Setup The Data Feed manager currency conversion will work properly once the initial conversion rate data is available. Make sure to update the conversion rates on a regular basis!

Syntax for price conversion

In order to use the price conversion in the Data Feed manager use the following syntax:

{normal_price,[GBP],[0]} GBP

This will convert the default currency set to GBP based on the current conversion rates determined by the web service. Have a look at the Wyomind Data Feed Manager documentation for more information on how to use this extension.

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.