Basetao's Spreadsheet System: Achieving End-to-End Traceability in Luxury Watch Purchasing
For international buyers using Basetao's purchasing agent services for luxury watches, maintaining full transparency throughout the ordering process is essential. This guide explains how Basetao's spreadsheet tracking system enables comprehensive traceability from order placement to final delivery.
1. Order Registration Phase
Field headers in Basetao's tracking spreadsheet include:
- Order ID
- Watch Model
- Chinese Market Price
- International Price
- Purchasing Agent
- Watch Model
The spreadsheet automatically timestamps all entries and records the IP address of modification sources.
2. Verification & Payment Tracking
| Status | Verification Document | Payment Record |
|---|---|---|
| Unverified | Empty | Payment pending |
| Under review | IMG_20230515_verification.jpg | Partial payment (50%) |
| Verified | Authenticity_certificate.pdf | Paid in full |
Each verification step includes:
1. Watch authentication documentation
2. Timestamped QC photos
3. Currency conversion records
3. Shipment & Customs Processing
The following dynamic tracking columns update automatically:
- Domestic tracking
- International shipping
- Customs status "ESTIMATED Declaration Value*
- International shipping
*Note: Values displayed may differ from final customs assessment in destination country.