LitBuy: Streamline Your Multi-Seller Orders with the LitBuy Spreadsheet
A simple, powerful method to consolidate and track your Taobao and Weidian purchases.
For savvy shoppers and businesses sourcing directly from China, platforms like Taobao and Weidian are treasure troves. However, managing dozens of orders from different sellers can quickly become a logistical headache. Tracking costs, weights, and quality control (QC) results across multiple conversations and screenshots is inefficient. Enter the LitBuy Spreadsheet Method—a unified system to bring order to the chaos.
Why You Need a Consolidated Spreadsheet
Before LitBuy's method, you might be juggling:
- Financial Disarray:
- Shipping Guesswork:
- QC Confusion:
- Time Drain:
- Shipping Guesswork:
The LitBuy Spreadsheet is your single source of truth, solving all these problems in one editable document.
Building Your LitBuy Master Spreadsheet
Here’s how to structure your spreadsheet for maximum efficiency. You can use Google Sheets, Microsoft Excel, or any similar tool.
| Column | Purpose | Example Entry |
|---|---|---|
| Order # | Your internal tracking number (e.g., Order-001). | ORD-024 |
| Seller / Store Name | The Taobao or Weidian store you purchased from. | Quality Sneakers Co. |
| Item Description & Link | Hyperlinked product name and the original URL. | Blue Casual Sneakers (Size 42) |
| Quantity | Number of units purchased. | 1 |
| Item Cost (RMB) | Product price in Chinese Yuan. | ¥250.00 |
| Domestic Shipping (RMB) | Cost for the seller to ship to your agent's warehouse. | ¥10.00 |
| Subtotal (RMB) | Auto-calculate: (Item Cost + Domestic Shipping) * Quantity. | ¥260.00 |
| Agent Warehouse Status | e.g., Ordered, Purchased, Shipped, Arrived. | ARRIVED |
| QC Photos Link | Direct hyperlink to the agent's QC photos for this item. | Link to Google Drive/Agent Album |
| Weight (kg) | The weight recorded by your agent upon arrival. | 0.85 |
| Parcel Assignment | Which consolidated international parcel this item is in (e.g., PARCEL-Oct-01). | PARCEL-A-01 |
| Notes / Action | Space for remarks like "GL" (Green Light), "RL" (Red Light/Return), or "Check logo". | GL - Logo looks good. |
The Efficient LitBuy Workflow
-
Pre-Purchase Planning:
- Post-Purchase Logging:Order #, final Item Cost, and Domestic Shipping
- Tracking & QC:Warehouse Status
. Once QC photos are available, paste the direct link into its column. Review the photos and mark your decision (GL/RL) in the Notes.- Consolidation & Shipping:Parcel Assignment
- Final Reconciliation:
- Post-Purchase Logging:Order #, final Item Cost, and Domestic Shipping
LitBuy Pro Tips
- Use Filters:
- Color Coding:
- Freeze Top Row:
- Share with Your Agent:
- Link Everything:
- Color Coding: