A systematic guide to tracking item status, warehouse storage, and shipping deadlines across all your packages.
Why the Spreadsheet is Your Central Command
Managing multiple international orders across different sellers and timeframes is complex. The GTBuy Consolidation Spreadsheet
Setting Up Your Master Spreadsheet
Begin by creating a new spreadsheet. Essential columns to include are:
- Item Name & Link:
- Seller/Store:
- Order Date & Tracking #:
- Status:Ordered, Shipped, Arrived at GTBuy Warehouse, Inspected, Awaiting Consolidation, Consolidated, Shipped Internationally, Delivered.
- Warehouse Storage Date:
- Deadline for Consolidation:
- Weight & Declared Value:
- Consolidation Package #:
- Seller/Store:
The Planning Workflow: Step-by-Step
Phase 1: Order Entry & Initial Tracking
As soon as you place an order, log it immediately. Fill in the Seller, Order Date, and paste the Tracking Number. Set the Status
Phase 2: Monitoring Warehouse Arrival & Storage
Once GTBuy's warehouse scans your package, update its StatusWarehouse Storage Date
Phase 3: Strategic Consolidation Planning
Here’s where planning pays off. Your spreadsheet allows you to see all warehouse-arrived items at a glance.
- Group by Deadline:
- Group by Category:
- Optimize Weight & Cost:
- Group by Category:
Assign a Consolidation Package #
Phase 4: Execution & Final Shipping
Instruct your agent to consolidate the items according to your planned Package #. Update all items in that group to Status
Pro Tips for Spreadsheet Power Users
- Use Filter Views
- Employ Conditional Formatting
- Create a separate Summary Tab
- Share View-Only Access
- Employ Conditional Formatting