How to Build Your Own AllChinaBuy Spreadsheet from Scratch
Create a private directory tailored to your exact buying habits
Learn how to build a custom AllChinaBuy spreadsheet with automated filters, color coding, and formulas. Perfect for power users and small resellers.
Setting Up the Foundation
Open a new Google Sheet and create your primary columns: Item Name, Category, Seller, Product Link, Thumbnail, Price USD, Rating, Community Note, Batch Code, Size Guide, Coupon, and Last Verified Date. The key to a useful personal spreadsheet is consistency. Every row must follow the same format so your filters and formulas work correctly. Use Data > Validation to restrict the Category column to a fixed list: Shoes, Hoodies, T-Shirts, Jackets, Pants, Headwear, Sets, Underwear, Jerseys, and Accessories. This prevents typos that break your pivot tables later.
Adding Conditional Formatting
The color code system is the soul of the spreadsheet. Highlight the Rating column and apply three rules: values greater than or equal to 4.5 turn the row background light green, values between 3.5 and 4.4 turn light yellow, and values below 3.5 turn light red. Apply these rules using Format > Conditional formatting with custom formulas that reference the entire row. This gives you the same at-a-glance risk assessment that the main AllChinaBuy spreadsheet provides.
Automating with Formulas
Power users should add three key formulas. First, a price converter using =GOOGLEFINANCE to pull live USD to CNY rates. Second, a days-since-verified tracker using =TODAY minus the Last Verified Date cell. Third, a profit calculator using =(Selling Price - Cost - Shipping) / Cost for resellers. These formulas turn your static sheet into a living dashboard that updates without manual intervention.
Ready to start shopping? Visit our main site for live product listings and verified seller links.
AllChinaBuy SpreadsheetMaintaining Your Spreadsheet
A private spreadsheet is only useful if it stays current. Schedule a 15-minute weekly review every Sunday. During this review, check the main AllChinaBuy spreadsheet for new entries in your target categories, verify that your saved links still work, update prices if they have changed, and refresh your Coupons tab. Archive rows for sellers who have dropped below 3.5 rating by moving them to a separate Archive tab rather than deleting them. This preserves your order history while keeping your active sheet clean.
Summary Table
| Component | Tool | Purpose | Difficulty | Time |
|---|---|---|---|---|
| Category column | Data validation | Prevent typos | Easy | 3 min |
| Color coding | Conditional formatting | Risk visualization | Easy | 5 min |
| Price converter | =GOOGLEFINANCE | Live currency rates | Medium | 5 min |
| Age tracker | =TODAY() formula | Stale data alerts | Easy | 2 min |
| Profit calc | Custom formula | Reseller margin | Medium | 5 min |
Frequently Asked Questions
Continue Learning
Ready to Shop Smarter?
Need raw product data to populate your custom sheet? Browse verified listings on OOCBuy today.