Shipping Cost Profiles
Empirical per-(SKU, warehouse, zone) freight medians derived from real ShipHero invoice data. Replaces the static base_freight × zone_multiplier model with what UPS and FedEx actually billed us. Auto-refreshes bi-weekly via cron.
Bi-weekly auto-refresh runs on the 1st and 15th of each month at 8am UTC via Vercel cron.
Last refresh: Jul 15, 2026, 8:25 AM
Active profile cells
97
32 SKUs · 2 warehouses
High confidence (5+ samples)
58
Used directly by cost engine
Low confidence (3-4 samples)
39
Used but flagged
Sample window
05-16 → 07-15
From last regeneration
How profiles flow into the cost engine
On every refresh, the cost engine loads the active cohort (rows with effective_to IS NULL) and looks up per-line freight as profile[(sku, warehouse_name, zone)].freight_median_per_unit. If no profile exists for a line, it falls back to the legacy base_freight × zone_multiplier model.
A regeneration creates a new cohort with effective_from = now and marks the prior cohort superseded. Old data is preserved — if a regeneration produces weird numbers we can roll back via direct SQL by re-marking the prior cohort active (set effective_to = null on its rows and effective_to = now on the current rows).
97 of 97 cells
| SKU | Warehouse | Zone | Median / unit | P90 / unit | Avg / unit | Samples | Carrier mix |
|---|---|---|---|---|---|---|---|
| 10ML-EUCALYPTUS | ShipHero | 8 | $5.95 | $6.61 | $6.10 | 4 | GND: 3, GOFO Parcel Pickup: 1 |
| BAMBOO FLOOR MATS | ShipHero | 7 | $12.27 | $14.09 | $12.45 | 3 | 03: 1, GND: 2 |
| BAMBOO FLOOR MATS | ShipHero | 8 | $12.06 | $12.99 | $10.60 | 4 | GND: 3, GOFO Parcel Pickup: 1 |
| CLEAN-KIT | ShipHero | 4 | $6.12 | $11.03 | $7.28 | 7 | 03: 1, GND: 4, GOFO Parcel Pickup: 2 |
| CLEAN-KIT | ShipHero | 5 | $6.37 | $7.14 | $6.61 | 6 | GND: 6 |
| CLEAN-KIT | ShipHero | 6 | $6.42 | $6.42 | $6.31 | 3 | GND: 3 |
| CLEAN-KIT | ShipHero | 8 | $6.74 | $9.22 | $7.05 | 18 | GND: 10, GOFO Parcel Pickup: 5, USPS_GROUND_ADVANTAGE: 3 |
| CLEAN-KIT | ShipHero East | 4 | $7.58 | $8.07 | $7.41 | 5 | GND: 3, GOFO Parcel Pickup: 1, USPS_GROUND_ADVANTAGE: 1 |
| COMPLETE-TEE-SET | ShipHero | 7 | $7.14 | $7.14 | $6.91 | 4 | GND: 4 |
| COMPLETE-TEE-SET | ShipHero | 8 | $6.42 | $7.45 | $6.77 | 7 | GND: 7 |
| ESSENTIAL-BUNDLE | ShipHero | 8 | $43.59 | $50.50 | $42.90 | 6 | 03: 6, GROUND_HOME_DELIVERY: 4 |
| FLOORMAT | ShipHero | 8 | $15.67 | $19.90 | $16.62 | 8 | 03: 5, GOFO Parcel Pickup: 1, GROUND_HOME_DELIVERY: 2 |
| FLOORMAT-3 | ShipHero | 6 | $16.19 | $16.19 | $16.17 | 3 | 03: 3 |
| FLOORMAT-3 | ShipHero | 8 | $17.10 | $17.46 | $16.79 | 4 | 03: 2, GROUND_HOME_DELIVERY: 2 |
| GO-STEAMER | ShipHero | 8 | $13.80 | $16.48 | $14.74 | 4 | 03: 4 |
| OIL-3PACK | ShipHero | 8 | $6.48 | $7.79 | $6.78 | 7 | GND: 5, GOFO Parcel Pickup: 1, usps_ground_advantage: 1 |
| PLUNGEBOX-PRO | ShipHero | 7 | $45.10 | $56.59 | $39.52 | 3 | 03: 2, GROUND_HOME_DELIVERY: 1 |
| PLUNGEBOX-PRO | ShipHero | 8 | $38.19 | $42.96 | $36.18 | 12 | 03: 1, GROUND_HOME_DELIVERY: 11 |
| PLUNGEBOX-PRO | ShipHero East | 5 | $38.47 | $38.49 | $32.49 | 3 | GROUND_HOME_DELIVERY: 3 |
| PULSE-CONTROL-BOX | ShipHero | 6 | $6.49 | $6.49 | $6.47 | 3 | GND: 3 |
| PULSE-CONTROL-BOX | ShipHero | 8 | $7.58 | $8.07 | $7.66 | 3 | GND: 2, GOFO Parcel Pickup: 1 |
| PULSE-ELEC | ShipHero | 2 | $13.83 | $13.83 | $13.79 | 3 | 03: 3 |
| PULSE-ELEC | ShipHero | 4 | $15.71 | $16.80 | $15.90 | 4 | 03: 4 |
| PULSE-ELEC | ShipHero | 5 | $15.16 | $17.28 | $15.83 | 5 | 03: 5 |
| PULSE-ELEC | ShipHero | 6 | $17.50 | $19.93 | $18.24 | 13 | 03: 12, GROUND_HOME_DELIVERY: 1 |
| PULSE-ELEC | ShipHero | 7 | $19.41 | $19.41 | $19.29 | 5 | GROUND_HOME_DELIVERY: 5 |
| PULSE-ELEC | ShipHero | 8 | $20.88 | $25.56 | $23.35 | 16 | 03: 5, GROUND_HOME_DELIVERY: 11 |
| PULSE-PRO | ShipHero | 2 | $36.41 | $40.79 | $41.20 | 22 | 03: 10, STANDARD_OVERNIGHT: 1, GROUND_HOME_DELIVERY: 11 |
| PULSE-PRO | ShipHero | 4 | $43.37 | $50.18 | $45.45 | 14 | 03: 4, FEDEX_GROUND: 1, GROUND_HOME_DELIVERY: 9 |
| PULSE-PRO | ShipHero | 5 | $49.54 | $53.43 | $50.22 | 25 | 03: 5, FEDEX_GROUND: 1, GROUND_HOME_DELIVERY: 19 |
| PULSE-PRO | ShipHero | 6 | $49.54 | $55.30 | $49.89 | 12 | GROUND_HOME_DELIVERY: 12 |
| PULSE-PRO | ShipHero | 7 | $44.80 | $67.35 | $50.03 | 13 | 03: 3, GROUND_HOME_DELIVERY: 10 |
| PULSE-PRO | ShipHero | 8 | $46.38 | $72.08 | $52.54 | 49 | 03: 1, FEDEX_GROUND: 2, GROUND_HOME_DELIVERY: 46 |
| PULSE-PRO | ShipHero East | 2 | $38.85 | $67.48 | $45.60 | 8 | 03: 1, GROUND_HOME_DELIVERY: 7 |
| PULSE-PRO | ShipHero East | 3 | $40.02 | $59.00 | $44.13 | 15 | 03: 1, GROUND_HOME_DELIVERY: 14 |
| PULSE-PRO | ShipHero East | 4 | $47.85 | $71.41 | $52.20 | 51 | 03: 8, FEDEX_GROUND: 1, GROUND_HOME_DELIVERY: 42 |
| PULSE-PRO | ShipHero East | 5 | $49.54 | $67.76 | $55.04 | 34 | 03: 6, FEDEX_GROUND: 3, GROUND_HOME_DELIVERY: 25 |
| PULSE-PRO | ShipHero East | 6 | $65.50 | $133.49 | $86.66 | 4 | 03: 2, GROUND_HOME_DELIVERY: 1, USPS_GROUND_ADVANTAGE: 1 |
| PULSE-PRO | ShipHero East | 7 | $39.90 | $48.00 | $43.27 | 3 | 03: 2, GROUND_HOME_DELIVERY: 1 |
| PULSE-PRO | ShipHero East | 8 | $39.15 | $50.05 | $41.06 | 8 | 03: 5, GROUND_HOME_DELIVERY: 3 |
| PULSE-REMOTE | ShipHero | 6 | $6.80 | $6.80 | $6.50 | 3 | GND: 3 |
| PULSE-REMOTE | ShipHero | 8 | $6.04 | $6.76 | $6.34 | 3 | GND: 2, GOFO Parcel Pickup: 1 |
| PULSE-TENT | ShipHero | 8 | $42.52 | $73.19 | $45.71 | 4 | 13: 1, GROUND_HOME_DELIVERY: 3 |
| R-CONCENT | ShipHero | 2 | $5.53 | $5.58 | $5.50 | 3 | GND: 1, GOFO Parcel Pickup: 2 |
| R-CONCENT | ShipHero East | 3 | $6.53 | $7.73 | $5.64 | 3 | GND: 1, USPS_GROUND_ADVANTAGE: 2 |
| R-CONCENT | ShipHero East | 4 | $7.40 | $9.70 | $7.27 | 8 | GND: 4, USPS_GROUND_ADVANTAGE: 4 |
| R-CONCENT | ShipHero East | 5 | $3.55 | $8.58 | $5.42 | 5 | GND: 1, GOFO Parcel Pickup: 3, USPS_GROUND_ADVANTAGE: 1 |
| RED-WAND | ShipHero | 2 | $6.23 | $6.46 | $6.33 | 7 | GND: 7 |
| RED-WAND | ShipHero | 3 | $7.89 | $8.08 | $7.57 | 3 | GND: 3 |
| RED-WAND | ShipHero | 4 | $6.93 | $8.36 | $7.37 | 6 | GND: 6 |
| RED-WAND | ShipHero | 5 | $8.02 | $8.78 | $8.06 | 6 | GND: 5, GOFO Parcel Pickup: 1 |
| RED-WAND | ShipHero | 6 | $7.42 | $20.52 | $12.99 | 9 | 03: 2, GND: 5, STANDARD_OVERNIGHT: 1, DHL SmartMail Parcel Ground: 1 |
| RED-WAND | ShipHero | 7 | $7.77 | $18.60 | $11.30 | 6 | 02: 1, GND: 4, USPS_GROUND_ADVANTAGE: 1 |
| RED-WAND | ShipHero | 8 | $9.39 | $9.88 | $9.23 | 15 | 03: 1, GND: 13, usps_ground_advantage: 1 |
| RED-WAND | ShipHero East | 4 | $12.57 | $14.02 | $12.71 | 4 | 03: 1, USPS_GROUND_ADVANTAGE: 3 |
| RED-WAND | ShipHero East | 5 | $15.47 | $46.52 | $25.54 | 5 | 03: 3, STANDARD_OVERNIGHT: 1, USPS_GROUND_ADVANTAGE: 1 |
| REPLACEMENT-CHAIR | ShipHero | 4 | $13.72 | $15.67 | $13.02 | 3 | 03: 2, GOFO Parcel Pickup: 1 |
| REPLACEMENT-CHAIR | ShipHero | 8 | $17.48 | $21.78 | $17.28 | 5 | 03: 2, GOFO Parcel Pickup: 1, GROUND_HOME_DELIVERY: 2 |
| REPLACEMENT-STEAMER | ShipHero | 2 | $19.77 | $29.71 | $19.58 | 4 | GND: 1, GOFO Parcel Pickup: 1, GROUND_HOME_DELIVERY: 2 |
| REPLACEMENT-STEAMER | ShipHero | 4 | $22.13 | $36.02 | $22.69 | 8 | 13: 1, GND: 2, GOFO Parcel Pickup: 2, GROUND_HOME_DELIVERY: 3 |
| REPLACEMENT-STEAMER | ShipHero | 5 | $43.12 | $43.19 | $37.39 | 5 | GND: 1, GROUND_HOME_DELIVERY: 4 |
| REPLACEMENT-STEAMER | ShipHero | 6 | $10.59 | $16.78 | $13.17 | 3 | GOFO Parcel Pickup: 2, USPS_GROUND_ADVANTAGE: 1 |
| REPLACEMENT-STEAMER | ShipHero | 7 | $13.90 | $55.34 | $26.47 | 13 | 03: 2, 93: 1, GND: 2, GOFO Parcel Pickup: 3, GROUND_HOME_DELIVERY: 4, USPS_GROUND_ADVANTAGE: 1 |
| REPLACEMENT-STEAMER | ShipHero | 8 | $14.07 | $61.16 | $29.51 | 30 | 03: 6, GND: 2, FEDEX_GROUND: 1, GOFO Parcel Pickup: 12, GROUND_HOME_DELIVERY: 8, USPS_GROUND_ADVANTAGE: 1 |
| REPLACEMENT-STEAMER | ShipHero East | 4 | $14.61 | $14.86 | $14.69 | 6 | 03: 4, USPS_GROUND_ADVANTAGE: 2 |
| REPLACEMENT-STEAMER | ShipHero East | 5 | $14.95 | $18.33 | $16.37 | 9 | 03: 5, FEDEX_GROUND: 1, USPS_GROUND_ADVANTAGE: 3 |
| REPLACEMENT-STEAMER | ShipHero East | 8 | $16.63 | $19.32 | $17.51 | 5 | 03: 5 |
| REPLACEMENT-TENT | ShipHero | 2 | $9.01 | $12.30 | $8.69 | 5 | 03: 2, GND: 1, GOFO Parcel Pickup: 2 |
| REPLACEMENT-TENT | ShipHero | 8 | $14.64 | $15.58 | $14.77 | 3 | 03: 3 |
| SAUNA-CARRYINGCASE | ShipHero | 8 | $6.28 | $6.42 | $5.51 | 3 | GND: 1, GOFO Parcel Pickup: 2 |
| SAUNA-FAN | ShipHero | 4 | $6.28 | $6.44 | $6.30 | 4 | GND: 3, GOFO Parcel Pickup: 1 |
| SAUNA-FAN | ShipHero | 5 | $6.39 | $6.46 | $5.94 | 6 | GND: 3, GOFO Parcel Pickup: 3 |
| SAUNA-FAN | ShipHero | 6 | $6.44 | $7.05 | $6.18 | 6 | GND: 4, GOFO Parcel Pickup: 2 |
| SAUNA-FAN | ShipHero | 7 | $7.45 | $7.45 | $6.36 | 3 | GND: 2, GOFO Parcel Pickup: 1 |
| SAUNA-FAN | ShipHero | 8 | $6.72 | $6.95 | $6.46 | 9 | GND: 7, GOFO Parcel Pickup: 2 |
| SAUNA-GO | ShipHero | 8 | $27.27 | $32.75 | $25.84 | 6 | 03: 1, GROUND_HOME_DELIVERY: 5 |
| SAUNA-HAT-BLACK | ShipHero | 2 | $5.49 | $5.66 | $4.68 | 3 | GND: 1, GOFO Parcel Pickup: 2 |
| STEAMKIT-RED1 | ShipHero | 5 | $25.34 | $25.76 | $24.67 | 6 | 03: 6 |
| STEAMKIT-RED1 | ShipHero | 7 | $32.64 | $37.86 | $32.95 | 5 | 03: 1, GROUND_HOME_DELIVERY: 2, FEDEX_GROUND_SERVICES: 2 |
| STEAMKIT-RED1 | ShipHero | 8 | $38.73 | $41.27 | $37.94 | 14 | 03: 8, GROUND_HOME_DELIVERY: 5, FEDEX_GROUND_SERVICES: 1 |
| STEAMKIT-RED1 | ShipHero East | 3 | $38.25 | $38.25 | $31.35 | 3 | 03: 2, GROUND_HOME_DELIVERY: 1 |
| STEAMKIT-RED1 | ShipHero East | 4 | $30.30 | $38.25 | $29.65 | 8 | 03: 4, GROUND_HOME_DELIVERY: 4 |
| STEAMKIT-RED1 | ShipHero East | 5 | $30.38 | $38.25 | $30.67 | 7 | 03: 4, GROUND_HOME_DELIVERY: 3 |
| STEAMKIT-RED1 | ShipHero East | 6 | $25.06 | $27.37 | $24.69 | 3 | 03: 1, GROUND_HOME_DELIVERY: 2 |
| STEAMKIT-V1 | ShipHero East | 5 | $30.65 | $35.23 | $30.63 | 3 | 03: 2, GROUND_HOME_DELIVERY: 1 |
| backrest | ShipHero | 2 | $5.42 | $5.57 | $5.48 | 3 | GOFO Parcel Pickup: 3 |
| backrest | ShipHero | 4 | $5.69 | $5.69 | $5.68 | 3 | GND: 3 |
| backrest | ShipHero | 5 | $5.73 | $6.64 | $5.99 | 7 | GND: 7 |
| backrest | ShipHero | 6 | $5.73 | $6.39 | $5.97 | 5 | GND: 4, GOFO Parcel Pickup: 1 |
| backrest | ShipHero | 7 | $5.79 | $7.63 | $6.52 | 9 | 92: 1, GND: 7, GOFO Parcel Pickup: 1 |
| backrest | ShipHero | 8 | $5.82 | $6.97 | $6.40 | 20 | GND: 17, GOFO Parcel Pickup: 3 |
| undrwr-1pk-lg | ShipHero | 6 | $6.24 | $6.53 | $6.33 | 4 | GND: 3, GOFO Parcel Pickup: 1 |
| undrwr-1pk-lg | ShipHero | 8 | $6.51 | $7.06 | $6.69 | 5 | GND: 5 |
| undrwr-1pk-md | ShipHero | 8 | $6.58 | $6.65 | $6.58 | 4 | GND: 2, GOFO Parcel Pickup: 2 |
| undrwr-1pk-sm | ShipHero | 8 | $6.37 | $7.10 | $6.67 | 3 | GND: 3 |
| undrwr-3pk-lg | ShipHero | 8 | $8.19 | $8.29 | $8.29 | 10 | GND: 10 |
| undrwr-3pk-md | ShipHero | 8 | $8.19 | $8.25 | $8.22 | 9 | GND: 8, GOFO Parcel Pickup: 1 |