AllChinaBuy Spreadsheet Tutorial: Step-by-Step Workflow
A hands-on walkthrough from spreadsheet row to delivered package
Follow this step-by-step AllChinaBuy spreadsheet tutorial to go from first search to confirmed delivery. Includes filters, coupons, and tracking tips.
Step 1: Open the Right Tab
The spreadsheet contains five primary tabs: Hot Picks, Full Catalog, Sellers, Coupons, and Size Guides. Beginners should start with Hot Picks because every entry has been manually reviewed by maintainers. Power users gravitate toward Full Catalog because it contains 10x more items with advanced filtering. Sellers tab is a reference directory of store ratings and contact methods. Coupons tab aggregates active discount codes from verified sellers. Size Guides tab translates Chinese measurements into US, UK, and EU equivalents with real buyer photos.
Step 2: Apply Filters Like a Pro
In the Full Catalog tab, cell B1 contains a category drop-down. Select your target category. Then click the filter arrow on the Rating column and choose Sort A to Z. This surfaces the most trusted sellers first. Next, filter the Price column to your budget range. Pro tip: keep the filter bar pinned so you can toggle between categories without losing your sort order. The spreadsheet also supports keyword search inside the Name column using Ctrl+F. Search for batch codes like LW, OG, or PK to find specific manufacturer versions.
Step 3: Verify Before You Buy
Never order from a row without completing the three-check rule. Check one: open the product link and verify the thumbnail in the spreadsheet matches the live listing photo. Sellers sometimes swap images after a spreadsheet row is created. Check two: read the last five community notes for that row. If the last three notes mention delayed shipping or changed materials, pause. Check three: cross-reference the seller name in the Sellers tab to confirm their overall store rating has not dropped below 4.0 in the past month.
Ready to start shopping? Visit our main site for live product listings and verified seller links.
AllChinaBuy SpreadsheetStep 4: Coupon Hunting and Checkout
Before adding anything to cart, open the Coupons tab and search for your seller name. Copy the exact code including capitalization. During checkout, paste the code into the seller's coupon field. Some sellers auto-apply coupons at checkout, but manual entry usually unlocks larger discounts. After placing your order, screenshot the confirmation page and save your order number in a personal tracking document. Share your order number in the community Discord if you want real-time tracking help from veteran buyers.
Summary Table
| Step | Tab | Action | Time | Result |
|---|---|---|---|---|
| 1 | Hot Picks | Pick a category | 2 min | Filtered shortlist |
| 2 | Full Catalog | Sort by rating | 1 min | Ranked results |
| 3 | Sellers | Verify store score | 2 min | Risk confirmed |
| 4 | Coupons | Copy active code | 1 min | 10-25% savings |
| 5 | Checkout | Apply + pay | 3 min | Order placed |
| 6 | Discord | Share order # | 1 min | Community tracking |
Frequently Asked Questions
Continue Learning
Ready to Shop Smarter?
Put this tutorial into practice. Browse live listings and verified seller links on OOCBuy now.