What to Track in Your Basetao SpreadsheetThe Complete Field Checklist (2026)
Knowing what to track inside your basetao spreadsheet is half the battle. Too few fields and you miss critical details. Too many and data entry becomes a chore. After analyzing workflows from over two hundred buyers, we distilled the perfect tracking checklist into three tiers.
This article gives you every column you need, explains why it matters, and tells you exactly which tier fits your buying volume. No filler, no bloat.
Tier 1: Essential Fields (Everyone Needs These)
Every basetao spreadsheet should include Item Name, Product URL, Category, Size, Color, Price (CNY), Agent Fee, Shipping Estimate, Total Cost, Status, and Order Date. These eleven fields cover identity, cost, and progress tracking. Without them, you are flying blind.
The Total Cost field must be a formula adding Price + Agent Fee + Shipping. Never type totals manually. Manual totals guarantee math errors during currency conversion.
Tier 2: Recommended Fields (5+ Items Per Month)
Add QC Status, QC Image Link, Seller Name, Seller Rating, Shipping Line, Weight (g), and Tracking Number. These fields prevent the classic mid-haul panic: "Which shipping line did I pick?" and "Where is my QC photo?"
Tier 3: Power Fields (Resellers & Bulk Buyers)
Resellers need Resale Price, Profit Margin, Platform Fee (if selling on Grailed or eBay), and Batch Number. Bulk buyers should track Box Number, Consolidation Status, and Customs Value. Our bulk buying guide explains these advanced columns in detail.
Ready to start tracking smarter?
Click to Get Free Template| Field | Tier | Why It Matters | Formula? |
|---|---|---|---|
| Item Name | 1 | Identity | No |
| Total Cost | 1 | Budget control | Yes |
| QC Status | 2 | Quality gate | No |
| Seller Rating | 2 | Repeat buys | Average |
| Profit Margin | 3 | Resale math | Yes |
| Box Number | 3 | Bulk logistics | No |
Pro Tips for 2026
- 1Start with Tier 1 only. Add Tier 2 after your third haul when patterns emerge.
- 2Use dropdowns for Status, Category, and Shipping Line. It keeps data clean and filterable.
- 3Reserve the Notes column for non-standard details like "size up one" or "avoid this batch".
- 4Freeze the header row so you never forget which column is which during mobile edits.
Frequently Asked Questions
Q1.How many columns is too many?
More than twenty active columns slow down mobile entry. Archive old columns rather than deleting them.
Q2.Should I track replica batch numbers?
Only if you buy the same item repeatedly. Casual shoppers do not need this field.
Q3.Do I need a separate tab per haul?
One main tab is fine until you hit fifty rows. Then split by quarter for speed.
Q4.Can I skip the Notes column?
You can, but you will regret it when re-ordering an item and forgetting the size advice.
Get the complete tracking template now
Our template includes all three tiers pre-configured with dropdowns, formulas, and conditional formatting.
Keep Reading
More Basetao Spreadsheet Guides
Continue building your knowledge with deep-dive articles, tool reviews, and template comparisons.