Looking for a little help either building or advising on this build.
We are a credit broker B2B2C. I’m building an Airtable base to manage client onboarding, management and some internal BDM - CRM features. I need some help working out how to structure ‘rate cards’ per merchant (client) initially…
Each merchant has a different combination of lenders
Each merchant has a different combination of finance products to offer their customers from those lenders.
Each merchant may be charged a subsidy (or paid a commission) at different rates (depending on size etc) on the same product with the same lender
We may receive different commission rates from the lenders so need to be able to articulate this too.
The end goal here is to have a ‘rate card’ against each merchant record. I believe I need to look at the many-to-many links but just want some advice on how best to structure this.
Thanks in advance!