Product Catalogue with Wholesale Pricing

[ajmcfarlane]

I want to setup an airtable structure with the following

Products -

Lists the standard products (name, sku, price) - there are 12 products

Customers -

List of the customers and products from first table with an option to override the price of each product for that customer 

What would be the best way to set this up? 

[TheTimeSavingCo]

Hm, I think I would end up creating one field per product in the Customers table to represent the price override, and so for example if Customer 1 has a price override for Product A, I'll put fill in the 'Product A' field for Customer 1, and leave everything else blank

Then in the Sales table (or whichever equivalent table where you link the product sale to the customer), use lookups and formula fields to check whether there's a price override