Why Build Custom?
Pre-made templates are fantastic for beginners, but power users often need something unique. Maybe you run a reselling side business and need profit-margin columns. Maybe you organize group buys and need payment-tracking tabs. Or maybe you just prefer a minimalist layout with only the data you care about.
Building a custom allchinabuy spreadsheet from scratch gives you total control over layout, formulas, and automation. Here is exactly how to do it.
Prefer a ready-made template? We have five free ones.
Free TemplatesEssential Columns for Your Custom Sheet
Every successful allchinabuy spreadsheet contains the same ten building blocks. The table below shows each element, whether it is required, and why it matters.
| Element | Required? | Purpose |
|---|---|---|
| Item URL | Yes | Link back to the original listing for proof and reordering |
| Item Name | Yes | Human-readable label you will recognize weeks later |
| Size / Color | Yes | Prevents wrong-size disasters during agent processing |
| Price (CNY) | Yes | Base cost before any fees or shipping |
| Domestic Shipping | Yes | Cost from seller to agent warehouse (usually 8–15 CNY) |
| Agent Fee | Yes | Service charge your agent adds per item or per haul |
| Weight Estimate | Recommended | Used to calculate international shipping cost |
| Status | Yes | Track movement: Purchased → Warehouse → Shipped → Delivered |
| Notes | Optional | Seller reliability, refund status, photo links, deadlines |
| Photo Link | Optional | Backup in case the original Taobao listing is deleted |
Step-by-Step Build Process
Open a Blank Sheet
Create a new Google Sheet or Excel workbook. Name the first tab 'Active Haul' and create a second tab called 'Archive'.
Add Header Row
Type the ten column names from the table above into row 1. Freeze the first row so headers stay visible as you scroll.
Format Currency Columns
Select the Price, Domestic Shipping, and Agent Fee columns. Set format to Currency with the yuan symbol (¥).
Build the Total Formula
In a new column called 'Total Cost', enter =B2+C2+D2 (or equivalent) to auto-sum price + shipping + fee.
Add Currency Conversion
Create a cell at the top called 'Exchange Rate' and enter today's rate. Multiply your total column by this cell for your local currency.
Status Dropdown
Select the Status column, go to Data > Data Validation, and create a dropdown with: Purchased, Warehouse, Shipped, Delivered, Problem.
Conditional Formatting
Set rules: 'Delivered' turns green, 'Problem' turns red, 'Warehouse' turns yellow. This gives instant visual status.
Test with Example Data
Add three fake items to verify your formulas work. Adjust column widths so everything is readable on mobile.
Power-User Customizations
- Add a 'Profit Margin' column with =(Resale Price - Total Cost) / Resale Price for resellers.
- Create a 'Days in Warehouse' column using =TODAY() - Arrival Date to avoid storage fees.
- Use QUERY formulas in a dashboard tab to summarize spending by month or by category.
- Link Google Form submissions directly into your sheet for group-buy members to add items.
- Set up email alerts via Google Apps Script when a status changes to 'Problem'.
Continue Your Learning
Custom sheets are powerful but take time. If you want results faster, grab a free template and customize it. Read the complete allchinabuy spreadsheet guide or return to the homepage.
Frequently Asked Questions
Build It Your Way
A custom allchinabuy spreadsheet is a living tool that grows with your shopping habits. Start simple, add complexity only when you need it, and enjoy the satisfaction of a system built exactly for you.