What to Track in Your Hubbuycn Spreadsheet

A hubbuycn spreadsheet is only as useful as the data you put into it. Tracking too little leaves blind spots. Tracking too much creates noise. This guide defines the sweet spot — the exact columns, metrics, and checkpoints that deliver maximum insight without overwhelming your workflow.

The Non-Negotiable Core Columns

These twelve columns form the backbone of any effective hubbuycn spreadsheet. Skip any of them and you will eventually regret it.

• Order ID — Your internal reference code
• Order Date — When the transaction happened
• Supplier Name — Critical for performance tracking over time
• Product Name — Exact, searchable name for filtering
• Category — Shoes, hoodies, accessories, etc.
• Size / Variant — Never skip this for fashion items
• Colorway — Distinguishes similar products
• Unit Cost — Price per item before shipping
• Quantity — Number of units purchased
• Shipping Fee — Often the hidden profit killer
• Total Landed Cost — (Unit Cost × Quantity) + Shipping
• Current Status — Ordered, Shipped, In Transit, Received, Listed, Sold

The Profit Tracking Layer

Knowing what you paid is only half the story. Add these columns to a second tab named "Profit Tracker" and connect them via Order ID:

• Sale Platform — eBay, Grailed, Depop, etc.
• List Price — What you asked for
• Final Sale Price — What you actually got
• Platform Fees — eBay takes roughly 13%. Grailed takes 9%.
• Shipping to Buyer — What you paid to mail it out
• Net Profit — Final Sale Price minus Total Landed Cost minus Platform Fees minus Shipping Out
• ROI % — Net Profit divided by Total Landed Cost
• Days to Sell — Received Date to Sold Date

Tracking Priority by Reseller Level

Supplier Performance Metrics

Your hubbuycn spreadsheet should do more than track orders. It should teach you who to trust. Create a "Supplier Scorecard" tab that aggregates data automatically:

• Average Shipping Time — Days from payment to delivery
• Defect Rate — Percentage of items requiring returns or discounts
• Communication Speed — Average response time to questions
• Price Stability — How often prices change after quoting
• Reorder Rate — How frequently you go back to this supplier

Seasonal and Trend Data

Fashion is seasonal. Jackets sell in October. Shorts sell in May. Add a "Seasonal Notes" column to your hubbuycn spreadsheet and tag items with buying timing insights. Over a full year, this data becomes a competitive advantage. You will know exactly when to stock up and when to hold back.

Frequently Asked Questions