The order stored a reference to the product rather than a copy of it, so when the product changed or was deleted the order lost its meaning. An order confirmation should be a photograph of what was true when the customer paid: description, specification, price, tax rate and delivery promise, captured before anything moves on.
Transcript
[0:03.10] Ever open an order, click through to the product and it's gone, deleted or replaced by something else?
[0:09.76] For one of our clients that happens every single sale.
[0:13.72] They're a jeweller and the ring setting has a fixed price but the diamond comes from a live supplier feed.
[0:20.38] Thousands of unique stones with prices that move all day.
[0:24.34] The customer pays, the feed moves on and by morning that exact stone they bought may no longer exist anywhere on the list.
[0:33.25] Now imagine the order record just says diamond £8,000.
[0:38.57] Which stone?
[0:39.79] Someone's hunting for a similar one and hoping that nobody checks the certificate.
[0:46.15] So here's a shift.
[0:47.67] An order confirmation isn't a receipt, it's a photograph.
[0:51.35] What was true at that exact moment the customer paid?
[0:54.25] Certificate, size, colour, price, all captured before the world moves on.
[1:00.17] And it isn't just about diamonds.
[1:01.75] VAT rates change, supplier prices change, delivery promises change.
[1:06.99] Which is why we ask, before we build, what on this order could change after the customer has paid?
[1:14.57] The list is always longer than someone expects.
[1:18.56] If it can change after checkout, photograph it at checkout.
[1:22.36] Then open a two-year-old order and see whether you can still tell exactly what was sold.
[1:27.58] If you can't, nothing was photographed.
Frequently asked questions
What should an order capture at checkout?
Everything that could change afterwards: product description and specification, SKU, unit price, quantity, VAT rate and amount, any discount applied, the delivery promise, and a supplier reference where one exists. If it can change after checkout, snapshot it at checkout.
Should we ever delete a product?
Rarely. Retire it instead: keep the record, mark it unavailable, and make sure old links resolve to a "no longer available" page rather than an error. Old orders, warranty claims and refunds still need to know what was sold.
Why does this matter if we might sell the business?
Because a buyer's due diligence will open old orders and try to work out what was sold and at what tax rate. Order data that cannot answer that is a liability.