Skip Navigation

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.

This topic contains 0 reply, has 1 voice.

Last updated by Otto 1 month, 1 week ago.

Assisted by: Otto.

Author Posts
April 2, 2025 at 5:59 am #16885284

frederikM-9

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?

April 4, 2025 at 12:24 pm #16897410

Otto
WPML Supporter since 09/2015

Languages: English (English ) Spanish (Español )

Timezone: America/Argentina/Buenos_Aires (GMT-03:00)

Hello,

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).

As an idea/example, you may use:
https://wpml.org/documentation/related-projects/woocommerce-multilingual/wcml-hooks-reference/#hook-1112712

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');
}

Best Regards,
Otto