Home›Support›English Support›[Waiting for user confirmation] Customer list is not converted to correct currencies
[Waiting for user confirmation] Customer list is not converted to correct currencies
This is the technical support forum for WPML - the multilingual WordPress plugin.
Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.
Our wait time is higher than usual, please make sure you are meeting the minimum requirement - https://wpml.org/home/minimum-requirements before you report issues, and if you can take a look at current Known Issues - https://wpml.org/known-issues/. Thank you.
Background of the issue:
I am trying to view and export the customer list with sales made in different currencies converted to Euro, which is the default currency for my shop.
Symptoms:
The customer list and exported data show sales in different currencies without conversion to Euro, making the list misleading.
Questions:
Why are sales in different currencies not converted to Euro in the customer list?
How can I fix the currency conversion issue in the customer list?
I apologize for the delay in responding. I will handle this ticket; the reply time will be shorter now.
By default, WooCommerce records orders in the currency selected by the customer at the time of purchase. This means that when you view or export order data, it reflects the original purchase currency. WooCommerce Multilingual (WCML) facilitates multi-currency support but does not automatically convert and display all order data in the default currency in reports or exports. 
To convert the orders to the desired currency, you'll need custom code (which is outside the scope of our support).
to implement a custom function that converts order amounts to your default currency (Euro) during data export.
Here’s a general approach:
1. Use WCML Hooks for Currency Conversion:
• WCML provides hooks like wcml_raw_price_amount that can be used to convert prices to a specified currency. 
• You can create a custom function that applies this hook to convert order totals to Euro during the export process.
Example function:
function convert_price_to_euro($price) {
return apply_filters('wcml_raw_price_amount', $price, 'EUR');
}
