Adjusting new price for replenishable

[erks89]

Hello,

How do we update new buy price compared to the old one without changing the previous profit/loss? Sorry i am new to this sheet and learning but i have new stock which i purchased cheaper for the same sku

[Scott]

Hi,
If you update the price on the Product Master sheet, it will only populate the updated (current) price to new sales.  When you download new sales it checks the current purchase price from the Product Master and pulls that value in to the Sold items side.

[erks89]

What if you still have stock of the old item cost price?
 

[Scott]

You may consider changing the SKU and having two entries in product master in order to pull in from old price until the new priced inventory is all that remains.