MyCNBox: How to Record Parcel Repacking Requests
2026-04-05
A systematic approach to logging repacking requests in your spreadsheet is crucial for cost transparency and optimizing international shipping expenses.
Why Track Repacking?
Recording packaging changes and final weights allows you to:
- Maintain Cost Transparency:
- Optimize Shipping Expenses:
- Audit and Dispute Resolution:
- Improve Forecasting:
- Optimize Shipping Expenses:
Steps to Record in Your MyCNBox Spreadsheet
Step 1: Initial Entry Creation
When creating a new row for your parcel, ensure these base columns are filled:
| Column | Example Data |
|---|---|
| Parcel ID/Tracking # | CNB123456789 |
| Original Description/Items | 1x Winter Coat, 2x Sweaters |
Initial Declared Weight/Dimensions
| 3.5kg, 40x30x20cm |
|
Original Photo Link
| Link to warehouse intake photo |
|
Step 2: Logging the Repacking Request
Once you submit a repacking request (e.g., remove boxes, combine parcels), immediately update the row:
| Column to Add/Update | What to Record |
|---|---|
| Repacking Request Date | 2023-10-26 |
| Repacking Instructions | "Remove all retail boxes and shoe boxes. Consolidate into one package." |
| Reason for Repack | Reduce volumetric weight / Remove excess packaging / Consolidate shipments |
| Status | Repack Requested |
Step 3: Recording the Final Result
After MyCNBox completes the repacking, update the record with the final, billable details provided by their service.
| Critical Columns to Update | Example Final Data |
|---|---|
| Final Dimensions (L x W x H in cm) | 35x25x15cm |
| Final Weight (kg) | 3.1kg |
| Final Volumetric Weight (kg)* | (35x25x15)/6000 = 2.2kg |
| Chargeable Weight (kg) | MAX(3.1, 2.2) = 3.1kg |
| Post-Repack Photo Link | Link to final package photo |
| Repacking Service Fee | $2.00 |
| Final Status | Repack Completed |
*Volumetric Weight = (L x W x H in cm) / 6000 (common divisor for air freight).
Step 4: Analysis & Optimization Fields
Add calculated columns to analyze the impact and drive future savings.
| Calculated Column | Formula & Insight |
|---|---|
| Weight Saved (Volumetric) | Initial Vol. Weight - Final Vol. Weight. Shows reduction in "size" weight. |
| Cost Difference Estimate | (Initial Chargeable Weight - Final Chargeable Weight) * Shipping Rate/kg. Quantifies savings. |
Repack Effective?
| Was the fee worth the shipping cost saved? Helps inform future decisions. |
|
Pro Tips for Effective Tracking
- Use data validation
- Insert hyperlinks
- Color-code rows
- Create a separate dashboard sheet
- Always note if original packaging is discarded or kept, as this can affect item protection.
- Insert hyperlinks