For power users of MyCNBox, the default spreadsheet provides a solid foundation. However, the true power lies in tailoring it to your unique e-commerce workflow. By adding custom columns for seller scores, weight tracking, and refund logs, you can transform it into a centralized command center for your cross-border purchasing.
Why Customize? Beyond Basic Tracking
The default columns handle the essentials: item name, order ID, price, and status. Advanced users, however, need to analyze seller reliability, predict shipping costs accurately, and manage post-purchase issues
Step-by-Step: Adding Your Custom Columns
We recommend adding the following column groups in order, typically after the "Price" or "Status" column.
1. Seller Performance Score
This column group helps you vet suppliers. Add these adjacent columns:
- Seller Score (1-5):
- Response Time:
- Historical Notes:
- Response Time:
Tip: Use conditional formatting to highlight rows with seller scores below 3 in red.
2. Physical & Logistics Tracking (Weight & Dimensions)
Essential for calculating precise shipping costs with freight forwarders.
- Estimated Weight (g):
- Actual Weight (g):
- Package Dimensions:
- Volumetric Weight:=(L*W*H)/5000
- Actual Weight (g):
3. Refund & Dispute Log
Turn problem orders into trackable data.
- Refund Status:None, Requested, Approved, Received.
- Refund Amount:
- Dispute Date & Reason:
- Resolution Notes:
- Dispute Date & Reason:
Integrating Columns Into Your Workflow
Custom columns are only useful with consistent processes:
- On Order Placement:Seller ScoreEstimated Weight.
- At Warehouse Check-in:Actual WeightDimensions
- During QC:Refund Log.
- Post-Purchase:Seller ScoreRefund Status
Pro Tips: Formulas & Filters
Leverage spreadsheet functions to automate insights:
- Use
AVERAGEIF- Create a filter view to show only items where Actual WeightEstimated Weight
- Freeze the header row and your most important custom columns for easy scrolling.
- Create a filter view to show only items where Actual WeightEstimated Weight
Conclusion
Customizing your MyCNBox spreadsheet with targeted columns for seller evaluation, weight logistics, and refund tracking