Where are the commissions per order item recorded?
With Yith affiliate these were stored as meta data so could easily be exported to google sheets for calculating a deduction from suppliers prior to paying commission to them.
All the referral data is stored at fa_referrals table, and for individual products, it's on the products column.
Shahjahan Jewel Thanks, so how does that get exported on a Order Item basis? This is essential for accounting purposes!
Shahjahan Jewel my end game is to be able to pass this Activity Item for Fluent Affiliate (using Fluent Cart) out to Google Sheets via some form of automation (FLowmattic / Bit Integrations) it would be amazing to be able to do this on an order line basis as commissions can be different by product and there maybe a few vendors products in the same order.
With that from a technical point of view (putting aside all the bells and whistles and bloat) i can run a Multi Vendor store with Fluent Cart and Fluent Affiliate.