Home > LoveGoBuy: Recording Weight Changes & Repacking Requests in the Spreadsheet

LoveGoBuy: Recording Weight Changes & Repacking Requests in the Spreadsheet

2025-12-24

Clear and consistent logging of parcel adjustments is essential for accurate freight calculation and operational transparency. This guide outlines the standard procedure for documenting weight changes and repacking requests in the shared spreadsheet.

Why This Process Is Critical

Maintaining detailed logs prevents disputes, ensures billing accuracy, and provides an auditable trail for every parcel. It minimizes misunderstandings between warehouse teams, customer service, and clients regarding final shipping charges.

Step-by-Step Logging Procedure

Step 1: Locate the Correct Parcel Record

Navigate to the designated tracking spreadsheet. Use the unique Parcel IDTracking Number

Step 2: Record Weight Change (if applicable)

  • Column [Initial Weight]:
  • Column [Final Confirmed Weight]:
  • Column [Weight Change Notes]:"Repack: removed excess box; reduced from 3.2kg to 2.7kg""Bubble wrap added for protection; increased from 1.5kg to 1.8kg."

Step 3: Document the Repacking Request

  • Column [Repacking Requested]:"Yes""No".
  • Column [Repacking Details]:Examples: "Customer requested removal of retail shoebox for volumetric reduction." "Warehouse consolidated 3 items into one box as per CS ticket #45621."

Step 4: Note Date and Operator

  • Column [Adjustment Date]:
  • Column [Logged By]:

Step 5: Update Freetcharge Calculation Columns

Ensure the [Final Freight Charge][Final Confirmed Weight][Freight Notes]

Best Practices for Transparency

Be Timely

Log changes immediately after the adjustment is made to prevent data lag.

Be Specific

Avoid vague notes. State what was changed, why, and the exact result.

Reference Tickets

Always include relevant Customer Service or Request Ticket numbers for traceability.

No Blank Cells

If no adjustment was made, mark columns as "No" or "N/A" to show the record was reviewed.

Final Reminder

A well-maintained spreadsheet is a source of truth. It protects LoveGoBuy by providing clear evidence for freight costs and protects our customers by ensuring they are charged accurately and fairly for the final, shipped parcel. When in doubt, over-communicate in the log.