This post is part of a weekly series by the Magento Enterprise Edition subscription support team covering tips, tricks and hints to some of the most common, and uncommon, issues as submitted by support customers.
Among the great features that Magento includes out-of-the-box, it’s known that dataflow will auto-convert the products prices to the used currencies on multiple websites installs for different geographic audiences that shares the same catalog.
On this post however we will be showing an alternative to import your catalog if the pricing for the different websites should not be the converted but actually have its own price expressed on the the desired currency.
As preparation we always recommend to first manually create one product under the each website level with all the values that you need on the profiler to display under columns (if CSV will be used) or Cells (if XML).
Once the products were entered the next part will be creating the export profile specific for each website in which you will find all the columns/cells needed for pricing.
Once done run the export profile to get the sample file and enter your products including the prices in numeric values as they should be expressed in the currency for the website.