How to Record Weight Changes and Repacking Requests in the Master Spreadsheet
This procedure ensures complete transparency
Core Principle:
Upon receiving the parcel in the warehouse, the initial weight and dimensions are logged in the Parcel_Master_Log.xlsx
When a customer or agent requests repacking (e.g., to reduce volume or consolidate):
Column E: "Action Taken", select "Repack Requested"
Column F: "Notes/Reason", concisely state the reason. Example: "Customer requested consolidation with ParcelID-78910 to reduce volumetric weight."Column G: "Responsible Agent", enter your agent ID.After the physical repacking is complete and the parcel is re-weighed/measured:
Column H: "Final Weight (kg)"
Column I: "Final Dimensions"
Column J: "Date Adjusted"=TODAY()
Tip:
Critical step to alert the finance team:
Column K: "Freight Recalc Needed?", set the cell to "YES"
Log the adjustment as soon as it is completed. Delayed entries lead to errors and discrepancies during billing.
Notes should be factual and brief. Avoid vague terms like "reduced." Instead, state "Removed outer manufacturer's box, retained product packaging only."
Never overwrite or delete the original recorded data. The log must provide a complete, auditable trail from receipt to shipment.
A different team member should verify the new weight entry against the scale reading to ensure accuracy before finalizing the log.
By following this standardized logging process, LoveGoBuy guarantees a transparent, conflict-free audit trail
Questions?