Consolidate, Track, and Conquer Your Hauls Efficiently
Shopping from multiple Taobao, Weidian, or 1688 sellers? Keeping track of numerous orders, product details, and quality check (QC) images can quickly become chaotic. The USFANS Order Combination Spreadsheet
Why Use a Combined Spreadsheet?
- Centralized Information:
- Simplified QC:
- Clear Tracking:
- Cost Calculation:
- Effortless Communication:
- Simplified QC:
How to Structure Your Master Spreadsheet
Step 1: Create Your Core Columns
Set up the following columns to capture essential information for every item:
| Store/Seller | Product Link | Item Description/Size/Color | Price (¥) | Order Number |
|---|---|---|---|---|
| Example Store A | https://item.taobao.com/... | Canvas Tote Bag, Beige | 89.00 | TB123456789 |
Step 2: Add QC & Status Tracking Columns
These columns are crucial for post-purchase management:
- QC Images:
- Status:Ordered, Arrived at Warehouse, QC Passed/Failed, In Warehouse, Shipped Internationally, Delivered.
- Warehouse Weight (kg):
- Notes/Action:
Step 3: Combine Orders for International Shipping
Once all items arrive at your agent's warehouse:
- Update Status:
- Consolidate:
- Calculate:
- Add Parcel Tracking:
- Consolidate:
Pro Tips for Effective Management
Use Hyperlinks & Formatting
Make product links and QC image links clickable. Use color-coding for statuses (e.g., green for Delivered, yellow for In Transit).
Leverage Formulas
Use =SUM()=CONCATENATE()
Freeze Header Rows
Keep your column titles visible as you scroll down your long list of items for error-free data entry.
Share with Your Agent
A well-organized spreadsheet can be shared with your USFANS agent to prevent misunderstandings and speed up the process.