Customer Specific Price Lists


#1

Hi,

I’m just getting used to Airtable and coming here as a fairly heavy Excel user.

I’m interested in using Airtable to maintain a shared base of customer details and pricing.

We have a range of products and some customers (duh1).

Each customer has various details such as address and contacts.

Every product has a range of details such as SKU code and description.

Every customer buys a range of the products but each customer buys them at different prices.

Basicially I’m trying to figure out the best way to set this up in Airtable…

Thanks in advance for any advice!


#2

I’d start by looking at the modifications I made to the Product Catalog and Orders template in order to support pricing schedules. That solution assumed all customers would be charged based on a date-driven price list, but there’s no reason it wouldn’t support a number of simultaneous, customer-specific schedules.