Combine, Organize, and Track All Your Purchases in One Master Document
Ordering from multiple Taobao, Weidian, or 1688 sellers can quickly turn into a logistical puzzle. Keeping track of product links, prices, seller messages, and Quality Check (QC) photos is challenging when everything is scattered. The USFANS Order Spreadsheet
Why Use a Master Spreadsheet?
- Centralized Information:
- Flawless Organization:
- QC & Tracking Hub:
- Easy Agent Submission:
- Cost Overview:
- Flawless Organization:
How to Set Up Your USFANS Spreadsheet
Create a new spreadsheet in Google Sheets or Microsoft Excel. Set up the following columns to build your order management hub:
| Column Title | What to Enter | Why It's Important |
|---|---|---|
| Item # | Unique number (e.g., 001, 002) | Quickly reference any item in your list. |
| Product Name / Description | Detailed name, color, size, version. | Ensures you and your agent order the exact specification. |
| Original Product Link | Full URL from the seller's store. | Direct link for your agent to make the purchase. |
| Store/Seller Name | Name of the Taobao/Weidian store. | Tracks which items are from which seller for bundling. |
| Price (¥) | Item price in Chinese Yuan. | Core data for budget calculation. |
| Quantity | Number of units. | For accurate pricing and shipping weight estimates. |
| Status | e.g., Not Ordered, Ordered, QC Received, In Warehouse, Shipped | Visual snapshot of your haul's progress. |
| QC Photo Link | Hyperlink to your agent's QC images. | Keeps approval/rejection decisions organized. |
| Domestic Tracking # | Courier number from seller to agent's warehouse. | Monitor the journey to the consolidation point. |
| Warehouse Remarks | Weight, photos, or notes from your agent. | Crucial info for final international shipping calculation. |
Managing Your Haul: The Workflow
-
Phase 1: Planning & Submission
Fill out all product details, links, and prices. Share the sheet with your USFANS agent. They will use it as a precise shopping list, updating the "Status" to "Ordered" and adding the "Domestic Tracking #" as they purchase.
-
Phase 2: QC & Warehouse Updates
When QC photos arrive, your agent will provide a link. Insert it into the QC Photo Link
-
Phase 3: Consolidation & Final Shipping
Filter the spreadsheet to see all items with "In Warehouse" status. With all items consolidated, you can now easily submit your parcel request on USFANS, using the organized data to declare items accurately.
Pro Tips for Power Users
- Use Data Validation
- Use the =SUM()
- Freeze the top row so your column headers are always visible.
- Use color coding (e.g., yellow for "QC Pending," green for "In Warehouse") for instant visual status checks.
- Create a separate tab within the same sheet for your international parcel tracking details.
- Use the =SUM()
Take Control of Your Haul
The USFANS Multi-Seller Order Spreadsheet transforms a chaotic purchasing process into a streamlined, professional operation. By investing a few minutes in setup, you save hours of confusion, reduce errors, and gain complete peace of mind. Start your next haul with a spreadsheet—your organized future self will thank you.
Ready to organize?