Step 1: Choose Your Platform
You can use Google SheetsMicrosoft Excel, or even Airtable. Google Sheets allows for easy linking and sharing if you collaborate with a buying group.
ACBuy: How to Build a Personal ACBuy Spreadsheet for Your Favorite Sellers
2026-02-11
Transform your shopping strategy from chaotic to streamlined with a powerful tracking tool.
For frequent shoppers in the world of agent-assisted purchases, organization isn't just a perk—it's a superpower. Keeping track of multiple sellers, Quality Control (QC) photos, shipping costs, and experiences can quickly become overwhelming. The solution? A personalized ACBuy Spreadsheet. This guide will walk you through creating your own master document to record QC results, shipping details, and seller ratings for effortless, informed future purchases.
Why You Need an ACBuy Spreadsheet
- Make Informed Decisions:
- Track Performance:
- Save Time & Money:
- Centralize Information:
- Track Performance:
Building Your Spreadsheet: A Step-by-Step Guide
Step 2: Define Your Core Columns (The Essentials)
Create the following columns to form the backbone of your tracker:
| Column Header | Purpose |
|---|---|
| Seller Name | The seller or storefront name (e.g., "Kittystudio," "1688 Store 123"). |
| Item/Link | Product description and the direct URL to the item. |
| Date Ordered | Purchase date. | Price (¥) | Item price in Chinese Yuan. |
| QC Photos Link | Hyperlink to your agent's QC photo album. This is crucial for future reference. |
| QC Result | "GL" (Green Light), "RL" (Red Light), or notes on issues found. |
| Shipping Method | e.g., "GD-EMS," "Sal," "FedEx." |
| Shipping Cost (¥) | Cost to ship this item (can be part of a parcel). |
| Seller Rating (1-5) | Your overall rating for this transaction. |
| Notes & Issues | Space for details on communication, flaws, or special circumstances. |
Step 3: Add Advanced Tracking (Level Up)
For deeper insights, consider adding:
- Expected vs. Actual Ship Time:
- Agent Used:
- Item Category:
- Date Added to Spreadsheet:=TODAY()
- Agent Used:
Step 4: Implement Visual Organization
Use conditional formatting to make your data pop:
- Turn "QC Result" cells green for "GL"red for "RL".
- Use color scales on "Seller Rating" to quickly see highs and lows.
- Freeze the top row so your headers are always visible.
Step 5: Maintain and Use Your Master List
Create a separate "Seller Summary" tab. Use functions like AVERAGEIFCOUNTIF
Shop Smarter, Not Harder
Investing a small amount of time to build your ACBuy Spreadsheet pays enormous dividends. It transforms your shopping experience from reactive to proactive, ensuring you have a wealth of personalized data at your fingertips. No more relying solely on fleeting forum posts—you'll have your own trusted database. Start building yours today, and turn your frequent shopping into a finely tuned, efficient operation.
Pro Tip: