What to Track in Your Basetao Spreadsheet: Essential Data Points
Basetao Editorial Team
Workflow Optimization Experts
The difference between a messy basetao spreadsheet and a powerful one comes down to what you choose to track. Add too many columns and your sheet becomes a chore. Add too few and you miss critical details that lead to costly mistakes.
This guide gives you the exact list of data points to track, organized by priority. We explain why each field matters, when it becomes essential, and how to format it so your agent understands it instantly.
The Essential Data Points (Track These First)
These six fields are non-negotiable. Every basetao spreadsheet should have them, even if you are only ordering one item. They prevent the most common and expensive errors.
Recommended Column Structure
Item Name
Your own description. Agents see this first. Make it unmistakable: "Nike Dunk Low Panda Size US 9" beats "shoes".
Product URL
The direct Taobao/Weidian link. If there is a dispute, the agent needs this to verify what you actually ordered.
Size + Unit
"Large" is ambiguous. "US Large / CN XL" is not. Size errors are the #1 cause of returns.
Color / Variant
Specific colorway names prevent mix-ups when an item has 8 similar shades.
Price Per Unit
Track in yuan for accuracy. Convert to your currency only in a separate summary column.
Order Status
Bookmarked, Ordered, In Warehouse, Shipped, Delivered. This single column gives you your entire pipeline view.
Important Data Points (Add These Next)
| Field | Why It Helps | When Essential | Format Tip |
|---|---|---|---|
| Quantity | Prevents accidental double orders | 3+ items or group buys | Always use numbers, never words |
| Shipping Estimate | Budget planning | Every order | Separate domestic and international |
| Agent Order ID | Links your sheet to agent records | 5+ items | Copy-paste from agent confirmation |
| Order Date | Tracks how long items take | Frequent buyers | YYYY-MM-DD for easy sorting |
| QC Photo Link | Review quality before shipping | High-value items | Link to warehouse photo album |
| Weight | Predicts shipping cost | Large hauls | In grams for precision |
Advanced Data Points (For Power Users)
- Shipping Method (EMS, DHL, Sea) - affects cost and delivery time
- Tracking Number - one-click access to your parcel status
- Domestic Shipping Cost - separates warehouse inbound from international outbound
- Agent Service Fee - some agents charge per item or per order
- Declared Value - for customs and insurance purposes
- Member Name - critical for group order organizers
- Payment Status - tracks who has paid in group settings
- Resale Price - for resellers tracking profit margins
What Not to Track
More data is not always better. Avoid tracking information that is already available elsewhere or that you never actually reference. Common mistakes include tracking seller chat logs (already in Taobao), detailed product descriptions (already at the URL), and every agent message (clutters your sheet without adding value).
If you have not opened a column in three orders, delete it. A lean basetao spreadsheet that you actually use beats a comprehensive one that overwhelms you.
Use the same format for every entry. If your first size is "US 9" and your second is "Nine", sorting and filtering become impossible.
Separate monetary values into their own columns. Never write "200 yuan + 50 shipping" in one cell. Formulas cannot parse text.
Add a "Priority" column with values like High, Normal, Low. Sort by this column when budget is tight.
Create a data validation dropdown for every field that has limited options. Status, Shipping Method, and Priority should never be free-text typed.
Track Smarter with a Basetao Spreadsheet
Use this guide to decide what matters for your workflow, then build a sheet that captures exactly what you need and nothing more.
