AllChinaBuy Spreadsheet for Resellers
How resellers use the allchinabuy spreadsheet to maximize profit, track inventory, and scale their fashion resale business efficiently.
Ready to start tracking your hauls?
Start NowReselling fashion from China is a numbers game. Your ability to track costs, calculate margins, and manage inventory determines whether you turn a profit or bleed money on every haul. The allchinabuy spreadsheet is the tool that separates hobbyists from professionals. This guide shows resellers exactly how to build a sheet that drives real business results.
The Reseller Mindset
Every purchase is an investment. You are not buying clothes for yourself. You are buying inventory for your customers. That means every dollar counts, every delay matters, and every mistake eats into your margin. A spreadsheet transforms gut feelings into data-driven decisions.
Essential Reseller Columns
Resellers need more than basic tracking. Your sheet should function as a lightweight enterprise resource planning tool. Here are the columns that matter most.
| Column | Purpose | Priority |
|---|---|---|
| Item Name | Identify product for reordering | Critical |
| Total Landed Cost | True cost including all shipping | Critical |
| Selling Price | Your listed price on platforms | Critical |
| Platform Fee | eBay, Depop, Grailed commission | Critical |
| Net Profit | What you actually keep | Critical |
| Margin % | Profit as percentage of revenue | High |
| Days to Sell | Inventory velocity tracker | High |
| Restock Flag | Yes/No based on margin & speed | Medium |
Margin Math That Matters
Most resellers calculate profit incorrectly. They subtract item cost from selling price and call it a day. The real calculation includes agent fees, domestic shipping, international shipping, packaging, platform commission, payment processing, and returns allowance. Your allchinabuy spreadsheet should capture every single one of these.
Net Profit = SellingPrice - TotalLandedCost - PlatformFee - PaymentFee - (SellingPrice * ReturnRate)Inventory Velocity Tracking
A 50% margin means nothing if the item takes 8 months to sell. Track the date you list each item and the date it sells. Calculate days-on-market. After 90 days, consider dropping the price or discontinuing that product. High margin plus fast turnover equals a winning product. High margin plus slow turnover ties up your cash.
Category Winners and Losers
Not every category performs equally. Use your spreadsheet to compare margins across product types. Shoes might have higher upfront costs but sell faster. T-shirts might have thin margins but move in volume. Jackets might have great margins but only sell in winter. Data reveals what intuition misses.
Scaling From Side Hustle to Business
When you are buying 5 items a month, manual tracking is fine. At 50 items, it breaks. At 200 items, it is impossible. The spreadsheet scales with you. Add tabs for each supplier, each season, or each selling platform. Use QUERY functions to build summary dashboards. Create templates for repeat orders so you are not rebuilding the wheel every haul.
Get the Reseller Template
Our pre-built reseller sheet includes all the columns, formulas, and dashboard views described above. Plug in your numbers and start making data-driven decisions today.
Download Reseller TemplateHandling Returns and Disputes
Returns are part of the reseller game. Add a Return Amount column and a Return Reason column. Track which suppliers generate the most returns. Over time, this data tells you who to avoid and who to double down on. One bad supplier can erase the profit from five good ones.
Frequently Asked Questions
What margin should I aim for?
Minimum 30% after all fees. Aim for 40-50% on most items. Luxury or rare pieces can justify lower margins if turnover is fast.
How do I track unsold inventory?
Use a Status column with values like Listed, Sold, Returned, and Archived. Filter by Listed to see your current inventory at any time.
Should I track every item individually?
Yes. Even identical items can have different landed costs due to exchange rate fluctuations or shipping batch differences. Individual tracking keeps your profit data accurate.
Final Thoughts for Resellers
The resellers who win are the ones who treat their spreadsheet like a business dashboard, not a shopping list. Every row is a profit opportunity. Every column is a decision input. Build your allchinabuy spreadsheet with discipline, update it with consistency, and let the data guide your growth.
Get the AllChinaBuy Spreadsheet
Join thousands of resellers tracking their fashion hauls smarter. Download free templates and start optimizing your workflow today.