This thread is resolved. Here is a description of the problem and solution.
Problem:
You are trying to view and export the customer list with sales made in different currencies converted to Euro, which is the default currency for your shop. However, the customer list and exported data show sales in different currencies without conversion to Euro, making the list misleading.
Solution:
By default, WooCommerce records orders in the currency selected by the customer at the time of purchase, and it does not automatically convert and display all order data in the default currency in reports or exports. To address this, you will need to implement custom code. We recommend using WCML Hooks for currency conversion. Specifically, you can use the WCML Hooks Reference to create a custom function that converts order amounts to your default currency (Euro) during data export. Here is an example function you might consider:
function convert_price_to_euro($price) { return apply_filters('wcml_raw_price_amount', $price, 'EUR'); }
Please note that this solution might be irrelevant if it's outdated or not applicable to your specific case. We highly recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If this does not resolve your issue, please open a new support ticket at WPML support forum for further assistance.
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.