I am running a multisite in wordpress and would like to merge all my customers' purchases to 1 subsite. The websites sell digital contentss mostly, but sell different types and run w/ considerably different logic. For one website, it has paywall that paid subscribers have access to paid contents with rolling subscription. Another website charges $1 for a permanent page access for each page. There also are websites that are linked to third party tools (Slack, Teams....) and grant contents access level membership to that service.
I've used various solutions for each website (used to be single sites), but since I now have consolidated all of them in a multisite, I wonder if there is a way to combine all transactions in one payment site, like https://payment.example.com, while my services are like https://service_number.example.com
So far, I had to run multiple queries and combined excel sheets, but if this works, for every monthly reporting, I just have to run a single query.