Learn how resellers use superbuy spreadsheets to track inventory, calculate profit margins, and manage multi-buyer orders efficiently.
Reselling fashion requires a different level of organization than personal shopping. A single reseller might manage hundreds of items, multiple buyers, fluctuating prices, and complex shipping logistics. A standard superbuy spreadsheet is not enough. You need a reseller-grade system.
This guide shows you how to build a spreadsheet that tracks inventory, calculates profit margins, manages buyer orders, and generates reports your accountant will love.
Reseller Column Structure
| Column | Purpose | Formula/Format |
|---|---|---|
| SKU | Unique item identifier | Custom code like SNK-001 |
| Buy Price | What you paid the supplier | Currency number |
| Sell Price | What the buyer pays | Currency number |
| Platform Fee | Percentage taken by marketplace | =Sell Price * 0.05 |
| Shipping to Buyer | Cost to ship sold item | Currency number |
| Net Profit | True earnings | =Sell Price - Buy Price - Platform Fee - Shipping |
| Profit Margin | Profit percentage | =Net Profit / Sell Price |
| Days to Sell | How long item sat in inventory | =Sell Date - Buy Date |
| Buyer ID | Who bought it | Text or email |
| Status | In Stock, Sold, Returned | Dropdown |
Profit Dashboard for Resellers
Monthly Profit Summary
Auto-calculate total profit, average margin, and best-selling category each month.
Inventory Value
Sum the Buy Price of all items with Status 'In Stock' to know your current inventory investment.
Dead Stock Alert
Flag items that have been In Stock for more than 90 days. These are candidates for price drops or promotional sales.
Buyer Leaderboard
Rank your repeat buyers by total purchase volume. Use this to identify VIP customers for exclusive offers.
Reseller Workflow Tips
Buy Phase
When you purchase from a supplier, add the item immediately with status In Stock. Record exact buy price including shipping to your warehouse.
List Phase
When you list the item for sale, add a Listing Date column and update the Status to Listed. This helps track listing-to-sale conversion rates.
Sell Phase
When a buyer purchases, update Status to Sold, record Sell Price, Buyer ID, and Sell Date. Profit calculates automatically.
Ship Phase
Record actual shipping cost to the buyer. Update Status to Shipped. If shipping cost differs from estimate, note the difference.
Review Phase
Monthly, review dead stock, low-margin items, and slow-moving categories. Use this data to adjust your buying strategy.
Reseller-Specific Pitfalls
Ignoring Platform Fees
Many resellers calculate profit as Sell Price minus Buy Price. They forget marketplace fees, payment processing, and shipping. True profit is always lower than expected.
Not Tracking Returns
Returns destroy profit. Track return rates by category and seller. If a category has a 30% return rate, stop buying it.
Mixing Personal and Business
Use separate sheets for personal shopping and reselling. Tax reporting becomes a nightmare when they are mixed.
Forgetting Storage Costs
If you rent warehouse space or use fulfillment services, allocate a portion of storage cost to each item. This is a hidden profit killer.
Learn how to organize bulk orders for maximum reseller efficiency.
Frequently Asked Questions
What profit margin should resellers aim for?
Aim for at least 30% net profit margin after all fees and shipping. Lower margins become unprofitable when you account for returns, storage, and time spent.
Should resellers use separate spreadsheets per platform?
If you sell on multiple platforms, one master sheet with a Platform column is usually better. It gives you a unified view of your entire business.
How do I handle inventory across multiple warehouses?
Add a Warehouse Location column. Use filter views to see stock per location. For large operations, consider one sheet per warehouse with a master summary.
Can I use my reseller sheet for tax reporting?
Yes, if you track all income and expenses accurately. Export your sheet annually. Your accountant will need buy prices, sell prices, fees, and shipping costs.
What is the best way to handle pre-orders?
Conclusion
Mastering superbuy spreadsheet techniques takes practice, but the rewards are immediate. From saving money on duplicate purchases to organizing complex group orders, a well-built spreadsheet transforms your entire shopping experience.
Start with the basics, add features gradually, and review your data monthly. The best tracking system is the one you actually maintain. For more guides, templates, and tips, explore our related articles below or visit our main store for the latest fashion drops.
Related Articles
Continue Your Superbuy Spreadsheet Journey
Take control of your fashion purchases with our comprehensive guides and tutorials.