MyCNBox: How to Record Parcel Repacking Requests in the Spreadsheet
Effective management of parcel repacking is crucial for any international shipping consolidator. At MyCNBox, systematically tracking packaging changes and final weights is not just an administrative task—it's a vital practice for maintaining cost transparency and optimizing overall shipping expenses for our customers.
Why This Record-Keeping Matters
When a customer requests repacking—to remove retail boxes, consolidate multiple items, or reduce package size—the final shipment parameters change. Without accurate tracking:
- Cost calculations become estimates, not reflections of actual volumetric or actual weight.
- Discrepancies arise between initial quotes and final charges, leading to customer confusion.
- We miss valuable data to advise customers on future purchasing and packing strategies.
Recording these changes in the shared MyCNBox spreadsheet provides a single source of truth.
Step-by-Step Recording Guide
Follow this process to ensure every repacking request is logged clearly and consistently.
Step 1: Locate the Parcel Entry
Open the master "MyCNBox Shipments" spreadsheet. Find the row corresponding to the customer's parcel using their unique Customer IDParcel Receipt Number.
Step 2: Update the "Repacking Requested" Column
Mark the "Repacking Requested" column as "YES". If there's a dropdown menu, select it. This immediately flags the parcel for the warehouse and accounting teams.
Step 3: Document Original and Final Dimensions
This is the core data for transparency:
- Original Dimensions/Weight:
- Final Dimensions/Weight:
The spreadsheet should automatically calculate the volumetric weight for both sets of dimensions.
Step 4: Add Notes in the "Repacking Notes" Column
Provide a brief, clear description. For example:
"Removed shoebox and outer retail packaging. Consolidated with item #PR-45678."
"Downsized box to fit items snugly, removed filler material."
This note clarifies the reason for the change.
Step 5: Verify Cost Recalculation
Check that the "Estimated Final Charge" column has updated based on the new final weight
Best Practices for Data Integrity
- Timeliness:
- Accuracy:
- Clarity:
- Communication:
- Accuracy:
Direct Benefits to Our Customers and Operations
Meticulous recording translates directly to value:
Full Cost Transparency
Customers see a clear audit trail from initial receipt to final shipped dimensions, building trust.
Optimized Shipping Expenses
Accurate final weight data ensures customers pay only for the space they use, often leading to significant savings.
Operational Insight
We analyze repacking data to identify which retailers use excessive packaging and can advise customers proactively.
Dispute Resolution
A complete record quickly resolves any queries about final shipping charges.
In summary,