matomo-org / matomo-for-wordpress

Get a fully functioning Matomo Analytics for your WordPress. Star us on Github? +1. Matomo is the leading open alternative to Google Analytics that gives you full control over your data. Privacy is built-in. 100% data ownership, no one else can see your data. We love Pull Requests!
https://matomo.org
GNU General Public License v3.0
119 stars 25 forks source link

Support a different currency per order (with WooCommerce integration) #1002

Open registeringemailforvimal opened 9 months ago

registeringemailforvimal commented 9 months ago

Hi, I use the "WooCommerce Price Based on Country" plugin where the currency is changed to the users local currency. This is very convenient and seamless for the visitors to my shop. However, when I look at the Matomo E-Commerce report, the orders are only shown in the base currency which is SEK in my shop since I am located in Sweden. However, I get orders in USD, Euro, UK Pounds. And those are reflected as 100 sek instead of 100 USD or Euro etc. Is there a way that the e-commerce report can show accurate data and use the standard currency conversion from Yahoo and use the order currency code from the orders? In WooCommerce reporting, the sales report shows orders correctly in the order currency. Also, the standard WooCommerce revenue report shows the sales report in SEK by converting orders from order currencies to the shop currency using some standard currency rate (I guess from the currency rate I set in the currency plugin or some standard rate online. Please fix this issue as the e-commerce report is pretty unusable. All other reports are excellent and gives so much of insights. Best regards, Vimal.

Screenshot 2024-01-09 at 14 04 02 Screenshot 2024-01-09 at 14 04 22 Screenshot 2024-01-09 at 14 04 48 Screenshot 2024-01-09 at 14 05 41 Screenshot 2024-01-09 at 14 06 55 Screenshot 2024-01-09 at 14 07 52
diosmosis commented 9 months ago

Hi @registeringemailforvimal, I'm sorry you're dealing with this. This is currently a limitation of the core Matomo product, each tracked website is only associated with a single currency.

That said, having a specific currency per order is possible to implement in the future. It would be a significant change though, so it will not be possible to implement it immediately.

diosmosis commented 9 months ago

Note the core issue is here: https://github.com/matomo-org/matomo/issues/3812

diosmosis commented 9 months ago

After some discussion this will be implemented by the core team hopefully some time this year. Keeping this open since it after it is implemented it may require some extra work to integrate with woocommerce.