Member-only story
the prices of products prudently
Get the most recent price applying a BOM logic
We all know that prices change. Promotions make things (temporarily) cheaper while inflation or market demand shows itself in higher prices.
When you want to review an invoice from a while ago, you need for that invoice the prices valid at that time. This is only possible when we timestamp prices.
In this blog we explain how to do that in .
The properties of products
Mostly products are grouped by categories and sub categories and it happens that one product fits several (sub) categories. The allocation of a product to a (sub) category is based on its properties. We can group all things blue, but likewise all things that have wheels or are cost more than $17 per unit.
Properties as I said define the product, some are fixed, others change. Availability can be seen as a property and so can price. Both can change. When we have orders but no products the property stock is a negative number. We have a so called back-order.
When the color of a product changes, it happens that it becomes a different product, with a unique product ID. When the price of a product varies, most of the time, we do not create a new product ID, we keep the…
