Where spreadsheets work well
For a small catalogue and occasional reporting, a spreadsheet is flexible, inexpensive and easy to understand. You can maintain product weights and aggregate them manually.
Where manual maintenance becomes fragile
Problems arise when product values change without effective dates, shipping packaging is selected separately, refunds need to be reflected and multiple people edit the same source file.
Order-linked records reduce reconstruction work
If packaging calculations are posted from the actual WooCommerce order, the order itself becomes the anchor for the record. Historical snapshots retain the assumptions used at that moment.
Order snapshots reduce reconstruction work
PackVerity Free stores the packaging record used for each processed order, so later edits to master data do not silently change that order record.
Keep Excel for analysis
Moving the source record into WooCommerce does not mean abandoning spreadsheets. CSV exports let you continue using Excel or another analysis tool without making that file responsible for historical integrity.