Best Items to Track in Your Lovegobuy Spreadsheet
Introduction
Not all data is created equal. A bloated spreadsheet with fifty columns slows you down. A lean sheet with the right ten columns saves you money. This guide covers the best items to track in your lovegobuy spreadsheet — the data points that directly prevent mistakes, delays, and unexpected costs.
The Essential Seven
These seven data points are non-negotiable. Skip any of them, and you increase your risk of an expensive mistake.
1. Product URL
Paste the exact oocbuy.com product link. If an item arrives wrong, you need the original listing to prove what you ordered. This single column has saved resellers thousands in dispute resolution.
2. Exact Size and Variant
Do not write Large. Write Large — Asian sizing, fits like US Medium. Variants include color, material, edition, and package contents. Be specific enough that a stranger could reorder the exact same item.
3. Unit Price in CNY
Record the Chinese yuan price at the time of ordering. Exchange rates shift daily, so the USD equivalent on the day you buy may differ from the day you check out.
4. Estimated Weight
Shipping costs more than the product on many hauls. Check the product page for weight or estimate based on similar items. Hoodies run 0.4-0.6kg. Sneakers run 0.8-1.2kg per pair.
5. Agent Fee Percentage
Most agents charge 5-10%. Track this per item so you can compare agents if you use more than one. Some agents waive fees on certain categories.
6. Status with Timestamps
Track status plus the date. Ordered — May 3 tells you how long items have been in limbo. Patterns emerge: if every shoe takes three weeks to ship, you know to pad your timeline next time.
7. Notes Field
A catch-all for anything unusual. Fragile — request bubble wrap. Seller has slow shipping — add buffer. Compare to item #17 before buying. This free-text field becomes your institutional memory.
The Nice-to-Have Three
These three items are not essential for beginners but add serious value for repeat buyers and resellers.
Seller Name: Track which suppliers deliver quality on time. Over multiple orders, you will identify reliable sellers and ones to avoid.
Product Image: Use the IMAGE() function in Google Sheets to embed a thumbnail. When packages arrive, match items to photos instantly.
Resale Price Estimate: For resellers, this column turns your order sheet into a profit forecast. The difference between purchase cost and estimated resale is your projected margin.
Conclusion
The best lovegobuy spreadsheet does not track everything. It tracks the right things. Start with the Essential Seven, add the Nice-to-Haves as you grow, and delete any column you have not looked at in three orders. Lean sheets get used. Bloated sheets get abandoned.
Summary Comparison
| Data Point | Priority | Prevents | When to Add |
|---|---|---|---|
| Product URL | Essential | Wrong item disputes | First order |
| Size/Variant | Essential | Unsellable inventory | First order |
| Unit Price (CNY) | Essential | Budget surprises | First order |
| Est. Weight | Essential | Shipping shock | First order |
| Agent Fee % | Essential | Hidden costs | First order |
| Status + Date | Essential | Lost packages | First order |
| Notes | Essential | Repeated mistakes | First order |
| Seller Name | Nice-to-have | Bad suppliers | After 3 orders |
| Product Image | Nice-to-have | Misidentification | Anytime |
| Resale Price | Nice-to-have | Unprofitable buys | When reselling |
Related Reading
Frequently Asked Questions
Should I track the product description?
How specific should size tracking be?
What if a product has no weight listed?
Ready to Start Organizing?
Get our free lovegobuy spreadsheet template and start tracking your orders like a pro today.
Start Buying on OOCBuy