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?