Many stores offer multiple currency support to their customers to make shopping on their store more accessible. Metorik offers full multi-currency support, allowing you to see orders in both the currency of the transaction and the currency of your store.
We use hourly exchange rates from Open Exchange Rates to convert (learn more).
In this article
- Multi-currency in Metorik
- Setting the store currency
- Multi-currency for WooCommerce
- Multi-currency for Shopify
- Costs and profit handling
- Supported WooCommerce currencies
Multi-currency in Metorik
In general, there are 2 main ways that a store could have more than one currency:
- Customers can check out and pay in different currencies
- The store changes their main currency over time (perhaps they started in AUD but later switched to USD)
When looking at a table of orders, we'll show you both the original amount and the converted amount:
When you view the order, we'll show you it in the currency the order was made in:
Setting the store currency
When you first add your store to Metorik, we'll ask you to confirm your store's currency:
If you are using Shopify, this will be fixed to be the same as what it is in Shopify.
If you need to change it afterwards, please send us a message and we will change it for you.
Multi-currency for WooCommerce
Metorik will convert your order totals into the currency you set for the store when adding it to Metorik.
So if your store's currency is USD but you have an order that was made in the EUR currency, we look up the exchange rate on the date of the order and then use the USD amount in reports.
For orders made before the 22nd of November, 2016, we use the final exchange rate of the day the order was created (UTC). For orders made afterwards, the exchange rate used is the latest one within an hour of the order being made.
With refunds, we look up the exchange rate on the day the refund was created (so it may differ from the exchange rate of the order, if the order and its respective refund was created on different days).
Future dates: If for some reason the order/refund created date is in the future (eg. the order created date is June 20th, 2020 but today's date is June 15th, 2020), we will not convert the number and it will just be the same amount. If the order is updated/synced with us again in the future when the created date is no longer in the future, we will convert the amounts.
Supported multi-currency plugins for WooCommerce
We've confirmed our multi-currency support with these plugins (but it will work with any plugin that store's the order's currency properly in WooCommerce):
Multi-currency for Shopify
Shopify handles the multi-currency conversion when an order takes place, storing both the 'presentment price' (currency shown to customers) and the 'converted price' (converted into your Shopify store currency). Metorik stores both the original and converted totals that are calculated by Shopify. We then use the converted amount for reporting purposes.
In these cases, Shopify does not handle the conversion so we need to do it on our end to provide accurate reports:
- Refund totals
Costs and profit handling
When using Metorik's costs and profit system:
- You are only able to set costs in Metorik in your store's currency.
- Metorik will then store the cost of each order in your store's currency.
- The profit report and other reports will be in your store's currency.
Heads up: Our conversions are based on the rate of the order's created date (not paid date, as that's not always set). But it is unlikely that you received the exact amount that we convert it too, as bank's often charge different fees and the exchange rate can change over the course of the day (while we just use a single rate for the day). So while the converted amount we have is pretty accurate, it will never be the exact same as what you received, so you shouldn't use converted metrics for tax and similar reporting where precise numbers are needed.
|AED||United Arab Emirates Dirham|
|ANG||Netherlands Antillean Guilder|
|BAM||Bosnia-Herzegovina Convertible Mark|
|BYR||Belarusian Ruble (pre-2016)|
|CLF||Chilean Unit of Account (UF)|
|CRC||Costa Rican Colón|
|CUC||Cuban Convertible Peso|
|CVE||Cape Verdean Escudo|
|CZK||Czech Republic Koruna|
|FKP||Falkland Islands Pound|
|GBP||British Pound Sterling|
|HKD||Hong Kong Dollar|
|ILS||Israeli New Sheqel|
|KPW||North Korean Won|
|KRW||South Korean Won|
|KYD||Cayman Islands Dollar|
|LKR||Sri Lankan Rupee|
|NZD||New Zealand Dollar|
|PEN||Peruvian Nuevo Sol|
|PGK||Papua New Guinean Kina|
|SBD||Solomon Islands Dollar|
|SHP||Saint Helena Pound|
|SLL||Sierra Leonean Leone|
|STD||São Tomé and Príncipe Dobra|
|TTD||Trinidad and Tobago Dollar|
|TWD||New Taiwan Dollar|
|USD||United States Dollar|
|VEF||Venezuelan Bolívar Fuerte|
|XAF||CFA Franc BEAC|
|XAG||Silver (troy ounce)|
|XAU||Gold (troy ounce)|
|XCD||East Caribbean Dollar|
|XDR||Special Drawing Rights|
|XOF||CFA Franc BCEAO|
|ZAR||South African Rand|
|ZMK||Zambian Kwacha (pre-2013)|