HubbuyCN Spreadsheet for Resellers: Profit Tracking, Inventory, and Pricing Strategy
Reselling fashion requires a different mindset than personal buying. Every purchase is an investment. Every shipping fee is a cost of goods sold. Every day a package sits in transit is a day your capital is tied up. A personal hubbuycn spreadsheet tracks what you bought. A reseller spreadsheet tracks whether you will make money. This guide covers the exact columns, formulas, and workflows that full-time resellers use to turn buying into a business.
The Reseller Column Set: Beyond Basic Tracking
Resellers need more than order tracking. They need a financial dashboard disguised as a spreadsheet. Here are the fourteen columns that power profitable resale operations:
| Column | Purpose |
|---|---|
| Item Name | Accurate listing title |
| Buy Price | Your actual cost |
| Platform | Where you will sell |
| Platform Fee % | Commission rate |
| Platform Fee $ | Calculated commission |
| Shipping to Buyer | Your outbound shipping |
| List Price | What buyers pay |
| Net Profit | True earnings |
| Profit Margin % | Return on investment |
| Days Listed | Time since posting |
| Status | Current state |
| Supplier | Source for reorder |
| Quality Score | Your rating post-inspection |
| Reorder? | Worth buying again? |
Pricing Strategy: The 2.5x Rule and When to Break It
The 2.5x rule says your list price should be roughly 2.5 times your total landed cost. A $70 hoodie with $20 shipping costs $90 landed. List at $225. After platform fees and outbound shipping, you net approximately $90-100. That is a 100% margin.
But rules are made to be broken. Limited releases can list at 4x or 5x. Saturated markets might only support 1.8x. Your hubbuycn spreadsheet should record both your target list price and your actual sale price. The gap between them teaches you market dynamics faster than any course.
Inventory Velocity: The Metric That Matters Most
Profit margin means nothing if items never sell. Inventory velocity measures how fast stock converts to cash. Calculate it by dividing the number of items sold in a month by the average inventory held during that month. A velocity of 3.0 means you sell your entire stock three times per month. That is exceptional. A velocity of 0.3 means capital sits idle for months.
Track velocity by category in your Summary tab. If shoes move at 2.1 but accessories crawl at 0.4, shift buying budget toward shoes. Data-driven allocation beats gut feeling every time. The best resellers treat their spreadsheet like a financial analyst, not a shopping list.
New to reselling? Our beginner guide covers the foundational tracking setup you need before adding profit columns.
Start with Beginner GuideManaging Cash Flow with Spreadsheet Forecasting
Resellers die from cash flow problems, not profit problems. You might be theoretically profitable while being literally broke because $3,000 is tied up in in-transit inventory. Add a "Cash Tied Up" column that sums Buy Price for anything not yet sold. Compare it against your available bank balance weekly.
Set a cash tie-up limit. For example, never let pending inventory exceed 70% of your total working capital. When the spreadsheet shows you approaching that threshold, stop buying. List faster. Run sales. Free up cash before you become illiquid.
Frequently Asked Questions
One master sheet with a Platform column is usually better. It prevents duplicate inventory and gives you unified profit reporting. Use filters or pivot tables to view platform-specific data when needed.
Start Using HubbuyCN Spreadsheet Today
Join thousands of smart buyers who organize smarter, track better, and save money with free hubbuycn spreadsheet templates.