Let’s say you have an order with a product priced at 1 000 EUR. Then, you change the product price on the Products Settings page to 2 000 EUR. The existing order has the previous price of 1 000 EUR.
Changes to the product price will only affect new opportunities and sales going forward.