A reseller-focused guide to transforming your AllChinaBuy spreadsheet into a complete profit and inventory management system. This article is part of our comprehensive resource hub dedicated to helping you optimize allchinabuy spreadsheet workflows. Whether you are a beginner or a power user, the strategies below will save you time and money.
Why Resellers Need Different Tracking
Personal buyers care about total cost. Resellers care about net profit. The difference is massive. A fifty-dollar hoodie that costs sixty-five dollars landed might still be profitable if it resells for one hundred twenty dollars. But only if you tracked every fee correctly. Reseller spreadsheets focus on margin, not just expense.
The Profit Stack
Every resale has layers of cost. Product cost. Agent fees. International shipping. Domestic shipping to your customer. Platform fees for eBay, Depop, or Grailed. Payment processing fees. Return reserves. Our reseller template tracks all seven layers in separate columns. The Net Profit column at the end shows the truth. Many items that look profitable at first glance are actually loss-making once all layers stack.
Platform-Specific Fee Columns
Each sales platform takes a different cut. eBay charges insertion fees plus final value fees. Depop takes a flat ten percent. Grailed varies by category. Our template includes toggleable platform fee columns. When you sell an item, select the platform from a drop-down and the fee auto-calculates. This prevents the common mistake of pricing at the same margin across every platform.
Inventory Sync Across Channels
Selling on three platforms means tracking stock across three interfaces. Our template includes an Available Quantity column linked to sales tabs for each platform. When you mark an item sold on eBay, the available quantity drops. When it hits zero, a conditional formatting rule turns the row red. This prevents the nightmare of selling an item you no longer have in stock.
| Platform | Fee Type | Typical Rate | Tracking Column |
|---|---|---|---|
| eBay | Insertion + FVF | 13-15% | eBay Fees |
| Depop | Flat commission | 10% | Depop Fees |
| Grailed | Category rate | 9% | Grailed Fees |
| PayPal | Processing | 2.9% + $0.30 | Payment Fees |
| Direct | None | 0% | Direct Sales |
Ready to Put This Into Practice?
Head to our main store to start sourcing products, then track every order with the strategies in this guide.
