Why You Need a Step-by-Step System
Chinese marketplace shopping is not like Amazon. You are browsing Taobao, Weidian, and 1688 — platforms that change prices daily, delete listings without warning, and communicate entirely in Chinese. Without a structured allchinabuy spreadsheet, you are relying on memory and screenshots to manage a process that involves dozens of moving parts.
This guide breaks the entire process into five manageable phases. Follow each one, check it off, and by the end you will have a living document that tracks every item from discovery to delivery.
New to spreadsheets? Start with our beginner overview first.
Beginner GuidePhase 1: Copy the Template (2 Minutes)
Open our free Basic Order Tracker. If you use Google Sheets, click File > Make a Copy and save it to your own Google Drive. If you prefer Excel, download the .xlsx file and open it locally. The template arrives with these pre-built columns:
- Item Name
- Item URL
- Size / Color
- Item Price (CNY)
- Domestic Shipping (CNY)
- Agent Fee
- International Shipping (Est.)
- Status
- Notes
Phase 2: Paste Your Links (5 Minutes)
Browse your favorite stores. For every item you want, copy the product URL from the browser address bar and paste it directly into the Item URL column. In the Item Name column, write a short description you will recognize later — something like "Nike Dunk Low Panda Size 42" instead of the full Chinese title.
Add your chosen size and color in the next column. This is your single biggest protection against wrong-size disasters. Agents process hundreds of orders daily. If your sheet says "Size 42 / Black," there is zero ambiguity.
Phase 3: Let the Math Happen (1 Minute)
Our templates include pre-written formulas. Enter the item price in yuan, and the sheet converts it to your local currency using a live exchange rate cell at the top. Enter the estimated domestic shipping (usually 8–15 CNY per item), and the running total updates automatically.
Phase 4: Submit to Your Agent
When your haul looks complete, copy the relevant rows and paste them into your agent's order form or chat. Because every detail is already written down, you eliminate the back-and-forth questions that slow down processing by a day or more.
Phase 5: Track Every Milestone
Update the Status column as items move through the chain: Purchased → Arrived at Warehouse → Shipped Internationally → Delivered. Color-code each stage using conditional formatting so one glance tells you exactly where everything sits.
Step-by-Step Overview Table
| Phase | Time | Tool | Difficulty |
|---|---|---|---|
| Setup | 2 min | Google Sheets | Very Easy |
| Add Items | 5 min | Browser + Sheet | Easy |
| Calculate Costs | 1 min | Auto Formulas | Very Easy |
| Track Shipping | Ongoing | Sheet Updates | Easy |
| Archive & Review | 3 min | Sheet History | Easy |
Pro Tips for Faster Tracking
- Use browser bookmarks to save the Google Sheets tab alongside your agent chat tab.
- Set your phone homepage shortcut to the sheet for instant mobile updates.
- Screenshot every item page and paste the image link into the Notes column — links die, screenshots do not.
- Add a 'Deadline' column if your agent offers limited free warehouse storage.
- Create a second sheet tab for 'Completed Hauls' so your main view never gets cluttered.
Continue Your Learning
Now that you know the workflow, explore our allchinabuy spreadsheet guide for advanced strategies, or download free templates to get started today. Return to the homepage for more resources.
Frequently Asked Questions
Ready to Start?
The best allchinabuy spreadsheet is the one you actually use. Pick a template, paste your first link, and experience the calm of organized shopping. Your future self — the one receiving a perfectly tracked haul — will thank you.