Most resellers track too much or too little. Fifty-column spreadsheets sit half-empty, while five-column sheets miss critical fee data. Both problems cost money — one through wasted time, the other through invisible profit leaks.
After analyzing tracking sheets from over 200 active resellers, we identified the eight data points that deliver maximum insight with minimum maintenance. These are the columns every rizzitgo spreadsheet needs, regardless of order volume.
Track these eight items and you will know exactly where every dollar goes, which agents deliver fastest, and which product categories earn the most profit per square inch of warehouse space.
Want Pre-Built Templates?
Our templates already include these 8 columns with formulas and formatting applied.
Free TemplatesThe Essential Eight
Here are the only columns you need to start with. Everything else is optional until your workflow demands it:
Item Name + SKU
A clear product name plus a unique SKU code. This prevents confusion when you have three 'Black Hoodies' from different suppliers.
Supplier / Agent
Track who fulfilled the order. This reveals which agents ship fastest, have lowest fees, and deliver best QC photos over time.
Cost Per Item
The base price you paid, in your home currency. Every profit calculation starts from this number.
Shipping Cost
Often the biggest hidden expense. Log actual shipping, not estimates. Include domestic and international legs separately if needed.
Platform / Payment Fees
PayPal, Stripe, or marketplace fees. These average 2.9-5% per transaction and destroy margins if ignored.
Sell Price
What you actually sold it for, not what you hoped for. This grounds your profit data in reality.
Net Profit
Auto-calculated: Sell Price minus Cost, Shipping, and Fees. This is your only metric that truly matters.
Status
Ordered, QC Received, Shipped, Delivered, or Sold. One column tells you exactly where every item sits in your pipeline.
Nice-to-Have Columns
Once the Essential Eight are automatic, consider adding these secondary columns for deeper insight:
Order Date and Delivery Date let you calculate agent lead times. Category tags (Shoes, Hoodies, Accessories) enable pivot-table analysis of your best-performing product types. Customer name and platform (eBay, Grailed, WhatsApp) show you where your best buyers come from.
What to Avoid Tracking
These data points sound useful but create clutter without delivering actionable insight:
- Exact weight in grams — only matters if you negotiate shipping by exact kilo.
- Individual QC photo file names — keep photos in a folder, not your sheet.
- Hyper-detailed material descriptions — 'Cotton blend' is enough for most resellers.
- Supplier invoice numbers — useful for accountants, not daily tracking.
- Social media post IDs — track marketing separately from order logistics.
Column Priority Matrix
Ranked by impact on daily workflow and profit accuracy:
| Column | Priority | Impact | Time to Fill |
|---|---|---|---|
| Item Name + SKU | Essential | High | 10 sec |
| Cost | Essential | High | 10 sec |
| Sell Price | Essential | High | 10 sec |
| Shipping | Essential | High | 15 sec |
| Fees | Essential | High | 10 sec |
| Net Profit | Essential | Critical | Auto |
| Status | Essential | Medium | 5 sec |
| Agent | Essential | Medium | 5 sec |
| Order Date | Secondary | Low | 5 sec |
| Category | Secondary | Low | 5 sec |
Related Guides
Track Less, Know More
The best rizzitgo spreadsheet is not the one with the most columns. It is the one you actually update every day. Start with the Essential Eight. Add secondary columns only when your workflow proves you need them. Clean data beats comprehensive data every time.