Help

Changing line item price affects historical order values

Topic Labels: Base design
1785 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniel_Hamer
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi there.

I have a base set up for my businesses orders. I have a table for all my products, a table for line items per quote etc.

However if I want to change the price of one of my products it will alter the value of line items from previous orders. Which I use for historical reporting etc.

Is their any way to hard code the price of the product at the time of purchase?

Thanks
Dan

2 Replies 2

No, unfortunately, this is not possible in Airtable. :frowning:

One solution for this is to create new products every time the price changes, and give each product a slightly different SKU #.

Another solution would be to copy-and-paste the price at the time of data entry into a normal number field, instead of using a lookup field. (This could be automated.)

Another solution would be to create a whole bunch of different price fields in your products table, where each price would represent a different date range. Then, lookup all of those price fields into your line items table and create a formula that picks the right price based on the date of the quote.

Hey guys,

An alternative idea on @ScottWorld recommendations is to add a discount field per product that will update a new field “Sold price” while the product price can remain steady.
What do you think?

Thanks