Forum Discussion
How to add new price in excel without affecting the previous sales?
Hi everyone, I want you all to assist me with something in Excel, please. I have a spreadsheet for my products, those products change costs from the manufacturers on a regular basis and if it happe...
Maybe you should keep the history price in the transactions , I mean each sales records should contain the sales price also. because the price is not designed to calculate the history sale. It is just a property of the items. All your sales info include the price for the transaction should be recorded in the transaction table. in addition , the price can be original price, customer pay price, merchant income price, platform subsidy price ,etc. all of them should be recorded in each transaction data, or you would miss something