A sugargoo spreadsheet is only as useful as the data you put into it. Track too little and you miss important details. Track too much and the sheet becomes cluttered. This guide shows exactly what to track in your sugargoo spreadsheet for the perfect balance of detail and clarity.
The Essential Columns
Every sugargoo spreadsheet needs at least these seven columns: Product Link, Product Name, Size, Unit Price, Agent Fee, Shipping Estimate, and Status. These cover the information you need to identify, price, and track every item. Without these columns, your sheet is incomplete.
| Column | Why It Matters | Example Entry |
|---|---|---|
| Product Link | One-click access to item | taobao.com/item/456 |
| Product Name | Quick identification | Nike Dunk Low Panda |
| Size | Avoid wrong orders | US 9.5 |
| Unit Price | Base cost | 249 yuan |
| Agent Fee | Service cost | 18 yuan |
| Shipping | Freight estimate | 52 yuan |
| Status | Track progress | QC Passed |
Optional but Valuable Columns
Beyond the essentials, smart shoppers add columns that save time later. A Category column lets you sort by type. A Seller column tracks which stores you trust. A Date column helps you spot price trends. A Notes column stores agent messages or special instructions.
- Category: Shoes, Hoodies, Accessories, etc.
- Seller: Store name or Taobao seller ID.
- Weight: In kilograms, for accurate shipping estimates.
- Date Added: The day you saved the link.
- Quality Rating: Your own 1-5 score after receiving.
- Resale Price: What you plan to sell it for.
What You Should NOT Track
Avoid tracking sensitive information like payment card details, agent passwords, or personal addresses in your sugargoo spreadsheet. The sheet should be shareable with friends or agents without exposing private data. Keep payment info on official sugargoo platforms only.
Also avoid tracking data that is already available on the sugargoo platform, such as real-time shipping updates. Your spreadsheet should be a planning tool, not a live dashboard. Update it manually once per day during active orders.
Need a template with these columns already built? Our free templates include all essential and optional columns with pre-built formulas.
Get TemplatesFor organizing your data effectively, check our organize sugargoo orders guide. If you are building from scratch, our build sugargoo spreadsheet guide covers column design in detail.
Continue Reading
Return to the sugargoo spreadsheet homepage for more guides and resources.
Browse all articles on our blog page for the complete collection of sugargoo spreadsheet tips.
Download free sugargoo spreadsheet templates to start tracking today.