I have two stores setup in Magento, one is purely for US customers and it's currency is set to be USD.

I'm trying to import products so that the prices that are supplied are interpreted as US dollars, but when I import them, they are treated as GBP. Is it possible to import the prices in dollars?

  • Do you mean once they are imported they are showing as GBP and not USD? or are you asking how to convert prices on import?
    – SR_Magento
    Feb 28, 2014 at 15:08
  • I mean they are showing as GBP in the admin, and on the front end the GBP to USD conversion is taking place. I don't want this to happen though, I just want the import to consider the price in USD when it imports and the product prices under that store view to be in USD.
    – user5483
    Feb 28, 2014 at 16:07
  • What are you using to import your products? Are you using a module to manage your currencies? Out of the box Magento does not calculate differences between currencies.
    – SR_Magento
    Feb 28, 2014 at 16:21
  • Just the standard CSV Import functionality. Could you recommend a module which would do the job? Are there any free ones? Thanks
    – user5483
    Feb 28, 2014 at 16:24

2 Answers 2


When importing products the price is on the default currency.
The simplest way to overcome this is to change your import file prior to importing and multiply all the prices with the conversion rate.

  • Thanks, but unfortunately the currency conversion rate would change so I don't think this is a long term solution.
    – user5483
    Feb 28, 2014 at 16:10

You need to ensure that the currency is set correctly on the store view that is assigned to US customers.

-->System -->Configuration -->Select Store View --> Currency Setup

Set "Default Display Currency" and "Allowed Currencies" to "US Dollar" for this store view.

  • I have this already set up, the only place where the places are being displayed in USD is on the front end and there is a conversion taking place, from the price data that I have supplied into USD. I want the import to consider the prices dollars in the first place and not do any conversion, if that it is possible anyway?
    – user5483
    Feb 28, 2014 at 16:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.