A cnshopper spreadsheet is only as good as the data you put into it. Tracking too little leaves blind spots; tracking too much creates clutter and maintenance headaches. This guide reveals the exact items and data points you should track — and which ones to skip — for maximum efficiency.
Essential Information Every Row Needs
These seven data points form the foundation of every effective cnshopper spreadsheet. Missing any of these creates gaps that lead to lost orders, forgotten payments, or missed deliveries.
- Order Date — when you committed to the purchase, critical for calculating delivery timelines
- Order ID — the platform-generated number you need for disputes and tracking
- Item Name — precise product name for quick searching and duplicate detection
- Seller/Store Name — identifies who you bought from for repeat purchases or complaints
- Price in Original Currency — the base price before conversion for accurate records
- Shipping Method & Cost — affects total cost and delivery speed significantly
- Status — current position in the fulfillment pipeline (Ordered through Delivered)
Optional But Valuable Data Points
These additional fields transform a basic tracker into a professional cnshopper spreadsheet with analytics capabilities.
- Tracking Number — essential if you check carrier websites directly
- Quality Rating (1-10) — builds your personal seller database over time
- Category Tag — Shoes, Clothing, Accessories for spending analysis by category
- Resale Price — if you plan to resell, this enables profit margin calculations
- Photos/Notes — links to album folders or brief quality observations
- Agent/Forwarder — which shipping agent handled the package
Essential vs Optional: Comparison Table
| Data Point | Type | Why Track It | Skip If |
|---|---|---|---|
| Order Date | Essential | Calculate delivery time, find old orders | Never skip |
| Order ID | Essential | Disputes, tracking, seller contact | Never skip |
| Item Name | Essential | Search, identify duplicates | Never skip |
| Seller Name | Essential | Build trusted seller list | Never skip |
| Price CNY | Essential | True cost records, currency analysis | Never skip |
| Shipping Cost | Essential | Accurate total cost | Never skip |
| Status | Essential | Know where everything is | Never skip |
| Tracking Number | Optional | Direct carrier lookup | You use platform tracking only |
| Quality Rating | Optional | Seller reliability scoring | You do not resell or repeat buy |
| Category Tag | Optional | Spending analysis by type | You buy one category only |
| Resale Price | Optional | Profit margin tracking | You are not a reseller |
| Agent Name | Optional | Compare forwarder performance | You use one agent always |
What You Should NOT Track
Over-tracking kills motivation and slows your cnshopper spreadsheet to a crawl. Avoid these data points that add noise without value:
- Detailed product descriptions — keep names short and searchable
- Every communication with sellers — link to chat logs if needed, do not paste text
- Individual package dimensions — only relevant for bulk freight calculations
- Payment method per order — one column is fine, do not create a payment history
- Exact weight in grams — round to nearest 100g or kilogram
FAQ
Q: How many columns should my spreadsheet have?
Beginners should use 10-12 columns. Power users can expand to 18-20. Beyond 25 becomes unmanageable.
Q: Should I track items I haven't bought yet?
Yes, use a separate Wishlist sheet. Do not mix wishlist items with confirmed orders in your main tracker.
Q: Do I need to track return/refund status separately?
Add a Refunded column with Yes/No values, or use the Notes column for brief refund annotations.
Conclusion
The best cnshopper spreadsheet strikes a balance between comprehensive tracking and practical maintenance. Start with the seven essentials, add optional fields only when they serve a specific purpose, and ruthlessly remove anything that creates clutter without adding value.
Browse Products to Track