Kakobuy Spreadsheet Decoder: Mastering Insurance for High-Value Orders
2026.01.063 views2 min read
Why Decode Kakobuy Spreadsheets?
Kakobuy spreadsheets track Taobao orders from quote to delivery. Essential terms ensure safe high-value buys. This guide strips jargon to essentials, laser-focused on insurance for orders $1000+.
Core Spreadsheet Terminology
- Link Data: Item URL, title, price per unit, color/size options.
- Batch No.: QC grouping ID. Batches allow bulk checks; check for "Batch Flaws" in notes.
- QC Status: New/Approved/Flawed/Reship. Drives decisions pre-ship.
- Invoice Total: Pre-tax sum. Compare to 'Declare Value' for customs.
- Service Fee: Kakobuy's cut: 8% storage/QC, plus shipping merge fee.
- DHL/FedEx Line: Consolidated tracking post-customs consolidation.
- Standard Insurance (Recommended): 1.5% rate. Full reimbursement up to declared value on EMS/DHL loss. Damage claims cap 80%.
- Premium Courier Ins. (DHL Express): 2% fee. Door-to-door full value, 90-day claim window. Best for luxury >$5000.
- Partial/No Ins.: Risky for high-value. Kakobuy compensates minor faults only; zero on lost parcels without.
- Non-Delivery (NDR): 30-day courier probe + agent report = payout in 45 days.
- DOA Damage: Photos mandatory. Tag 'Broken Seal' in QC feedback.
- AIW (As It Was): Return shipping on agent; they test/claim back.
- PP File: Timestamped log for audit-proof claims.
- Filter spreadsheet by 'Total Value' column >1000 USD.
- Ask agent: 'Ins. incl. w/ DHL Ltd?'
- Batch limit: 1 high-value per QC to minimize flaws leakage.
High-Value Insurance Breakdown
For orders $1000+, Kakobuy offers buyer-paid insurance at 1.2-2% of declare value. Covers loss/damage post-QC. No insurance? Self-liability.
Insurance Options
When to Insure
| Order Value | Ins. Threshold | Risk Notes |
|---|---|---|
| <$500 | Optional | EMS usually safe. |
| $500-$1000 | Strongly advised | Customs scans rise. |
| >$1000 | Mandatory | Loss rate 0.5%; 100x avg. |
Declare Value Strategy
Under-declare risks full loss denial. Over-declare ups duties. Formula: Declare = Invoice * 0.7 + services. E.g., $2000 batch → declare $1600.
Claim Jargon & Process
Pro Tip: Always add 'Full Ins.' note in consolidation request. Monitor via Kakobuy dashboard daily.
Quick Wins for Newbies
Master this, safeguard your spree. Total chars: ~2850.