How to Build Your Own AllChinaBuy Spreadsheet

Templates are great, but a custom-built allchinabuy spreadsheet fits your exact habits. This guide shows you how to architect one from the ground up.

Define Your Workflow First

Before you add a single column, write down your typical buying process. Do you browse first and decide later? Do you pay immediately after the agent quotes? Do you ship items individually or wait for warehouse consolidation? Your workflow determines your columns.

Choose Your Core Columns

Every custom sheet needs at least these:

• Item identification — name, URL, photo thumbnail
• Financial tracking — price, shipping, fees, total
• Timeline tracking — order date, warehouse arrival, ship date, delivery date
• Quality control — QC link, RL/GL decision, notes

Add Conditional Formatting

Color coding turns a boring table into a dashboard at a glance. Set rules like: red background for "RL" (red light), green for "GL" (green light), yellow for "In Warehouse," and gray for "Delivered." In Google Sheets, use Format > Conditional Formatting. In Excel, use Home > Conditional Formatting.

Build a Summary Tab

Create a second worksheet inside the same file named "Summary." Use =SUM() formulas to pull totals from your main tracker. Show total spend, average item cost, total shipping, and number of items delivered. This summary tab is what you check when your partner asks, "How much did you spend this month?"

Protect Important Cells

If you collaborate or share your screen, lock the header row and formula columns so you do not accidentally delete a sum formula with a stray keystroke. Data > Protected Sheets and Ranges in Google Sheets handles this in seconds.