Product Catalogue with Wholesale Pricing

Topic Labels: Base design Collaboration
559 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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? 

1 Reply 1

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