Complete visibility from your agent’s warehouse to your doorstep is crucial for a smooth haul experience. The GTBuy consolidation spreadsheet is your central command center for tracking every detail. Here’s how to use it effectively.
The Power of Centralized Tracking
Instead of juggling multiple agent notes, messages, and emails, the GTBuy spreadsheet keeps all vital shipping information in one, easy-access location. This proactive log ensures you never lose track of a parcel's status or important inspection data.
Key Data Points to Record
For full oversight, consistently update the following columns in your spreadsheet:
| Spreadsheet Column | What to Record | Why It's Important |
|---|---|---|
| QC Date & Status | The date QC photos were provided and your approval (OK/RL). | Marks the transition from "ordered" to "ready to ship," and tracks agent processing time. |
| Parcel Weight | Final weight (in kg) after rehearsal shipping. | Essential for verifying shipping cost accuracy and comparing different line options. |
| Tracking Number | The unique carrier code (e.g., UP123456789CN) assigned to your parcel. | Your direct link to live location updates from dispatch to delivery. |
| Shipping Line & Cost | The chosen carrier (e.g., GD-EMS, KR-EMS) and final paid price. | Helps analyze cost vs. speed performance for future hauls. |
| Dispatch Date | The date the agent hands the parcel to the carrier. | Sets the baseline for calculating total transit time. |
Best Practices for Full Visibility
- Update Promptly:
- Use Hyperlinks:
- Color Code Status:
- Keep a History:
- Share with Friends:
- Use Hyperlinks:
Ship With Confidence
By meticulously tracking inspection dates, parcel weights, and tracking numbers