AllChinaBuy Spreadsheet: Complete Wiki Guide 2026

At its core, the allchinabuy spreadsheet is a structured document—typically built in Google Sheets or Microsoft Excel—that tracks every detail of your replica shopping workflow. It goes far beyond a simple shopping list. A properly configured sheet records seller information, batch codes, agent fees, shipping costs, quality ratings, and delivery timelines.

The spreadsheet format allows you to sort, filter, and analyze your purchasing history. Over time, patterns emerge. You discover which sellers consistently deliver faster, which agents offer the best shipping rates, and which product categories provide the highest value per dollar.

Replica shopping involves multiple moving parts. You might browse items on one platform, communicate with sellers through another app, pay through a third service, and track shipping through yet another. Without a central record, details slip through the cracks.

The allchinabuy spreadsheet serves as your single source of truth. When a package arrives damaged, you know exactly which seller to contact. When a friend asks for a recommendation, you have data-backed answers. When tax season arrives, your records are organized.

Start with these essential columns: Item Name, Seller Name, Batch Code, Item Price, Agent Fee, Shipping Cost, Total Cost, Order Date, Shipping Date, Delivery Date, Status, and Notes. This foundation captures the data points that matter most to new buyers.

As you gain experience, add columns for Size, Color, Weight, QC Photos Link, and Community Rating. Advanced users integrate formulas that calculate price-per-gram, estimated resale value, and profit margins for resellers.

Experienced buyers use pivot tables to analyze quarterly spending by category. They set up conditional formatting that highlights price drops below historical averages. Some integrate Google Apps Script to automatically fetch exchange rates and update prices in real time.

The most sophisticated allchinabuy spreadsheets connect to community APIs that pull live seller ratings, recent quality control photos, and current discount codes. This level of automation requires technical skill but saves enormous amounts of manual research time.

New buyers often skip recording batch codes, which makes reordering impossible when a seller changes production runs. Others forget to track shipping costs separately, distorting their understanding of true per-item costs.

Another frequent error is using inconsistent seller name formats. One entry might say "PK Kim" while another says "PK_Kim" or "Perfect Kicks." This fragmentation destroys your ability to filter and analyze seller performance. Establish naming conventions from day one.