Why Resellers Need a Different Spreadsheet
Casual shoppers track items until they arrive. Resellers track items for their entire lifecycle — from sourcing cost to resale price to customer review. A standard allchinabuy spreadsheet covers the first half. Resellers need the second half too.
Without proper tracking, resellers consistently underestimate costs. Platform fees, packaging, returns, and storage fees eat into margins that looked healthy on paper. Our reseller template exposes every hidden cost before you place an order.
Just getting started? Grab our free reseller template.
Free TemplatesReseller Tracking vs Basic Tracking
The comparison table below shows what resellers gain by upgrading from basic order tracking to a full business spreadsheet.
| Metric | Tracker | Manual | Value |
|---|---|---|---|
| Cost per unit | Yes | Sometimes | Prevents over-ordering |
| Profit margin | Auto-calculated | Guesswork | $50+ per haul |
| Inventory count | Running total | Mental count | Zero stockouts |
| Seller reliability | Logged per item | Forgotten | Better sourcing |
| Shipping cost/unit | Weight-based | Estimated total | Accurate pricing |
| Reorder timing | Date-logged | Reactive | Never miss trends |
| Platform fees | Deducted auto | Often missed | True net profit |
| Tax records | Exportable CSV | Scattered | Clean accounting |
Essential Reseller Columns
Add these six columns to any basic template to create a reseller powerhouse:
Resale Price
The price you plan to list the item for on your platform.
Platform Fee %
eBay takes 13%, Depop takes 10%, Grailed takes 9%. Enter your platform's cut so profit formulas are accurate.
Packaging Cost
Mailers, tape, labels, and inserts. Usually $0.50–$2.00 per item depending on your setup.
True Profit
= Resale Price - Item Cost - All Fees - Shipping - Packaging. This is your real number.
Profit Margin %
= True Profit / Resale Price. Aim for 30%+ to cover returns and unsold inventory.
Days to Sell
Log how long each item takes to sell. Use this data to predict cash flow and identify slow movers.
Reseller Workflow Tips
- Use a 'Reorder Trigger' column. When inventory hits 3 units, the cell turns red. Never stock out during a trend spike.
- Log seller quality scores (1–5) after every delivery. Build a whitelist of reliable sources.
- Create a 'Returns' tab to track return reasons. If 30% of returns are size-related, adjust your size guide.
- Export monthly CSVs for tax season. Every cost, fee, and resale is already logged and calculated.
- Set a minimum margin rule. If True Profit Margin drops below 25%, flag the item yellow and reconsider.
Continue Your Learning
Reselling is a business, and businesses run on data. Explore advanced allchinabuy spreadsheet tips, or learn about bulk buying for better margins. Return to the homepage.
Frequently Asked Questions
Run Your Business Like a Pro
The resellers who succeed long-term are not the ones with the best taste — they are the ones with the best data. Build your reseller allchinabuy spreadsheet today and turn every haul into a profit prediction.