1. Ordering & Payment Phase
As you order from each seller, immediately fill inPaid?
Streamline Your Haul: How to Manage Multi-Seller Orders with the GTBuy Spreadsheet
2026-01-18
Combining items from multiple Taobao, Weidian, or 1688 sellers into a single shipment is a cornerstone of smart agent shopping. The key to mastering this process? Organization.
Why a Centralized Spreadsheet is Essential
When you buy from different sellers, information becomes fragmented. A unified GTBuy spreadsheet helps you:
- Avoid Confusion:
- Control Budget:
- Monitor Progress:
- Simplify Communication:
- Control Budget:
Building Your GTBuy Master Spreadsheet
Create a new spreadsheet with the following column headers. This structure is your foundation.
| Column Header | Purpose & Notes |
|---|---|
| Item # | Unique identifier (e.g., 001, 002). |
| Seller/Source | Seller name or store link. |
| Item Name & Link | Description and direct product URL. |
| Options (Size/Color) | Chosen specifications. |
| Quantity | Number of units. |
| Unit Price (¥) | Price per item in RMB. |
| Total Item Cost (¥) | Quantity * Unit Price. Use formulas! |
| Domestic Shipping (¥) | Shipping fee from seller to agent's warehouse. |
| Paid? | Status: [Pending] / [Paid to Seller] / [Paid to Agent]. |
| Warehouse Arrival Date | Date the agent receives the item. |
| Weight (kg) | Crucial. |
| Consolidation Status | E.g., [Not Submitted] / [In Warehouse] / [Consolidated]. |
| International Shipping | Courier chosen (e.g., SAL, EMS, DHL) and cost. |
| Tracking Number | For the final international parcel. |
| Notes | Any special instructions or issues. |
The Workflow: From Ordering to Your Doorstep
2. Warehouse & Consolidation Phase
When items arrive at your agent's warehouse, update the Warehouse Arrival Date. The agent will provide the actual weight—input this data promptly. Once all desired items arrive, submit a consolidation request to your agent. Update the Consolidation Status
3. International Shipping Phase
After paying for international shipping, fill in the International ShippingTracking Number. Your spreadsheet is now a complete financial and logistical record of the entire haul.
Pro Tips for Spreadsheet Mastery
- Use Formulas:GRAND TOTAL
- Freeze the Top Row:
- Link Everything:
- Share with Care:view-only
- Archive Completed Hauls:
- Freeze the Top Row: