A Guide to Combining, Tracking, and Managing Items from Multiple Sellers
Organizing a haul from multiple sellers on platforms like Weidian, Taobao, or 1688 can quickly become chaotic. The PinguBuy Spreadsheet method is the community's answer—a powerful system to consolidate all your items, costs, and quality control (QC) statuses into one central command center. Master this, and transform your shopping from stressful to seamless.
Why a Unified Spreadsheet is Non-Negotiable
Without a system, you're juggling:
- Scattered Links:
- Cost Confusion:
- QC Blind Spots:
- Shipping Calculation Nightmares:
- Cost Confusion:
The PinguBuy Spreadsheet eradicates these issues, providing clarity and control from "Add to Cart" to "Delivered to Door."
Building Your PinguBuy Master Spreadsheet: Column-by-Column
Create a new spreadsheet (Google Sheets or Excel) with the following core columns for ultimate tracking.
| Column Header | Purpose & What to Enter |
|---|---|
| Seller | The store or seller's name (e.g., "H12 Store," "Logan"). Groups items for potential consolidation. |
| Item Name / Description | A clear description (e.g., "Nike Dunk Low Grey Fog," "Stone Island Sweater"). Include size and color. |
| Original Price (¥) | The item's listed price in Chinese Yuan. |
| Domestic Shipping (¥) | Shipping cost from seller to your PinguBuy warehouse. Often ¥0 or ¥10-15. |
| Item Total (¥) | Formula: =Original Price + Domestic Shipping. Auto-calculates per-item cost. |
| PinguBuy Warehouse Status | Status: Ordered, Stored, Returned/Exchanged. Update as notifications arrive. |
| QC Photos & GL/RL | Link to the QC photos from PinguBuy. Mark GLRL |
| Weight (kg) / Dimensions | Enter the data provided by PinguBuy after storage. Crucial for freight calculation. |
| Notes / Agent Order # | PinguBuy order number, special instructions, or issues to track. Your personal audit log. |
The Efficient Management Workflow
-
Phase 1: Planning & Input
As you browse, add each potential item directly to your spreadsheet. Fill in Seller, Description, and Original Price. This becomes your shopping list and budget.
-
Phase 2: Ordering & Tracking
Submit items to PinguBuy. Update the Warehouse Status
-
Phase 3: QC & Decision
When QC photos arrive, paste the link into your sheet. Inspect and mark the item as GLRL
-
Phase 4: Consolidation & Shipping
Use the SellerItem Total
-
Phase 5: Final Cost Analysis
Add a final section to calculate: Total Item Cost + Service Fees + International Freight = Final Haul Cost.
Pro Tips for Power Users
- Use Filters
- Apply Conditional Formatting
- Create a separate Summary Tab
- Share a View-Only Link
- Apply Conditional Formatting