In recognition of the rapidly changing nature of Food & Drink products, the system defines Product & SKUs separately.
Products hold the high-level/cross-SKU information that rarely changes, SKUs hold the rapidly changing properties such as Best Before Date, Price promotions and more. The store sells a single SKU of a product at a time, switching to the next SKU when required.
This method ensures the customer is shown the exact product they will receive when they place their order. When an order is placed, the SKU is attributed to that order for fulfilment.