Combine, Track, and Manage Taobao & Weidian Purchases Efficiently
Shopping across multiple Taobao and Weidian sellers is exciting, but managing the resulting flood of orders, costs, and logistics details can be a nightmare. Enter the LitBuy Spreadsheet Method: a powerful, systematic approach to consolidate all your purchases into one master document. This guide will show you how to transform order chaos into clarity.
Why Use a Consolidated Spreadsheet?
- Centralized Tracking:
- Accurate Cost Calculation:
- Weight & Logistics Forecasting:
- QC (Quality Control) Hub:
- Time & Error Reduction:
- Accurate Cost Calculation:
Building Your LitBuy Master Spreadsheet
Create a new spreadsheet (Google Sheets or Excel) with the following core columns:
| Column Header | Purpose & Data to Input |
|---|---|
| Order # / Link | Taobao/Weidian order number or direct product link for quick reference. |
| Seller Name | Identify the source shop. Useful for future re-orders or issues. |
| Item Description | Brief details: "Men's Blue Denim Jacket, Size L". Include color/size choices. |
| Quantity | Number of units purchased. |
| Item Price (¥) | Unit cost in Chinese Yuan. |
| Domestic Shipping (¥) | Shipping fee from seller to your consolidation warehouse. |
| Subtotal (¥) | Formula: (Quantity * Item Price) + Domestic Shipping. |
| Warehouse Weight (kg) | Actual weight |
| QC Photos Link | Hyperlink to the warehouse's QC pictures. Check here before authorizing shipment. |
| QC Result | Status: Pending, Approved, Return/Exchange. |
| Notes | Any issues, special packaging requests, or reminders. |
The Efficient Management Workflow
Step 1: Order & Record
As you place each order on Taobao/Weidian, immediately
Step 2: Consolidate & Update
Once all items arrive at your agent's warehouse, update the sheet with the actual Warehouse WeightQC Photos Link
Step 3: Inspect & Decide
Review QC photos. Update the QC Result
Step 4: Ship Internationally
Use the total weightpackage dimensions
Pro Tips for Power Users
- Use Filters:
- Color Code:GreenOrange
- Data Validation:
- Pivot Tables:
- Share with Agents:
- Color Code:GreenOrange