What to Track in Your ACBuy Spreadsheet: The Essential Data Checklist
An empty ACBuy spreadsheet is useless. A bloated one is overwhelming. The sweet spot lies in tracking exactly the right data points — no more, no less. This checklist reveals the essential columns every buyer needs, the optional fields that deliver outsized value, and the vanity metrics that waste your time.
The Non-Negotiable Seven
These seven columns form the backbone of every effective ACBuy spreadsheet. Skip any one of them and you create a blind spot that will cost you money or time within your first month.
1. Order ID. A unique identifier for every transaction. Use a simple pattern like ORD-2026-001. This becomes your primary key for lookups, filters, and cross-referencing across tabs.
2. Date Added. The moment you paste the product link into your sheet. This single column prevents the most common buying mistake: impulse purchases that sit for weeks while you forget about them.
3. Product Name. Not the full agent listing title — a short, human-readable name you will recognize six months later. 'Nike Panda Dunk' beats 'Nike Men's Dunk Low Retro Basketball Shoes White Black CW1590-100.'
4. Product Link. The original URL to the product listing. Use HYPERLINK() to make it clickable. When disputes arise, this is your evidence trail.
5. Agent / Store. Which service is handling this order. WeGoBuy, SuperBuy, Pandabuy, CSSBuy, or direct store. This column enables agent-comparison analysis and contact lookup.
6. Price (USD). The final price you will pay, converted to your home currency. Include product cost, domestic shipping, and agent fees. Do not estimate — check the agent checkout page and record the exact number.
7. Status. The heartbeat of your ACBuy spreadsheet. Use a strict dropdown: Pending, Paid, Shipped, In Transit, Received, Resold, Returned. Free-text status fields are a guarantee of chaos.
The High-Value Optional Five
These five columns are not mandatory for beginners, but they deliver outsized value once your order volume exceeds ten per month.
8. Size / Variant. Critical for apparel and footwear. When QC photos arrive, you need instant confirmation that the agent ordered the right size. Without this column, you are scrolling through agent chat logs.
9. Weight (kg). Essential for shipping cost estimation and reseller profit calculation. Most agents list estimated weight on the product page. Update with the actual weight when QC photos arrive.
10. Shipping Estimate. Your best guess at international shipping before the agent weighs and packages the item. Use lookup tables based on weight ranges and carrier choice. Compare this estimate to actual shipping later to improve your predictions.
11. Tracking Number. Added the moment your agent provides it. Link directly to the carrier tracking page using HYPERLINK() for one-click status checks. Without this, you are logging into three different carrier sites manually.
12. Notes. The catch-all that prevents 90% of disputes. Record sizing advice, color variations, special requests, and agent communication summaries. A single note — 'Agent confirmed embroidery will be white, not cream' — saves a $45 return.
Vanity Metrics to Avoid
Not every column deserves space in your ACBuy spreadsheet. These fields look useful but create noise without delivering actionable insight.
Seller Rating. Agent ratings change constantly and are already tracked by the platform. Recording them in your sheet adds maintenance burden for zero additional value.
Expected Delivery Date. International shipping is too unpredictable. You will update this field fifteen times per order, creating a false sense of precision. Replace it with 'Date Shipped' and calculate averages over time instead.
Screenshot Links. QC photos serve the same purpose with higher fidelity. Screenshots of product listings are redundant once the link is recorded.
Wishlist / Priority Score. These belong in a separate 'Research' sheet, not your operational tracker. Mixing aspirational and actual orders dilutes your focus.
Reseller-Specific Tracking
If you resell, your ACBuy spreadsheet needs three additional columns.
Resale Price. Your target selling price based on market research. Update when market conditions change.
Platform Fees. eBay, StockX, GOAT, or Grailed fees as a percentage. Auto-calculate with a formula: =ResalePrice*0.095 for a 9.5% platform cut.
Net Profit. The final number that matters: Resale Price minus all costs (product, shipping, platform fees, packaging). If this column is not positive, you do not buy.
| Column | Priority | When to Add | ROI |
|---|---|---|---|
| Order ID | Essential | Day 1 | Very High |
| Date Added | Essential | Day 1 | High |
| Product Name | Essential | Day 1 | High |
| Product Link | Essential | Day 1 | Very High |
| Agent/Store | Essential | Day 1 | High |
| Price (USD) | Essential | Day 1 | Very High |
| Status | Essential | Day 1 | Very High |
| Size/Variant | High-Value | Order 10+ | High |
| Weight | High-Value | Order 10+ | Medium |
| Tracking Number | High-Value | Order 10+ | High |
| Notes | High-Value | Day 1 | Very High |
| Resale Price | Reseller Only | First resale | Very High |
Get the Pre-Configured Tracker
Our templates come with every essential column, validation rules, and conditional formatting already built. No setup. No guessing. Just copy and start tracking.
View TemplatesFrequently Asked Questions
Q: Can I add custom columns for my niche?
Absolutely. The essential seven are universal, but every buyer has unique needs. Collectors might add a 'Condition Grade' column. Group buy managers need a 'Member Assignment' column. Build what serves your workflow.
Q: Should I track domestic shipping separately?
For beginners, roll it into the Price column. Once you start comparing agents, split it out. Domestic shipping varies significantly between services and affects total cost comparisons.
Q: How do I handle multi-item orders?
Create one row per item, even if they ship together. Use the same Order ID prefix with a suffix: ORD-001-A, ORD-001-B. This preserves granularity for profit tracking while maintaining grouping for shipping.
Q: What about orders I cancel or return?
Never delete rows. Change Status to 'Returned' or 'Cancelled' and add a note explaining why. These rows become valuable data for learning which sellers or products to avoid in the future.
Ready to Start Tracking Smarter?
Grab a template and start your ACBuy spreadsheet in under 10 minutes.