The difference between a useful cssbuy spreadsheet and a cluttered mess is what you choose to track. Too few fields and you miss critical data. Too many fields and updating becomes a chore you abandon. This guide identifies the essential fields, explains why each matters, and shows you which advanced fields to add as you scale.
We organized fields into tiers: Core (every buyer needs these), Intermediate (add when you have 10+ active orders), and Advanced (for resellers and power users). Start with Core. Add others only when they solve a real problem you are experiencing.
Get a template with all fields pre-configured.
Get Pre-Configured Template →Core Fields: Every Buyer Needs These
These ten fields form the foundation. Without them, your sheet is not a tracking tool—it is just a list.
| Field | Why Track It | Example |
|---|---|---|
| Order ID | Unique identifier for every order | ORD-2026-001 |
| Item Name | What you bought | Nike Dunk Low Panda |
| Category | Groups items for analysis | Shoes |
| Purchase Date | Timeline and aging analysis | 2026-03-15 |
| Item Cost | Base product price | $45.00 |
| Total Cost | All-in cost including fees | $78.50 |
| Sell Price | Expected or actual resale price | $120.00 |
| Profit | Calculated margin per item | $41.50 |
| Status | Current order state | In Transit |
| Tracking | Carrier tracking number | LN123456789CN |
Intermediate Fields: Add at 10+ Orders
Once you have a rhythm with Core fields, these additions add precision without overwhelming your workflow.
Domestic Shipping
Cost from seller to CSSBuy warehouse. Separating this from international shipping shows you where costs cluster.
International Shipping
Cost from warehouse to your door. This is often the largest variable in total cost.
Agent Fee
CSSBuy service charge. Usually a percentage. Tracking it separately reveals its impact on margins.
Shipping Line
Which carrier or method you chose. Over time, this data reveals which lines offer the best cost-speed balance.
Seller/Store
Where you bought the item. Helps identify reliable sellers and flag problematic ones.
Advanced Fields: For Resellers and Power Users
These fields add operational sophistication. Only add them when you have a specific use case.
Batch ID
Groups items shipped together. Essential for consolidated shipping cost allocation.
Customer ID
Links inventory to pre-orders or reservations. Critical if you sell before items arrive.
Sales Channel
Where you sold the item. Reveals which platforms deliver the best margins.
Conversion Rate
Exchange rate on transaction day. Necessary for multi-currency accuracy.
Weight
Item weight in grams. Enables weight-based shipping cost allocation for batches.
Photos URL
Link to QC photos. Quick reference for quality checks and disputes.
Field Setup Priority
Do not add all fields on day one. Follow this progression:
- 1
Week 1: Add all Core fields. Enter 3-5 real orders. Verify formulas work.
- 2
Week 2-3: Add Intermediate fields that solve a problem you actually encountered.
- 3
Month 2+: Add Advanced fields only when your volume or complexity demands them.
Continue Building Your System
What to Track FAQ
Can I track too much?
Yes. If updating your sheet feels like work, you will stop using it. Add fields only when they solve a real problem. A sheet you use with 10 fields beats a sheet you abandon with 30 fields.
What if I forget to update a field?
Missing data is better than no tracking at all. Core fields like Status and Cost are essential. Optional fields can be backfilled when you have time. Do not let perfectionism stop consistent tracking.
Should I track items I did not buy?
Consider a separate "Research" sheet for items you are considering. Track price history, seller reliability, and estimated profit. When you buy, copy the row to your main orders sheet. This separates research from committed orders.
How do I handle returned items?
Add a "Refund Amount" column. Enter negative values for refunds. Add a note explaining the return reason. This keeps your profit calculation accurate even with returns.
Track What Matters
Start with the essentials. Add complexity only when you need it. The best tracking system is the one you actually maintain.