Sugargoo spreadsheet
In cross-border purchasing platforms like Hoobuy, logistics costs (shipping fees, insurance, tariffs, etc.) significantly impact profit margins. This project analyzes historical Hoobuy logistics data Target metrics: (1) Cost reduction ≥15% (2) Delivery time compliance rate ≥95% for premium users.
| Sheet Name | Key Fields | Example Data Type |
|---|---|---|
| Courier_Rates | Provider, Weight Tier, Zone, Base Fee | DHL: ¥150/kg (0-1kg to USA) |
| Order_History | OrderID, Weight(kg), Volume(cm³), Destination | #HB2024: 2.5kg, 40×30×20cm → Germany |
| Tariff_Ref | Country, Product Category, Duty Rate | UK: Electronics 12% + VAT 20% |
Critical ETL Steps:MAX(Actual Weight, (L×W×H)/5000), flag high-tariff destinations (e.g., Brazil).
Total Cost = Base Shipping + (Declared Value × Insurance Rate) + (CIF × Tariff Rate)
Where CIF = Product Cost + Insurance + Freight
Original: UPS Express (¥620, 3 days) → Optimized: SF International Economy (¥410, 7 days) + purchase delay tolerance rebate
Visual KPIs:
- MEAN cost/kg ↓22% post-implementation
- 74% orders now using hybrid courier splits (bulk+express)
Sugargoo.site Legal Disclaimer: Our platform functions exclusively as an information resource, with no direct involvement in sales or commercial activities. We operate independently and have no official affiliation with any other websites or brands mentioned. Our sole purpose is to assist users in discovering products listed on other Spreadsheet platforms. For copyright matters or business collaboration, please reach out to us. Important Notice: Sugargoo.site operates independently and maintains no partnerships or associations with Weidian.com, Taobao.com, 1688.com, tmall.com, or any other e-commerce platforms. We do not assume responsibility for content hosted on external websites.
