PivotPlanit
Operational Analysis

Freight Cost Evaluation

Quantifying the margin leak in Shopify checkout freight pricing and evaluating solutions.

The Core Problem

Shopify checkout freight estimates do not match actual shipping cost, causing chronic underpricing and margin erosion. The kit and LTL freight now quotes correctly through the ShipX profile. The remaining leak is on parcel freight, where several older Shopify profiles (General, Small Parts, Long Guides) still carry flat or free-shipping overrides.

The fix is to audit and correct those native parcel rates at the source first. ShipStation is a label-and-tracking tool, not a checkout rate engine, so it stays on the shelf unless the native rates genuinely cannot be made accurate.

Aligned with your ops lead

We reached this conclusion first: fix the native Shopify rates before spending on ShipStation. Abraam independently landed on the same call, before moving to any new tool, audit the current profiles and correct the rates at the source. The specifics of which profiles and which freight tool (the kit and LTL side already runs through ShipX) come from his operational audit, now underway. Our role is to make sure the corrected rates tie back to accurate freight at checkout and flow into Zoho, so commission and reconciliation stay clean.

Section 1

The Freight Margin Leak

Over the last 60 days, 41 orders undercharged freight, costing approximately $4,591 in net lost margin. Shopify checkout freight prices are static estimates that do not reflect actual shipping cost, leaving money on the table with every order. With kits now quoting through ShipX, the live go-forward exposure is concentrated on the parcel profiles that still carry flat or free-shipping overrides.

Undercharged Orders
41

May 17 - Jul 16, 2026

Net Lost Margin
$4,591

After accounting for overcharges

Average Loss per Undercharged Order
$175

Median gap between Shopify and actual

Worst Case
$1,730

Order DB-6016 shortfall

The pattern: Shopify checkout estimates freight at $10-20 while actual LTL carrier quotes are $30-90+. This systematic mismatch is the root cause. Three orders (DB-6016, DB-6045, DB-6087) account for $3,132 of loss alone.

Section 2

Why Freight Pricing Is Broken

The core issue: Shopify checkout freight is a fixed or simple rule-based estimate. It does not account for real-time LTL carrier rates, which vary by weight, origin, destination, and service level.

Current workflow:

  1. Customer orders in Shopify. Dock kits quote freight through the ShipX profile, which is working. Non-kit and parcel items still fall on older profiles (General, Small Parts, Long Guides) that may carry flat or free-shipping overrides, and that is where the estimate misses.
  2. DockBlocks rep may adjust the freight on the Zoho Sales Order or in Shopify post-sale (manual process).
  3. BMS receives the order and quotes actual carrier cost from their network. The quoted cost may be higher or lower than what Shopify charged the customer.
  4. George manually reconciles the BMS ship log into Zoho, recording actual freight cost.
  5. If customer was undercharged, the loss is absorbed; if overcharged, you keep the margin (inconsistent pricing).
Section 3

What ShipStation Will and Won't Do

ShipStation is a label-and-tracking platform. It has real value for what you already asked it to do, but it cannot solve the freight-quote problem.

Capability Your Need ShipStation Status
Generate shipping labels Yes (from BMS shiplog) YES Handles well
Send tracking to customer Yes YES But Shiplog tool already does this via Brevo
Route pick tickets to BMS Yes YES Via webhook or API feed
Quote live LTL freight rates Kit/LTL already handled via ShipX NO Not needed from ShipStation
Integrate with Shopify checkout To show accurate rates pre-purchase NO Not a checkout rate engine

Bottom line: ShipStation is excellent for labels, routing, and tracking. But it is not a checkout rate engine. The freight accuracy problem gets solved by correcting the native parcel rates first, the audit Abraam is running, not by adding ShipStation.

Section 4

Fixing It: Three Approaches, Three Builds Each

This is the option space, not a locked plan. The root problem is the same in all three: Shopify checkout underprices freight on the parcel profiles that carry flat or free overrides (kits already quote via ShipX). There are three approaches, and within each there are three concrete ways to build it. The approach-level trade-offs, the ShipStation note, and our lean are at the bottom.

