Tips2026-05-23|7 min
What to Track in Your Hipobuy Spreadsheet
Not every column is worth your time. Tracking too much slows you down. Tracking too little leaves you blind. This guide lists exactly what you should include in your hipobuy spreadsheet, from essential to optional.
Essential Columns
These columns belong in every hipobuy spreadsheet. Without them, you cannot calculate profit or track status.
- Item Name - What you bought
- Purchase Link - URL to the product
- Size - Critical for clothing and shoes
- Color - Prevents mix-ups
- Unit Price - What you paid per item
- Quantity - How many you ordered
- Agent Fee - Service costs
- Shipping - Delivery cost
- Total Cost - Auto-calculated
- Selling Price - What you charge customers
- Profit - Auto-calculated
- Status - Current order stage
Recommended Columns
These columns add value without adding complexity. Include them once you are comfortable with the basics.
- Date Ordered - For tracking timelines
- Tracking Number - Shipping reference
- Weight - For shipping cost estimation
- QC Photos - Links to quality check images
- Customer Name - If doing pre-orders
- Notes - Any special details
Advanced Columns
These columns are for power users who need granular control. Only add these if you have a clear reason.
- Exchange Rate - Track currency fluctuations
- Payment Method - Paypal, Wise, etc.
- Box Size - For shipping optimization
- Agent Name - If using multiple agents
- Return Status - For refund tracking
- Margin Percentage - Profit as a percentage
Frequently Asked Questions
How many columns should I start with?
Start with the essential 12. Add recommended columns after your first 10 orders.
Can I remove columns later?
Yes. Just delete the column. Any formulas that reference it will need updating.
Should I track the same data in two places?
No. One source of truth prevents confusion. Everything should live in your sheet.
Do I need a separate sheet for each agent?
Only if you have more than 50 orders per agent. Otherwise, an Agent Name column works fine.
What if I forget to fill a column?
Leave it blank and fill it later. A partially complete sheet is better than no sheet.
Ready to Start?
Get the best hipobuy spreadsheet templates and start tracking today.