Managing a large number of items from different sellers can quickly become complicated. This guide walks you through using the powerful SuperBuy Spreadsheet to categorize orders, track Quality Control (QC) updates, and plan your consolidated shipping efficiently.
Why You Need a System (And Why the Spreadsheet Works)
A "haul" typically involves purchasing multiple items—often from platforms like Taobao or Weidian—and having them shipped to a warehouse (SuperBuySuperBuy Spreadsheet
Setting Up Your Spreadsheet: Core Columns
Create a new spreadsheet with the following essential columns. This structure is your foundation.
| Column Name | Purpose | Example Entry |
|---|---|---|
| Item # | Unique identifier for each item (e.g., 001, 002). | 001 |
| Item Name / Description | Brief description (e.g., "Navy Cable Knit Sweater"). | Men's Casual Jacket |
| Seller / Store | Seller name for future reference. | TopStores_TaoBao |
| Price (¥) | Item cost in Chinese Yuan. | 199.00 |
| SuperBuy Order # | Critical: The order number from your SuperBuy account. | EB12345678 |
| Warehouse Status | Stage of item: Ordered, Purchased, Stored, etc. | Stored |
| QC Photos Link | Hyperlink to SuperBuy's QC photos for easy checking. | [Link to QC] |
| QC Status | Your decision: Pending, Approved, Exchanged, Returned. | Approved |
| Weight (kg) / Dimensions | From the warehouse page—crucial for shipping calc. | 0.75 kg |
| Shipping Group | For consolidation (e.g., "Group A: Winter Clothes"). | Group A |
The Workflow: From Purchase to Shipment
1. Categorizing & Logging Orders
Immediately after submitting a purchase request on SuperBuy, add the item to your spreadsheet. Fill in all known columns. Use the "Shipping Group"
2. Tracking QC Updates Efficiently
Once an item arrives at the SuperBuy warehouse, QC photos are uploaded. This is your checkpoint:
- Update the "Warehouse Status"
- Paste the direct link to the QC photos in its column.
- Inspect the photos and update the "QC Status".
- Approved:
- Exchanged/Returned:
Color-coding cells (e.g., green for Approved, yellow for Pending) provides a fantastic visual overview.
3. Planning Consolidated Shipping
This is where the spreadsheet pays off. When ready to ship internationally:
- Filter by "QC Status = Approved"
- Review your "Shipping Group" column.
- Use the recorded Weight/Dimensions
- In your SuperBuy warehouse, select all items belonging to your chosen group and submit for consolidation.
- Finally, add a new column for "Parcel Tracking #"
- Review your "Shipping Group" column.
Pro Tips for Spreadsheet Mastery
- Freeze the Top Row:
- Use Data Validation:
- Leverage SUM Functions:
- Share with Friends:
- Use Data Validation: