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: Oct 15, 2026, 8:27 AM
Active profile cells
133
36 SKUs · 2 warehouses
High confidence (5+ samples)
90
Used directly by cost engine
Low confidence (3-4 samples)
43
Used but flagged
Sample window
08-16 → 10-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).
133 of 133 cells
| SKU | Warehouse | Zone | Median / unit | P90 / unit | Avg / unit | Samples | Carrier mix |
|---|---|---|---|---|---|---|---|
| 10ML-EUCALYPTUS | ShipHero | 2 | $5.62 | $5.69 | $5.62 | 3 | GND: 1, GOFO Parcel Pickup: 2 |
| 10ML-EUCALYPTUS | ShipHero | 6 | $5.88 | $5.89 | $5.87 | 6 | GND: 6 |
| 10ML-EUCALYPTUS | ShipHero | 7 | $5.88 | $5.89 | $4.97 | 3 | GND: 2, GOFO Parcel Pickup: 1 |
| 10ML-EUCALYPTUS | ShipHero | 8 | $5.97 | $6.03 | $5.98 | 8 | GND: 7, GOFO Parcel Pickup: 1 |
| CLEAN-KIT | ShipHero | 4 | $6.25 | $6.30 | $6.27 | 3 | GND: 2, GOFO Parcel Pickup: 1 |
| CLEAN-KIT | ShipHero | 5 | $6.52 | $7.42 | $6.72 | 8 | GND: 6, GOFO Parcel Pickup: 2 |
| CLEAN-KIT | ShipHero East | 3 | $9.49 | $9.91 | $9.51 | 3 | USPS_GROUND_ADVANTAGE: 3 |
| CLEAN-KIT | ShipHero East | 4 | $9.70 | $9.94 | $9.76 | 13 | USPS_GROUND_ADVANTAGE: 13 |
| CLEAN-KIT | ShipHero East | 5 | $10.00 | $10.36 | $8.90 | 6 | 03: 1, USPS_GROUND_ADVANTAGE: 5 |
| COLDTUB-V1 | ShipHero | 7 | $18.84 | $18.87 | $18.06 | 4 | 03: 4 |
| COLDTUB-V1 | ShipHero | 8 | $17.03 | $17.40 | $17.15 | 4 | 03: 4 |
| DESK-RED | ShipHero | 8 | $16.19 | $18.44 | $17.00 | 3 | 03: 1, GOFO Parcel Pickup: 2 |
| ESSENTIAL-BUNDLE | ShipHero | 7 | $34.12 | $41.16 | $34.97 | 4 | 03: 4, FEDEX_GROUND: 1, GROUND_HOME_DELIVERY: 3 |
| ESSENTIAL-BUNDLE | ShipHero | 8 | $35.91 | $44.30 | $42.17 | 12 | 03: 11, GROUND_HOME_DELIVERY: 11 |
| FLOORMAT | ShipHero | 2 | $13.86 | $13.90 | $13.05 | 6 | 03: 5, GOFO Parcel Pickup: 1 |
| FLOORMAT | ShipHero | 5 | $16.46 | $18.81 | $16.76 | 3 | 03: 3 |
| FLOORMAT | ShipHero | 7 | $17.89 | $21.13 | $18.19 | 3 | 03: 2, GROUND_HOME_DELIVERY: 1 |
| FLOORMAT | ShipHero | 8 | $17.64 | $21.76 | $17.44 | 13 | 03: 2, GOFO Parcel Pickup: 2, GROUND_HOME_DELIVERY: 9 |
| FLOORMAT-3 | ShipHero | 2 | $13.85 | $13.90 | $13.69 | 4 | 03: 3, GOFO Parcel Pickup: 1 |
| FLOORMAT-3 | ShipHero | 3 | $13.86 | $15.92 | $14.69 | 3 | 03: 3 |
| FLOORMAT-3 | ShipHero | 4 | $14.39 | $16.73 | $15.33 | 3 | 03: 3 |
| FLOORMAT-3 | ShipHero | 8 | $22.33 | $42.29 | $27.60 | 7 | 02: 1, GOFO Parcel Pickup: 1, GROUND_HOME_DELIVERY: 5 |
| GO-STEAMER | ShipHero | 6 | $11.44 | $12.87 | $11.89 | 3 | 93: 1, GOFO Parcel Pickup: 2 |
| GO-STEAMER | ShipHero | 8 | $14.48 | $15.63 | $14.79 | 6 | 03: 3, GND: 2, GOFO Parcel Pickup: 1 |
| L-DIFFUSE-INV | ShipHero | 2 | $5.59 | $5.59 | $5.59 | 3 | GOFO Parcel Pickup: 3 |
| L-DIFFUSE-INV | ShipHero | 3 | $5.80 | $34.24 | $17.65 | 3 | GND: 2, STANDARD_OVERNIGHT: 1 |
| L-DIFFUSE-INV | ShipHero | 4 | $5.85 | $6.34 | $6.01 | 6 | GND: 5, GOFO Parcel Pickup: 1 |
| L-DIFFUSE-INV | ShipHero | 6 | $10.00 | $10.00 | $8.51 | 8 | GND: 2, GOFO Parcel Pickup: 1, USPS_GROUND_ADVANTAGE: 5 |
| L-DIFFUSE-INV | ShipHero | 7 | $9.70 | $10.00 | $9.26 | 7 | GND: 1, USPS_GROUND_ADVANTAGE: 6 |
| L-DIFFUSE-INV | ShipHero | 8 | $9.70 | $10.00 | $12.37 | 31 | FEDEX_GROUND_SERVICES: 1, USPS_GROUND_ADVANTAGE: 30 |
| L-DIFFUSE-RELAX | ShipHero | 2 | $5.85 | $5.85 | $5.83 | 6 | GOFO Parcel Pickup: 6 |
| L-DIFFUSE-RELAX | ShipHero | 4 | $6.11 | $6.28 | $6.15 | 6 | GND: 5, GOFO Parcel Pickup: 1 |
| L-DIFFUSE-RELAX | ShipHero | 5 | $6.31 | $7.22 | $6.55 | 8 | GND: 7, GOFO Parcel Pickup: 1 |
| L-DIFFUSE-RELAX | ShipHero | 6 | $6.33 | $6.91 | $6.53 | 5 | GND: 4, GOFO Parcel Pickup: 1 |
| L-DIFFUSE-RELAX | ShipHero | 7 | $9.70 | $10.00 | $9.74 | 5 | USPS_GROUND_ADVANTAGE: 5 |
| L-DIFFUSE-RELAX | ShipHero | 8 | $9.70 | $19.72 | $13.78 | 8 | STANDARD_OVERNIGHT: 1, USPS_GROUND_ADVANTAGE: 7 |
| L-DIFFUSE-RELAX | ShipHero East | 3 | $9.49 | $9.52 | $9.50 | 5 | USPS_GROUND_ADVANTAGE: 5 |
| L-DIFFUSE-RELAX | ShipHero East | 4 | $9.70 | $9.70 | $9.70 | 19 | USPS_GROUND_ADVANTAGE: 19 |
| L-DIFFUSE-RELAX | ShipHero East | 5 | $10.00 | $10.00 | $9.72 | 13 | GND: 1, USPS_GROUND_ADVANTAGE: 12 |
| OIL-3PACK | ShipHero | 8 | $6.36 | $7.27 | $6.56 | 9 | GND: 8, GOFO Parcel Pickup: 1 |
| PLUNGEBOX-CHILLER | ShipHero | 8 | $74.76 | $78.99 | $76.08 | 5 | 03: 1, GROUND_HOME_DELIVERY: 4 |
| PLUNGEBOX-PRO | ShipHero | 7 | $33.50 | $37.25 | $33.88 | 3 | GROUND_HOME_DELIVERY: 3 |
| PLUNGEBOX-PRO | ShipHero | 8 | $37.53 | $38.68 | $34.48 | 6 | GROUND_HOME_DELIVERY: 6 |
| PLUNGEBOX-PRO | ShipHero East | 2 | $36.12 | $36.46 | $34.20 | 3 | GROUND_HOME_DELIVERY: 3 |
| PLUNGEBOX-PRO | ShipHero East | 4 | $33.50 | $38.33 | $34.90 | 7 | GROUND_HOME_DELIVERY: 7 |
| PLUNGEBOX-PRO | ShipHero East | 5 | $38.85 | $49.28 | $39.58 | 7 | 03: 1, GROUND_HOME_DELIVERY: 6 |
| PLUNGEBOX-PRO | ShipHero East | 8 | $58.00 | $62.41 | $54.64 | 5 | GROUND_HOME_DELIVERY: 5 |
| PULSE-CONTROL-BOX | ShipHero | 4 | $6.90 | $7.28 | $6.79 | 5 | GND: 4, GOFO Parcel Pickup: 1 |
| PULSE-CONTROL-BOX | ShipHero | 5 | $6.46 | $6.93 | $6.62 | 6 | GND: 5, GOFO Parcel Pickup: 1 |
| PULSE-CONTROL-BOX | ShipHero | 6 | $6.47 | $6.65 | $6.53 | 6 | GND: 5, GOFO Parcel Pickup: 1 |
| PULSE-CONTROL-BOX | ShipHero | 7 | $6.66 | $7.43 | $6.83 | 15 | GND: 14, GOFO Parcel Pickup: 1 |
| PULSE-CONTROL-BOX | ShipHero | 8 | $6.89 | $7.80 | $7.40 | 21 | GND: 18, GOFO Parcel Pickup: 2, usps_ground_advantage: 1 |
| PULSE-ELEC | ShipHero | 4 | $17.02 | $17.16 | $17.06 | 3 | 03: 3 |
| PULSE-ELEC | ShipHero | 5 | $14.61 | $16.20 | $15.10 | 5 | 03: 5 |
| PULSE-ELEC | ShipHero | 7 | $19.69 | $22.44 | $20.42 | 4 | 03: 2, GROUND_HOME_DELIVERY: 2 |
| PULSE-ELEC | ShipHero | 8 | $19.70 | $34.85 | $24.83 | 8 | 03: 1, FEDEX_GROUND: 1, GROUND_HOME_DELIVERY: 5, usps_ground_advantage: 1 |
| PULSE-PRO | ShipHero | 2 | $34.83 | $39.22 | $40.14 | 20 | 03: 14, FEDEX_GROUND: 1, STANDARD_OVERNIGHT: 1, GROUND_HOME_DELIVERY: 1, FEDEX_GROUND_SERVICES: 3 |
| PULSE-PRO | ShipHero | 3 | $48.66 | $49.35 | $46.68 | 4 | 03: 1, GROUND_HOME_DELIVERY: 2, FEDEX_GROUND_SERVICES: 1 |
| PULSE-PRO | ShipHero | 4 | $43.56 | $50.42 | $45.13 | 16 | 03: 5, GROUND_HOME_DELIVERY: 9, FEDEX_GROUND_SERVICES: 2 |
| PULSE-PRO | ShipHero | 5 | $50.25 | $53.57 | $51.22 | 31 | 03: 11, FEDEX_GROUND: 1, GROUND_HOME_DELIVERY: 13, FEDEX_GROUND_SERVICES: 6 |
| PULSE-PRO | ShipHero | 6 | $54.41 | $61.05 | $54.68 | 14 | FEDEX_GROUND: 1, GROUND_HOME_DELIVERY: 12, FEDEX_GROUND_SERVICES: 1 |
| PULSE-PRO | ShipHero | 7 | $47.95 | $53.15 | $47.58 | 14 | GROUND_HOME_DELIVERY: 14 |
| PULSE-PRO | ShipHero | 8 | $45.19 | $54.42 | $48.08 | 45 | 03: 1, FEDEX_GROUND: 1, GROUND_HOME_DELIVERY: 43 |
| PULSE-PRO | ShipHero East | 2 | $37.03 | $41.03 | $37.95 | 8 | GROUND_HOME_DELIVERY: 8 |
| PULSE-PRO | ShipHero East | 3 | $44.63 | $46.96 | $43.68 | 9 | GROUND_HOME_DELIVERY: 9 |
| PULSE-PRO | ShipHero East | 4 | $44.05 | $50.49 | $45.80 | 50 | FEDEX_GROUND: 1, GROUND_HOME_DELIVERY: 49 |
| PULSE-PRO | ShipHero East | 5 | $54.36 | $56.43 | $51.88 | 26 | FEDEX_GROUND: 1, GROUND_HOME_DELIVERY: 25 |
| PULSE-PRO | ShipHero East | 6 | $56.72 | $58.86 | $57.50 | 3 | GROUND_HOME_DELIVERY: 3 |
| PULSEV2-ELEC | ShipHero | 2 | $13.82 | $20.49 | $12.80 | 5 | 03: 3, GOFO Parcel Pickup: 2 |
| PULSEV2-ELEC | ShipHero | 7 | $11.39 | $17.43 | $11.80 | 4 | 03: 2, GND: 2 |
| PULSEV2-ELEC | ShipHero | 8 | $17.02 | $19.55 | $15.62 | 22 | 03: 16, GND: 4, GROUND_HOME_DELIVERY: 2 |
| R-CONCENT | ShipHero | 8 | $9.70 | $9.91 | $8.16 | 4 | USPS_GROUND_ADVANTAGE: 4 |
| R-CONCENT | ShipHero East | 4 | $9.70 | $9.70 | $8.49 | 4 | USPS_GROUND_ADVANTAGE: 4 |
| R-CONCENT | ShipHero East | 5 | $10.00 | $10.00 | $10.00 | 4 | USPS_GROUND_ADVANTAGE: 4 |
| RED-SHWER | ShipHero | 2 | $6.71 | $6.91 | $6.70 | 8 | GND: 1, GOFO Parcel Pickup: 7 |
| RED-SHWER | ShipHero | 4 | $7.22 | $7.82 | $7.42 | 6 | GND: 1, GOFO Parcel Pickup: 5 |
| RED-SHWER | ShipHero | 5 | $7.35 | $7.90 | $7.55 | 7 | GND: 3, GOFO Parcel Pickup: 4 |
| RED-SHWER | ShipHero | 6 | $7.74 | $8.78 | $7.54 | 9 | GND: 2, GOFO Parcel Pickup: 7 |
| RED-SHWER | ShipHero | 7 | $9.15 | $18.63 | $12.38 | 8 | 02: 1, GND: 4, GOFO Parcel Pickup: 3 |
| RED-SHWER | ShipHero | 8 | $9.10 | $9.10 | $9.25 | 25 | GND: 3, MAX: 2, GOFO Parcel Pickup: 20 |
| RED-WAND | ShipHero | 2 | $6.91 | $6.91 | $6.77 | 6 | GOFO Parcel Pickup: 6 |
| RED-WAND | ShipHero | 4 | $7.22 | $8.31 | $7.58 | 6 | GND: 1, GOFO Parcel Pickup: 5 |
| RED-WAND | ShipHero | 5 | $7.35 | $10.10 | $8.45 | 5 | GND: 2, GOFO Parcel Pickup: 3 |
| RED-WAND | ShipHero | 6 | $11.52 | $14.40 | $12.05 | 4 | GND: 2, USPS_GROUND_ADVANTAGE: 2 |
| RED-WAND | ShipHero | 8 | $11.26 | $25.02 | $16.06 | 7 | ONE_RATE_FEDEX_2_DAY: 1, USPS_GROUND_ADVANTAGE: 6 |
| RED-WAND | ShipHero East | 4 | $11.06 | $12.21 | $11.52 | 24 | 03: 3, USPS_GROUND_ADVANTAGE: 21 |
| RED-WAND | ShipHero East | 5 | $12.90 | $12.94 | $11.96 | 11 | 03: 1, USPS_GROUND_ADVANTAGE: 10 |
| REPLACEMENT-CHAIR | ShipHero | 7 | $14.73 | $20.85 | $16.33 | 5 | 03: 3, GOFO Parcel Pickup: 1, GROUND_HOME_DELIVERY: 1 |
| REPLACEMENT-CHAIR | ShipHero | 8 | $17.75 | $22.69 | $17.68 | 13 | 03: 3, GOFO Parcel Pickup: 3, GROUND_HOME_DELIVERY: 7 |
| REPLACEMENT-STEAMER | ShipHero | 2 | $9.01 | $9.09 | $9.04 | 5 | GOFO Parcel Pickup: 5 |
| REPLACEMENT-STEAMER | ShipHero | 3 | $9.19 | $9.19 | $9.19 | 4 | GOFO Parcel Pickup: 4 |
| REPLACEMENT-STEAMER | ShipHero | 4 | $11.32 | $12.75 | $14.54 | 13 | GND: 11, GOFO Parcel Pickup: 1, STANDARD_OVERNIGHT: 1 |
| REPLACEMENT-STEAMER | ShipHero | 5 | $9.37 | $18.80 | $12.30 | 16 | 02: 2, GND: 4, GOFO Parcel Pickup: 10 |
| REPLACEMENT-STEAMER | ShipHero | 6 | $10.59 | $18.23 | $15.39 | 19 | 02: 1, 93: 1, GND: 1, GOFO Parcel Pickup: 14, STANDARD_OVERNIGHT: 1, DHL SmartMail Parcel Ground: 1 |
| REPLACEMENT-STEAMER | ShipHero | 7 | $11.63 | $13.90 | $13.55 | 21 | 02: 1, 03: 1, 93: 4, GND: 4, GOFO Parcel Pickup: 11 |
| REPLACEMENT-STEAMER | ShipHero | 8 | $12.77 | $14.44 | $14.04 | 77 | 02: 1, 03: 7, 93: 1, GND: 5, GOFO Parcel Pickup: 63 |
| REPLACEMENT-TENT | ShipHero | 8 | $19.78 | $26.21 | $20.32 | 7 | 03: 1, GOFO Parcel Pickup: 3, GROUND_HOME_DELIVERY: 3 |
| Red-Stand | ShipHero | 2 | $8.51 | $10.26 | $8.21 | 3 | 92: 1, GOFO Parcel Pickup: 2 |
| SAUNA-FAN | ShipHero | 2 | $5.78 | $6.11 | $5.90 | 5 | GOFO Parcel Pickup: 5 |
| SAUNA-FAN | ShipHero | 4 | $6.15 | $6.41 | $6.26 | 3 | GND: 2, GOFO Parcel Pickup: 1 |
| SAUNA-FAN | ShipHero | 5 | $6.36 | $7.25 | $6.47 | 16 | GND: 14, GOFO Parcel Pickup: 2 |
| SAUNA-FAN | ShipHero | 6 | $6.37 | $6.86 | $6.52 | 10 | GND: 8, GOFO Parcel Pickup: 2 |
| SAUNA-FAN | ShipHero | 7 | $6.53 | $7.44 | $7.81 | 11 | GND: 10, Priority: 1 |
| SAUNA-FAN | ShipHero | 8 | $6.71 | $7.00 | $6.78 | 41 | GND: 35, GOFO Parcel Pickup: 6 |
| SAUNA-HAT-BLACK | ShipHero | 5 | $5.89 | $5.99 | $5.93 | 3 | GND: 3 |
| SAUNA-HAT-BLACK | ShipHero | 8 | $6.21 | $30.72 | $14.38 | 5 | GND: 4, STANDARD_OVERNIGHT: 1 |
| STEAMKIT-RED1 | ShipHero | 4 | $18.25 | $30.40 | $23.31 | 3 | GROUND_HOME_DELIVERY: 3 |
| STEAMKIT-RED1 | ShipHero East | 4 | $18.39 | $23.15 | $19.77 | 5 | 03: 1, GROUND_HOME_DELIVERY: 4 |
| STEAMKIT-RED1 | ShipHero East | 5 | $25.10 | $27.04 | $23.68 | 5 | GROUND_HOME_DELIVERY: 5 |
| STEAMKIT-V1 | ShipHero | 6 | $23.80 | $24.12 | $23.83 | 3 | GROUND_HOME_DELIVERY: 3 |
| STEAMKIT-V1 | ShipHero | 8 | $17.68 | $17.82 | $17.74 | 3 | GROUND_HOME_DELIVERY: 3 |
| STEAMKIT-V1 | ShipHero East | 5 | $20.13 | $23.57 | $21.28 | 6 | GROUND_HOME_DELIVERY: 6 |
| backrest | ShipHero | 2 | $6.50 | $6.50 | $6.50 | 3 | GOFO Parcel Pickup: 3 |
| backrest | ShipHero | 5 | $7.74 | $16.82 | $11.02 | 5 | 03: 1, FEDEX_GROUND: 1, GOFO Parcel Pickup: 3 |
| backrest | ShipHero | 6 | $7.74 | $10.11 | $8.37 | 9 | GND: 3, GOFO Parcel Pickup: 6 |
| backrest | ShipHero | 7 | $8.90 | $22.08 | $12.48 | 10 | 03: 2, GOFO Parcel Pickup: 7, GROUND_HOME_DELIVERY: 1 |
| backrest | ShipHero | 8 | $9.10 | $9.10 | $9.21 | 19 | GND: 1, GOFO Parcel Pickup: 18 |
| front-panel-new | ShipHero East | 4 | $191.82 | $194.64 | $192.86 | 3 | GROUND_HOME_DELIVERY: 3 |
| red-shwer | ShipHero | 2 | $6.50 | $6.50 | $6.50 | 6 | GOFO Parcel Pickup: 6 |
| red-shwer | ShipHero | 6 | $7.74 | $8.45 | $8.04 | 8 | GOFO Parcel Pickup: 7, DHL SmartMail Parcel Ground: 1 |
| red-shwer | ShipHero | 7 | $9.00 | $9.86 | $9.25 | 6 | GND: 1, GOFO Parcel Pickup: 5 |
| red-shwer | ShipHero | 8 | $9.10 | $9.10 | $8.97 | 21 | GND: 1, GOFO Parcel Pickup: 20 |
| undrwr-1pk-lg | ShipHero | 5 | $6.21 | $6.94 | $6.51 | 3 | GND: 3 |
| undrwr-1pk-lg | ShipHero | 6 | $6.24 | $6.87 | $6.46 | 4 | GND: 4 |
| undrwr-1pk-lg | ShipHero | 8 | $6.50 | $14.84 | $9.31 | 5 | GND: 4, Priority: 1 |
| undrwr-1pk-md | ShipHero | 8 | $6.50 | $7.28 | $6.70 | 9 | GND: 8, GOFO Parcel Pickup: 1 |
| undrwr-3pk-lg | ShipHero | 8 | $8.16 | $9.37 | $8.60 | 13 | GND: 11, MAX: 1, GOFO Parcel Pickup: 1 |
| undrwr-3pk-md | ShipHero | 2 | $6.44 | $6.44 | $6.44 | 3 | GND: 3 |
| undrwr-3pk-md | ShipHero | 4 | $6.90 | $7.90 | $7.26 | 4 | GND: 4 |
| undrwr-3pk-md | ShipHero | 6 | $7.53 | $8.48 | $7.82 | 4 | GND: 3, GOFO Parcel Pickup: 1 |
| undrwr-3pk-md | ShipHero | 8 | $8.16 | $8.50 | $8.78 | 24 | GND: 18, GOFO Parcel Pickup: 5, Priority: 1 |
| undrwr-3pk-xl | ShipHero | 5 | $7.35 | $7.35 | $7.35 | 3 | GOFO Parcel Pickup: 3 |
| undrwr-3pk-xl | ShipHero | 8 | $8.19 | $19.97 | $13.09 | 3 | 02: 1, GND: 2 |