Imagine you have an order with a product priced 1,000 EUR.
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.