Multiple currency per site

[anonymous-matomo-user]

I have a site that converts in both USD (banners) and EUR (shop).

It would be useful to be able to track conversions in different currencies for a site.

[mattab]

It would be, but currency conversion would be tricky (we'd have to call webservice to know about currencies), which is do-able of course, but not priority at this stage.

[anonymous-matomo-user]

It would be better to maintain several balances, one per currency. Currency conversion doesn't happen in realtime, it happens when funds are transferred from one account to another.

[mattab]

This was also reported in #11854

We have a fairly pressing need to be able to track the currency with an eCommerce order. We receive purchases in many currencies on the site and at the moment they are all recorded in the Piwik site currency which causes large discrepancies with the actual value of the orders. I appreciate that to reconcile the different currencies would require some kind of an exchange rate but this should at least be exposed for development of a plugin if not in the core Piwik code.

[itseoconsulting]

Currently we implement a JS based workaround for Matomo only converting any shop currency into USD and firing eCommerce events to Matomo. Unfortunately it's not Matomo WooCommerce Plugin compatible :)

[uhlhosting]

@mattab this cannot be lower for ever... Its a must for stores with multiple currencies, and these are many...

[andyodoo]

is there is any update for this issue

[michaelr524]

+1

[jarstelfox]

Hey there! I have a possible idea.

Instead of currency conversion as mentioned by @mattab on #3812 (comment)

Would it be possible to add a currency param to the API? i.e:

trackEcommerceCartUpdate( 100, 'USD' )
trackEcommerceCartUpdate( 100, 'EUR' )

This would help allow multiple currencies per site, but leave any currency conversion up to the implementor.

[atom-box]

Customer asked for this in their commerce site:

"Our (clients) are always selling their tickets in more than 1 currency. "

"I saw on some forums that the recommendation would be to have 1 site per currency. " (This absolutely won't work for us.) "The concept of market is generally way more complex in this industry than having a .fr tracking in EUR and a .com tracking in USD."

"There are also some live system to convert the currency during the booking flow. Do you plan anytime to support multicurrency tracking ?"

[gorfo66]

Exact same need than atom-box.
Our company sells in various currencies. The concept of "1 site, 1 currency" is not sustainable. The company needs to be able to have an aggregated view of its sales no matter in which currency the products where purchased.

I can understand this is a fairly complex demand, but it is a must have for most of world wide companies.

[gorfo66]

Any process on this feature ?

[goochj03]

Another customer asking about multi-currency tracking "I would also like to know if i can set a specific currency for each segment.
In my account, the site 12 is covering worldwide payment I created a segment for each country but the currency is the same for all"

[mikeh-github]

+1 also for multicurrency. We accept 17 currencies on our website and creating multiple instances is not feasible, plus we need a single view of our website and ecommerce performance. Adding support for multicurrency would allow us (and I'm sure many others) to move from google analytics to matomo. Either proposed solution discussed above would be acceptable, i.e. (1) converting currency to primary currency as per google analytics ecommerce or (2) reporting on actual currency of transaction and show multiple balances per currency of transaction. Option two seems preferable and offers a more accurate view of ecommerce data, or offering a choice between the two would be even better. Please prioritise this feature so that we can finally ditch google analytics. Thanks.

[adsham]

Another vote for multicurrency - Many websites now support different currencies (google supports it), our new client being one of them - it makes ecommerce tracking somewhat useless on such websites.

Thanks!

[atom-box]

Another upvote here:

I have been running ... Google Analytics 3 instance for a few years now and the setup we have been using is as follows.

Sweden and all the other countries have their own currency and time zone setup, this so sales and data can be viewed locally and make sense. (But) then a meta view (like your Rollup) is set on Chicago time zone, and currency is set to USD.

This has worked well for us and my goal is to achieve the same (/close to) setup with Matomo.

[atom-box]

Another request here:

I understand that Matomo only support a single currency per site for ecommerce data. Given the fact that _____ is a global company, this is troublesome for our business getting accurate reporting for our transactions across the globe.

[atom-box]

Another request here:

We were looking for multi-currency support for the Matomo Integration with Woocommerce. This doesn't seem to be currently available, and is already a feature request.

We'd be happy to reconsider Matomo when this feature has been implemented.

[MatomoForumNotifications]

This issue has been mentioned on Matomo forums. There might be relevant details there:

https://forum.matomo.org/t/multi-currency-ecommerce-tracking/6621/7

[erikarenhill]

We have moved from GA to Matomo but this is a dealbreaker which might force us to move to another service when going to sell in multiple countries. This feels like a such basic feature for an ecommerce tracking to allow multiple currencies. Please add this!

[itseoconsulting]

We added this feature to our Matomo instances a while ago, and it’s been working well. However, I haven’t had the time to create comprehensive documentation, nor is it universal code that can simply be copied and pasted. Yet, on the Matomo Dashboard, it correctly displays conversions from other currencies, showing both the original currency and amount. I’m uncertain about sharing it on GitHub or a similar platform, especially since it needs to undergo quality control and documentation on my end. I’m swamped with daily tasks since a while, and I’ll keep it in mind, and if I find some unexpected free time, I’ll prepare something. But please, don’t start chasing me about it just yet. Best, Pak Kriss

…

--- Sent from my mobile device. Check out our local weather conditions at Bali on YouTube ***@***.***/live (Note: This link works only if the live stream is online)

On Wed, 4 Oct 2023 at 00.23 Erik A ***@***.***> wrote: We have moved from GA to Matomo but this is a dealbreaker which might force us to move to another service when going to sell in multiple countries. This feels like a such basic feature for an ecommerce tracking to allow multiple currencies. Please add this! — Reply to this email directly, view it on GitHub <#3812 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AIB3OD56E33HHNSXMBXVUWTX5Q3YZAVCNFSM4G6MUKA2U5DIOJSWCZC7NNSXTN2JONZXKZKDN5WW2ZLOOQ5TCNZUGUZTEMJTGIZQ> . You are receiving this because you commented.Message ID: ***@***.***>

[mehov]

The problem with one currency = one domain is that if your system is otherwise the same, you will lose the ability to look at the bigger picture.

For example, imagine a multistore that runs on multiple domains but is otherwise the same website, the same CMS, the same back office etc. If the analytics are fragmented per domain name, it will no longer be possible to have reports across the whole system

[diosmosis]

A matomo for wordpress user requested this in: matomo-org/matomo-for-wordpress#1002

[atom-box]

A user requested this today.

Feature: All Websites dashboard
Like: No
Feedback:
Total revenue is not counting with fact, that we have multiple currencies...
Source: On-Premise

[flowdee]

+1 for this feature

[tomeda]

10+ years and still nothing?!!!

[goochj03]

Another custom request for multiple currency support

[dassels]

+1 for me as well.

[hanbga]

This is a must have in 2024. +1 for this feature

[AdamMcAddEm]

+1 for this feature please! Let's get this going.

[Gleb532817]

+1 for this feature

[atom-box]

I am posting Ronan's workaround
A Matomo multi currency converter example

[Normandygirl]

This is important to someone who contacted me. Could Matomo please provide a guide for how to do this. :-)

[Chardonneaur]

+1 for this feature by a user today.
I created a hack https://www.youtube.com/watch?v=qmNo_dOcp44 but not helping for users who would like to have it at the item level.

[mattab]

Thank you for all the input on this feature request. I've discussed with a team member a potential solution based on our analysis. It's not scheduled yet, but just some notes to not forget later:

Proposed Implementation:

1. Daily Exchange Rate:

   • Leverage an existing web service to fetch daily exchange rates.
   • Conversion will occur directly at tracking time for simplicity, as this avoids requiring a new database column and ensures values are stored in the base currency of the site.
   • Note: The value will reflect the exchange rate on the day it was tracked.

2. Currency Parameter in API:

   • Extend existing API methods (setEcommerceView, addEcommerceItem, trackEcommerceOrder) to include an optional "Currency" parameter.
   • If no currency is specified, default behaviour applies (base currency of the site).
   • If a currency is provided, it represents the currency in which the transaction occurred, and the value will be converted to the base currency at tracking time.

3. Revenue Tracking:

   • Continue to use existing parameters in the tracking API (e.g., revenue, ec_st, ec_tx, ec_sh, ec_dt), with converted values stored in the base currency.

Considerations and Trade-offs:

• Historical Data: If a user changes the base currency for the site, historical reports will not adjust. This is an acceptable trade-off given the complexity of multi-currency support.
• Ecommerce Backend Discrepancy: There may be slight discrepancies between the ecommerce backend and Matomo reports due to daily exchange rate differences.
• Simplified Approach: This proposal does not support full multi-currency per site but focuses on converting all values to the base currency at tracking time.

This approach balances implementation simplicity with user needs, addressing a key pain point for many global ecommerce sites while avoiding significant architectural changes. Feedback is welcome before we proceed further!

[Gorkyman]

another upvote