Managing dozens or hundreds of items from Chinese agents can quickly become chaotic. The BaseTao Spreadsheet
For large-scale hauls, tracking via platform messages or personal notes is inefficient. The integrated spreadsheet solves this by: Log into your BaseTao account. Navigate to "My Spreadsheet"
As you shop, paste product URLs from Taobao, Tmall, or 1688 into the designated "Link" column. The spreadsheet can often auto-fetch the title and price. Add details like size, color, and special instructions in adjacent columns. Once your items arrive at the BaseTao warehouse, QC photos are taken. You will find a clickable link or thumbnail in your spreadsheet's "QC Photos" column. Review them efficiently and note any issues in the "Remarks" column (e.g., "GL" for Green Light, or "Exchange needed"). After submitting items for shipping, a new row or section is created for your parcel. The "Parcel Progress" column will update with key statuses: Paid, Packaged, Shipped, and Delivered. Use the tracking number provided for detailed carrier updates. Use the spreadsheet's color fill to quickly identify status: yellow for ordered, blue for in-warehouse, green for shipped. Utilize formula columns to sum item costs, domestic shipping, and international freight for a total cost per parcel. Make updating the spreadsheet part of your daily or weekly routine. Consistent logging prevents confusion later. Periodically export or download a copy of your spreadsheet. This preserves your hard work and serves as a purchase archive.Why Use the BaseTao Spreadsheet?
How to Access and Use the Spreadsheet
Accessing the Tool
Adding Purchase Links
Managing QC Photos
Tracking Parcel Progress
Pro Tips for Maximum Efficiency
Color Coding
Cost Calculation
Regular Updates
Backup Your Data
Mastering Large-Scale Orders: A Guide to the BaseTao Spreadsheet
2026-01-27