• Resolved cuboid

    (@cuboid)


    Hi there, could someone explain what those red order values are?

    https://prnt.sc/rgGqUKME-PdD

    They do not match the conversion rate.

    I think because of the wrong conversion value showing there, the WooCommerce analytics order values are totally wrong.

    The EURO€320.40 is AUD$569.36 but it showing AUD$440.11. What are those red numbers? It’s off by around $120. And I think that affects the WooCommerce reports.

    We also use currency conversion app which increase price in some countries. How does WooCommerce analytics understand that? I’m guessing it just gets the final price but as you can see in my screenshot that red number is totally wrong.

    Please help.

Viewing 10 replies - 1 through 10 (of 10 total)
  • Sai (woo-hc)

    (@saivutukuru)

    Hi @cuboid,

    Thanks for reaching out! The red numbers in Analytics usually represent order totals converted from your store’s base currency using the exchange rate available at the time of reporting; they’re not pulled directly from the plugin’s frontend display.

    To better understand the discrepancy, could you please share a few details?

    1. Which currency conversion plugin or app are you using? (e.g., WOOCS, Aelia Multi-Currency, etc.)
    2. Does your store’s base currency match the one shown in the WordPress > WooCommerce > Settings > General section?
    3. When you view the specific order in WooCommerce → Orders, what total appears there in the order details screen?
    4. Is the same mismatch visible on all orders or only for certain ones (e.g., from specific countries)?

    This will help us see whether Analytics is using your store’s base currency totals or if the plugin modifies them before they’re saved.

    Once we have this info, we can guide you on whether it’s a reporting discrepancy or if your currency plugin needs a compatibility adjustment.

    Thread Starter cuboid

    (@cuboid)

    Hi there, we use the Curcy plugin to adjust currency conversion. Also increase the price on some currency.

    https://codecanyon.net/item/woocommerce-multi-currency/20948446

    Yes, so in Curcy, the default currency is set to AUD, and the in Woocommerce general settings the store locations is Australia. (Is this what you mean?)

    Please see here regarding order details total:

    https://prnt.sc/pVS2kIdJ4wYH

    The conversion total is $536.71 AUD. There is huge $120 AUD difference.

    All orders have this problem. Now I’m thinking maybe that $440.11 AUD did not account for the 30% increase that we set in the Curcy plugin.

    Do you agree with this? Thank you for support.

    Plugin Support Frank Remmy (woo-hc)

    (@frankremmy)

    Hi @cuboid,

    Thank you for sharing these details about using the Curcy multi-currency plugin and highlighting the specific discrepancy with the order totals.

    It does seem likely that the difference you are seeing, where the WooCommerce order total is $440.11 AUD but the conversion total shows $536.71 AUD, is related to the 30% price increase configured within the Curcy plugin. The core WooCommerce order total reflects the base currency amount before the Curcy adjustments, while your plugin applies the markup for certain currencies, which may not always sync directly with the WooCommerce Analytics reporting.

    WooCommerce Analytics typically reports sales data using the store’s base currency totals as recorded at checkout, without automatically factoring in dynamic price modifications made by third-party currency plugins like Curcy. Because Curcy adjusts prices on the fly to incorporate markup or different exchange rates, these changes might not be fully reflected in the Analytics data unless there is explicit plugin integration for reporting.

    To help resolve this:

    • Confirm if the Curcy plugin provides any built-in support or recommended add-ons for ensuring Analytics includes the adjusted prices, or if there are hooks for syncing the correct totals.
    • Check if updating to the latest version of Curcy includes improvements around reporting compatibility with WooCommerce.
    • Consider reaching out to Curcy’s support for guidance on how they recommend handling Analytics reporting discrepancies.
    • You could also test with a few orders to compare the frontend prices, order details, and Analytics totals to isolate the exact difference patterns.

    If adjusting Analytics to fully reflect the increased prices from Curcy is critical to your reporting, exploring a custom integration or alternative multi-currency plugins with native WooCommerce Analytics compatibility might also be worth considering.

    I hope that helps. Let us know if you need anything else.

    Thread Starter cuboid

    (@cuboid)

    Hi thank you for reply.

    I gave the Curcy devs access to our store but they still are saying it is not their plugin issue.

    Here is what they said:

    The difference you’re seeing isn’t caused by our plugin. Our plugin only handles the price on your site at checkout. Once the order is passed to the payment gateway, additional conversions or fees are managed on their side, and we don’t have control over those calculations.

    Hi @cuboid,

    Thank you for the clarification and for getting back. However their response doesn’t fully account for how WooCommerce works and the integration with their plugin.

    By default, as my colleague explained, WooCommerce stores data using the default price and currency set in Analytics. Since their plugin sits in the middle to apply a new rate or perform currency conversion before checkout, if it isn’t properly integrated to override WooCommerce’s stored values, the payment gateway will still use the default WooCommerce amount. This means the plugin isn’t correctly converting or passing the right amount to the gateway.

    In this scenario, the best people to troubleshoot the issue are the plugin developers, because WooCommerce itself does not perform currency conversion the amount processed is entirely determined by what the plugin sends and the plugin should also have built in feature to modify the value saved to analytics.

    Thread Starter cuboid

    (@cuboid)

    Hi there. Thank you for reply.

    I had a response from the plugin devs. Does this sound correct? Thank you for support.

    The price increase is correctly calculated on your site during the checkout process, our plugin handles that part. After that, the payment gateway takes over and performs its own conversions and fee calculations. Those additional adjustments happen outside of our plugin and are not something we can control or modify.

    For that, the difference you’re seeing in WooCommerce Analytics comes from how the payment plugin processes and reports the final value, not from our plugin’s calculations and I’m sorry I can’t help take a deeper look. It would be best to contact your payment plugin’s support team to confirm how they process and report those amounts. They should be able to clarify why the analytics values appear differently.

    Hi @cuboid,

    Thanks for the update and for sharing what the Curcy team said. Their point about gateways handling final conversions is partly true, but in this case, WooCommerce Analytics doesn’t pull data from the gateway; it reports whatever totals WooCommerce saved at checkout.

    That means if Analytics shows the lower amount, it’s likely because WooCommerce is saving the base price before Curcy’s adjusted total is applied. Let’s double-check that:

    1. Open one of the affected orders in your admin area.
    2. Scroll down and open the Custom Fields section (enable it under “Screen Options” if you don’t see it).
    3. Look for the fields _order_total and _order_currency.
      • If _order_total shows the lower AUD amount, which means Curcy didn’t update WooCommerce’s stored order values before checkout completed.
      • If it shows the higher converted amount, then we’ll need to look at the Analytics data or payment plugin next.

    This quick check will tell us whether the issue is with the data WooCommerce saved or how Analytics is reading it. 

    If the lower amount is stored, you can ask the Curcy developers whether their plugin has an option or hook to make Analytics record the converted totals.

    Let’s start with that and see what the order meta shows.

    Thread Starter cuboid

    (@cuboid)

    Thank you for the explanation and guide.

    Those fields do not exist in my ‘Custom Fields’ section.

    Screenshot: https://prnt.sc/MU-a3TFfUR4w

    Plugin Support shahzeen(woo-hc)

    (@shahzeenfarooq)

    Hi there!

    Thank you for sharing more details about the issue. To determine whether the problem is caused by your currency plugin or if WooCommerce Analytics is not compatible with your current currency switcher, could you please do the following?

    1. Create a staging site. You can use the following plugin to create a staging site https://wordpress.org/plugins/wp-staging/
    2. Deactivate your current currency conversion plugin.
    3. Install and activate this free plugin instead: Currency Converter.
    4. Enable test mode in your payment method and try placing a few test orders.

    Then, check if the issue still occurs. This will help us better understand which plugin is causing the problem.

    Plugin Support thelmachido a11n

    (@thelmachido)

    It’s been a while since we heard back from you for this reason we are closing this thread. 

    If WooCommerce has been useful for your store and you appreciate the support you’ve received, we’d truly appreciate it if you could leave us a quick review here: 

    https://wordpress.org/support/plugin/woocommerce/reviews/#new

Viewing 10 replies - 1 through 10 (of 10 total)

You must be logged in to reply to this topic.