Combine, Track, and Manage Taobao & Weidian Purchases with One Powerful Tool
Shopping across multiple Taobao and Weidian sellers is exciting, but managing the ensuing flood of order details, costs, and logistics can be overwhelming. The LitBuy Consolidation Spreadsheet
Why Use a LitBuy Spreadsheet?
- Centralized Tracking:
- Cost & Budget Accuracy:
- Weight & Logistics Planning:
- QC (Quality Check) Hub:
- Seamless Agent Communication:
- Cost & Budget Accuracy:
Building Your LitBuy Spreadsheet
Use any spreadsheet software (like Google Sheets or Excel). Create the following core columns:
| Column Header | Purpose & Data to Input |
|---|---|
| Item/Link | Product name and the original Taobao/Weidian URL. Hyperlink for easy access. |
| Seller/Store | Seller name. Helps group items from the same source. |
| Quantity & Price (¥) | Number of units and individual |
| Domestic Shipping (¥) | Shipping fee from seller to your agent's warehouse. |
| Item Subtotal (¥) | Formula: (Quantity*Price) + Domestic Shipping. |
| Estimated Weight (g) | Weight from the product page. Crucial for initial shipping quotes. |
| Actual Weight (g) | Updated by your agent once the item arrives at their warehouse. |
| QC Status & Photos | Status (Pending/Passed/Failed) and a direct link to your QC pictures provided by the agent. |
| Warehouse Inbound # | The agent's unique storage number for the item. Your key identifier. |
| Notes | Size, color, specific instructions, or issues. |
Efficient Workflow in 4 Steps
Step 1: Planning & Input
As you browse, fill in the Item/Link, Seller, Quantity, Price,Estimated Weight. The spreadsheet will start calculating your projected total cost.
Step 2: Ordering with Your Agent
Share the list of links and corresponding specs (from your sheet) with your purchasing agent. The spreadsheet is your master reference.
Step 3: Tracking & QC Updates
As items arrive at the warehouse, update the sheet with the Actual Weight, Warehouse Inbound #,QC Status/Photo links. Color-code rows (e.g., green for QC passed) for visual clarity.
Step 4: Consolidation & International Shipping
Use the Actual WeightWarehouse Inbound #s
Pro-Tips for Power Users
- Freeze the Top Row:
- Use SUM Formulas:
- Data Validation for Status:
- Conditional Formatting:
- Share with Care:view-only
- Use SUM Formulas: