Managing multiple purchases, forwarders, and deadlines can be overwhelming. The GTBuy consolidation spreadsheet is your central command center to track everything from item status to final shipment. Here’s how to use it effectively.
1. Initial Setup & Structure
Begin by creating a new spreadsheet. Establish the following core columns:
- Item ID/Link:
- Vendor/Store:
- Item Status:Ordered, Received at WH, In Storage, Shipped.
- Warehouse (WH):
- Storage Entry Date:
- Consolidation #:
- Final Shipping Deadline:
- Weight/Dimensions:
- Notes:
- Vendor/Store:
2. Monitoring Item Status
Real-time tracking is key. Update the Item Status
Tip:
3. Managing Warehouse Storage & Deadlines
Avoid costly storage fees and missed shipments:
- Sort or filter by Warehouse
- Use the Storage Entry Date
- Highlight the Final Shipping Deadline
- Group items destined for the same final country into the same Consolidation #.
- Use the Storage Entry Date
4. Executing Consolidation
When ready to ship a batch:
- Filter your spreadsheet by Consolidation #
- Verify all items in that group show "Received at WH""In Storage".
- Provide this filtered list to your forwarder for accurate packing.
- Once the forwarder confirms dispatch, update all items in the batch to "Shipped"
Summary: Benefits of the System
Using the GTBuy spreadsheet provides:
- Clarity:
- Control:
- Cost-Efficiency:
- Accountability:
- Control:
Start with this template, and adapt the columns to fit your specific workflow. Happy sourcing and consolidating!