Managing dozens of items from different sellers can quickly become chaotic. This step-by-step guide will teach you how to use the SuperBuy Spreadsheet to categorize your orders, track quality control, and plan your consolidated shipping like a pro.
Why You Need a System
Placing a large order, or "haul," through a purchasing agent like SuperBuy involves multiple stages: ordering, warehousing, quality control (QC), and finally, international shipping. Without organization, you can lose track of items, miss QC photos, and make costly shipping mistakes. The SuperBuy Spreadsheet
Part 1: Setting Up Your Spreadsheet Foundation
Create a new spreadsheet (using Google Sheets, Microsoft Excel, or similar). Establish the following core columns to form the backbone of your tracking system:
- Item #:
- Item Name / Description:
- Seller / Link:
- Price (¥):
- SuperBuy Order #:
- Warehouse Status:Ordered, Stored, Arrived.
- QC Photos:
- Weight (g):
- Shipping Box #:
- Notes:
- Item Name / Description:
Part 2: Categorizing Orders & Tracking QC Updates
As your items are purchased and arrive at the SuperBuy warehouse, your spreadsheet becomes your command center.
Effective Categorization
Add a Category
When an item arrives, SuperBuy provides QC photos. Immediately update your spreadsheet:Managing QC Photos
This system ensures no item's QC check is overlooked.
Part 3: Planning & Executing Consolidated Shipping
This is where the spreadsheet saves you time and money. Before submitting your parcel for international shipping, follow these steps:
1. Weight Aggregation
Once all items have arrived and have their weight recorded, use the SUM function
Use the CategoryNotes
Filter your spreadsheet to show only items with "Arrived""GL"ship-ready
2. Strategic Packing
3. Final Submission Checklist
Pro-Tips for Spreadsheet Power Users
- Use Color Coding:
- Freeze the Top Row:
- Create a Summary Cell:
- Share with Friends:
- Freeze the Top Row: