Multiple Currencies
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
- Carts
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.
Supported currencies
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.
Symbol | Name |
---|---|
AED | United Arab Emirates Dirham |
AFN | Afghan Afghani |
ALL | Albanian Lek |
AMD | Armenian Dram |
ANG | Netherlands Antillean Guilder |
AOA | Angolan Kwanza |
ARS | Argentine Peso |
AUD | Australian Dollar |
AWG | Aruban Florin |
AZN | Azerbaijani Manat |
BAM | Bosnia-Herzegovina Convertible Mark |
BBD | Barbadian Dollar |
BDT | Bangladeshi Taka |
BGN | Bulgarian Lev |
BHD | Bahraini Dinar |
BIF | Burundian Franc |
BMD | Bermudan Dollar |
BND | Brunei Dollar |
BOB | Bolivian Boliviano |
BRL | Brazilian Real |
BSD | Bahamian Dollar |
BTC | Bitcoin |
BTN | Bhutanese Ngultrum |
BWP | Botswanan Pula |
BYN | Belarusian Ruble |
BYR | Belarusian Ruble (pre-2016) |
BZD | Belize Dollar |
CAD | Canadian Dollar |
CDF | Congolese Franc |
CHF | Swiss Franc |
CLF | Chilean Unit of Account (UF) |
CLP | Chilean Peso |
CNY | Chinese Yuan |
COP | Colombian Peso |
CRC | Costa Rican Colón |
CUC | Cuban Convertible Peso |
CUP | Cuban Peso |
CVE | Cape Verdean Escudo |
CZK | Czech Republic Koruna |
DJF | Djiboutian Franc |
DKK | Danish Krone |
DOP | Dominican Peso |
DZD | Algerian Dinar |
EEK | Estonian Kroon |
EGP | Egyptian Pound |
ERN | Eritrean Nakfa |
ETB | Ethiopian Birr |
EUR | Euro |
FJD | Fijian Dollar |
FKP | Falkland Islands Pound |
GBP | British Pound Sterling |
GEL | Georgian Lari |
GGP | Guernsey Pound |
GHS | Ghanaian Cedi |
GIP | Gibraltar Pound |
GMD | Gambian Dalasi |
GNF | Guinean Franc |
GTQ | Guatemalan Quetzal |
GYD | Guyanaese Dollar |
HKD | Hong Kong Dollar |
HNL | Honduran Lempira |
HRK | Croatian Kuna |
HTG | Haitian Gourde |
HUF | Hungarian Forint |
IDR | Indonesian Rupiah |
ILS | Israeli New Sheqel |
IMP | Manx pound |
INR | Indian Rupee |
IQD | Iraqi Dinar |
IRR | Iranian Rial |
ISK | Icelandic Króna |
JEP | Jersey Pound |
JMD | Jamaican Dollar |
JOD | Jordanian Dinar |
JPY | Japanese Yen |
KES | Kenyan Shilling |
KGS | Kyrgystani Som |
KHR | Cambodian Riel |
KMF | Comorian Franc |
KPW | North Korean Won |
KRW | South Korean Won |
KWD | Kuwaiti Dinar |
KYD | Cayman Islands Dollar |
KZT | Kazakhstani Tenge |
LAK | Laotian Kip |
LBP | Lebanese Pound |
LKR | Sri Lankan Rupee |
LRD | Liberian Dollar |
LSL | Lesotho Loti |
LTL | Lithuanian Litas |
LVL | Latvian Lats |
LYD | Libyan Dinar |
MAD | Moroccan Dirham |
MDL | Moldovan Leu |
MGA | Malagasy Ariary |
MKD | Macedonian Denar |
MMK | Myanma Kyat |
MNT | Mongolian Tugrik |
MOP | Macanese Pataca |
MRO | Mauritanian Ouguiya |
MTL | Maltese Lira |
MUR | Mauritian Rupee |
MVR | Maldivian Rufiyaa |
MWK | Malawian Kwacha |
MXN | Mexican Peso |
MYR | Malaysian Ringgit |
MZN | Mozambican Metical |
NAD | Namibian Dollar |
NGN | Nigerian Naira |
NIO | Nicaraguan Córdoba |
NOK | Norwegian Krone |
NPR | Nepalese Rupee |
NZD | New Zealand Dollar |
OMR | Omani Rial |
PAB | Panamanian Balboa |
PEN | Peruvian Nuevo Sol |
PGK | Papua New Guinean Kina |
PHP | Philippine Peso |
PKR | Pakistani Rupee |
PLN | Polish Zloty |
PYG | Paraguayan Guarani |
QAR | Qatari Rial |
RON | Romanian Leu |
RSD | Serbian Dinar |
RUB | Russian Ruble |
RWF | Rwandan Franc |
SAR | Saudi Riyal |
SBD | Solomon Islands Dollar |
SCR | Seychellois Rupee |
SDG | Sudanese Pound |
SEK | Swedish Krona |
SGD | Singapore Dollar |
SHP | Saint Helena Pound |
SLL | Sierra Leonean Leone |
SOS | Somali Shilling |
SRD | Surinamese Dollar |
STD | São Tomé and Príncipe Dobra |
SVC | Salvadoran Colón |
SYP | Syrian Pound |
SZL | Swazi Lilangeni |
THB | Thai Baht |
TJS | Tajikistani Somoni |
TMT | Turkmenistani Manat |
TND | Tunisian Dinar |
TOP | Tongan Paʻanga |
TRY | Turkish Lira |
TTD | Trinidad and Tobago Dollar |
TWD | New Taiwan Dollar |
TZS | Tanzanian Shilling |
UAH | Ukrainian Hryvnia |
UGX | Ugandan Shilling |
USD | United States Dollar |
UYU | Uruguayan Peso |
UZS | Uzbekistan Som |
VEF | Venezuelan Bolívar Fuerte |
VND | Vietnamese Dong |
VUV | Vanuatu Vatu |
WST | Samoan Tala |
XAF | CFA Franc BEAC |
XAG | Silver (troy ounce) |
XAU | Gold (troy ounce) |
XCD | East Caribbean Dollar |
XDR | Special Drawing Rights |
XOF | CFA Franc BCEAO |
XPD | Palladium Ounce |
XPF | CFP Franc |
XPT | Platinum Ounce |
YER | Yemeni Rial |
ZAR | South African Rand |
ZMK | Zambian Kwacha (pre-2013) |
ZMW | Zambian Kwacha |