I'm currently running a Magento store using USD as my default currency. I want to import products from different providers into my store. Half of those providers are giving me CAD prices and the other half, USD.

I've created an OpenOffice file for each of those provider for mass importing with Magmi but I can't figure out how to specify the currency.

So I want all those products to be on the same website and everything showing in USD, does anyone know how to accomplish this?

Thanks !

1 Answer 1


It's not possible to upload a product in Magento with 2 different currencies for a website view. As far as I can see you have 2 options

  • Start a website view for CAD prices (This may not be ideal based or you audience, etc)
  • Convert the CAD prices into USD and import them under the price field in Magento.
  • That's what I'm doing right now. I convert all my prices into USD before importing. But that also means I have to re-import all my new prices when the exchange rate changed.
    – Joey
    Commented Jul 7, 2016 at 16:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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