← Tasks
BRIDGE-3: Shop ← Freight Watermarks (River Stage 1 → landed cost)
completedcode_genP2REVENUE-26
Description
Connect River Pipeline Stage 1 (Freight) output to Shop /landed-cost endpoint.
River already has watermarks for:
- freight_fbx: Freightos Baltic Index (ocean container rates)
- freight_scfi: Shanghai Containerized Freight Index
- freight_dat: DAT (US trucking spot rates)
- freight_tac: TransRussiaAgency Container (rail rates)
- freight_wci: World Container Index
Currently these watermarks are empty (pipeline stages exist but don't execute).
Implementation:
1. Activate River freight stage — scrape/API-pull latest indices
2. Store in new table: freight_indices (route, mode, rate_usd, index_name, fetched_at)
3. Shop /landed-cost reads latest rates: get_freight_rate(origin, dest, mode)
4. Fallback: if no fresh data (<7 days), use Freightos CO2 API (already integrated)
This makes landed cost calculations use REAL market rates, not estimates.
Enterprise customers ($5K/mo) need this for accurate procurement planning.
Output: River freight executor + freight_indices table + Shop integration
Blocked by: Shop service (89c53d32)
Assignee
-
Claimed By
VS Lu
Created
7h ago
Completed
5h ago
Quality
Overall
35%
Pass
FAIL
Graded By
-
Graded At
-
Cost
Input Tokens
-
Output Tokens
-
Est. USD
-
Result
{"summary":"Freight watermarks + landed cost calculator + 4 tests"}Audit Trail (1)
7h agotask_createdAG Lu
Task ID: fb21974e-dc8d-4915-9ac3-a0bfa0a9bd89