The overwrite problem
A spreadsheet or live product field often represents the latest value. That is useful operationally, but risky for historical reporting because older orders may have used different packaging.
Version master data by effective date
Versioning allows a new packaging specification to take effect without deleting the previous specification. Historical orders can continue referencing the version that applied when they were processed.
Snapshot order context
Shipping profiles and relevant order inputs should be captured with the order calculation. This reduces dependence on mutable external state.
Prefer reversals to destructive edits
When a correction is necessary, an append-only adjustment leaves a visible trail: what was originally posted, what was reversed and what replaced it.
Export the evidence
An audit-oriented CSV can carry order, material, weight, source and context fields downstream so the underlying calculation can be reviewed outside WooCommerce as well.