Approach A: Real-time LTL rate app at checkout

Live carrier rates shown at checkout by weight, dimensions, origin, and destination. Most accurate and fixes the leak at the source.

Three ways to build it:

  1. Turnkey freight app: An LTL-quote Shopify app (Eniture-style) connected to your carrier accounts. Fastest to stand up, runs on a subscription.
  2. Rate-management app: A richer rate engine (ShipperHQ-style) with conditional freight and parcel rules. More control, more configuration.
  3. Custom carrier-API integration: A small in-house app that calls your carrier's rating API directly. Most control and no per-app fee, but the most dev time.

Approach B: Calibrated freight zones from actuals

Surcharge tables built from your historical billed freight. No live carrier API. Fast to stand up and recovers most of the leak.

Three ways to build it:

  1. Shopify native zones: Weight-band and destination-zone freight rates set directly in Shopify settings. No app, the simplest option.
  2. Rate-table app: A conditional-rate app (Intuitive Shipping-style) for richer tables driven by your actuals. Moderate setup.
  3. Per-product freight metafield: Store a freight cost per product or kit (derived from actuals) and add it at checkout via a script. Most tailored, some dev.

Approach C: Quote-based freight for the heavy items

The heaviest or most irregular LTL items get a quote instead of an instant checkout price. Most accurate per order, but adds friction, so best reserved for the hardest items.

Three ways to build it:

  1. Request-a-quote flow: Freight items use a quote-request app; the customer submits and George or the rep prices it from actual carrier rates.
  2. Call-to-order plus invoice: Freight items are marked call-to-order; the rep builds the order with correct freight and sends an invoice. Mostly process, minimal build.
  3. Draft-order workflow: Staff create a Shopify draft order with accurate freight from actuals and send the customer a checkout link. Native Shopify, no app.

A note on ShipStation: it is a label, tracking, and routing platform, not an LTL rating engine. None of these approaches is ShipStation, and it does not quote freight at checkout. Keep it (or the Shiplog tool) for the post-sale workflow only.

A - Live app B - Zone tables C - Quote-based
Accuracy High Medium Highest
Setup effort High Low Low
Buy-flow friction None None High (per item)
Needs carrier API Yes No No

Recommended approach

Approach B at its simplest build: audit and correct the Shopify native parcel rates from your actual billed freight. This is the audit Abraam is already running, and it recovers most of the measured leak with no new app. Layer Approach C (draft-order workflow) on the handful of heaviest, most variable items where a table is too loose. Only move to Approach A (a turnkey freight app) or ShipStation if the native rates genuinely cannot be made accurate.

Two things hold across all of them: accurate product weight and dimensions in Shopify, and commission calculated on final billed freight, feeding back into Zoho so reconciliation stays clean. Confirm the real carrier rates with George and BMS before locking any of them.

Section 5

Expected Outcomes

Accurate freight quoting at checkout stops the margin leak and streamlines operations.

  1. Revenue protection: Stop undercharging on freight. The last 60 days show $4,591 in lost margin from freight underpricing alone. A simple day-count annualization is roughly $28,000/yr; the higher $37,700 figure also grosses up for the 56% of orders with incomplete freight-field data; that gross-up is a rough extrapolation, not a measured number. Treat both as a floor, not a forecast.
  2. Operational clarity: George no longer hand-reconciles freight mismatches. The BMS log becomes a record of actual delivery, not a freight price audit.
  3. Rep accountability: Commission ties to actual final freight, not Shopify estimates. Removes incentive to inflate freight post-sale.
  4. Customer confidence: Customers see accurate, real-time freight before they buy. No sticker shock at shipment. Better NPS.
Section 6

Why Not a Full TMS?

Enterprise Transportation Management Systems (TMS) are built for high-volume carriers and 3PLs with thousands of shipments per day and complex logistics networks. DockBlocks does not need that complexity.

Correcting the native Shopify parcel rates, with the kit and LTL side already handled by ShipX, is the right fit: simple, fast to implement, solves the real problem (freight accuracy at checkout), and leaves your BMS partnership untouched.

Prepared by: PivotPlanit

Date: July 2026