Majority of times I've seen this being solved with shopping cart items being copied from the main product table by SKU with the current price.

There is a TTL on the shopping cart itself. However, that meant for a period of time you had a frozen cost per-line-item in a shopping cart.