I am working on a POS and Inventory Management Web Application and am facing an issue in updating the price list.
When there is a change in the price of a product. I want to update the price in the database but this price change must not affect the old stock of the same product already in the store am looking for a logic to handle this.
How can I differentiate the old stock and the new stock with the updated price?