Jetpack Stats > Store - display sales in USD even for orders in other currencies

[mxhassani]

Quick summary

Under Jetpack > Stats > Store

There seems to be an issue linked to the currency, where it only matches the store currency but not the order currency.

In this case, the main currency is USD, but the shop allows for multi-currency orders.

There is a ¥1,700 order, the user is seeing $1,700 in stats instead ¥1,700 or equivalent in $:

The correct amount is shown under Analytics > Overview:

5966005-zd-woothemes

[github-actions[bot]]

Support References

This comment is automatically generated. Please do not edit it.

• [ ] 5966005-zen

[cuemarie]

📌 SCRUBBING : RESULT - Replicated / Could Not Replicate / Uncertain

• Tested on Atomic – Replicated

📌 FINDINGS/SCREENSHOTS/VIDEO

• To test, I set up multiple currencies via WooCommerce Payments, and enabled Test Mode under WC > Settings > Payments
• I completed checkout for an order totalling ¥180.00 CNY. (USD Equivalent would be $26.00 USD)
• While my WooCommerce store does show the correct currency, the Jetpack Stats > Store page shows I made $180 USD on that sale

Screenshots/Recordings

📌 ACTIONS

• Assigned to OTHER
• @jeherve can you advise if this is a bug, or if we currently don't have support for multi-currency sales within Jetpack Stats' > Store? Thanks!

[cuemarie]

One other quick note, WooCommerce Payments' documentation on Multi-Currency notes the following about Analytics:

All data within analytics will be converted back to the store’s base currency. There should be no changes to the reports or any of the other analytics screens. This means you will not be able to see individual breakdowns of orders made in different currencies. A column has been added to the Orders analytics report to show which currency a customer used to complete the order.

This might mean that the solution here would be to convert sales back to the store's base currency in Jetpack Stats too - however the current behavior is just converting the currency, but not the actual amount the sale was worth, so sales are incorrect.

[jeherve]

can you advise if this is a bug, or if we currently don't have support for multi-currency sales within Jetpack Stats' > Store? Thanks!

I'm afraid I'm not familiar with this part of Calypso, so I cannot really help there. @psealock may know more than me about this.

[cuemarie]

📌 ACTIONS

• Due to the age of this issue, I've downgraded the priority from High to Normal to better reflect its status in the larger context of open bugs in this repo.