Blended shipping margin: work it out across all orders

Blended shipping margin is what shipping makes or loses per order across all the orders you send in a period: total shipping charged, minus the true cost of sending every order, divided by the number of orders. It's the one number that shows whether shipping as a whole is paying its way, because it includes the free-shipping orders, remote postcodes and odd-sized parcels that per-order checks tend to miss.

This guide shows how to work it out from a month of orders, how to read the result, and why the number can move even when you haven't touched a single price.

Why checking one order isn't enough

Most stores check shipping one order at a time. Take a typical parcel, compare what checkout charged with what it cost, and if it's close, call it fine. That's a good start, and our guide to true shipping cost per order walks through it line by line.

The trouble is that your store doesn't send one typical order. It sends a mix:

• small satchel orders that may be slightly profitable
• standard boxes that hover around break-even
• remote and regional orders that cost far more than a flat rate covers
• express orders with their own price and cost
• free-shipping orders that bring in nothing for shipping but still cost a full parcel

Each group can look reasonable on its own. Added together, they can tell a very different story. Blended margin is how you add them together properly.

The formula

Blended shipping margin per order =
    (total shipping charged − total true shipping cost) ÷ total orders

Two rules make it work:

1. Use true cost, not postage. Include packaging, handling, payment fees on shipping and an allowance for parcels that go wrong, as well as postage.
2. Count every order, including free-shipping orders. They count as $0 charged, not as orders to leave out.

It also helps to express the result against product margin, because that's where any shipping loss is paid from:

Shipping's share of product margin =
    total shipping loss ÷ total product gross margin

Step 1: group your orders

You don't need to cost every order individually. Pick four to six groups that behave differently, for example:

• Small satchel, paid shipping
• Standard box, paid shipping
• Remote or far zones, paid shipping
• Express, paid shipping
• Free shipping over your threshold

A Shopify orders export gives you most of what you need to sort orders into groups. At the time of writing, Shopify's export orders guide lists columns including Shipping (the total cost of shipping for the order, which is what the customer paid), Shipping Method, Shipping Province and Shipping Zip. That's enough to split out express orders, free-shipping orders and the states or postcodes you treat as remote.

Step 2: put a true cost on each group

For each group, work out an average true cost per order: postage plus packaging, handling, payment fees and a reship allowance. For postage, use what you actually paid Australia Post, from your account records or invoices, rather than what checkout quoted. Quoted and invoiced postage can differ when a parcel's real weight or size doesn't match what your product data said.

Keep GST consistent. If your business is registered for GST, working ex GST on both sides is usually clearest. Check whether the shipping figures in your export include GST and adjust so both columns match.

Step 3: worked example, one month

Here's a month at a made-up Australian store sending 600 orders. All figures are illustrative and exclude GST. The store charges a flat $9.95 for satchel orders, a flat $12.95 for boxes (including remote ones), $18.95 for express, and offers free shipping over a threshold.

Order group	Orders	Charged per order	True cost per order	Margin per order	Group total
Small satchel	260	$9.95	$8.40	+$1.55	+$403.00
Standard box	140	$12.95	$13.20	−$0.25	−$35.00
Remote box	40	$12.95	$21.60	−$8.65	−$346.00
Express	30	$18.95	$17.10	+$1.85	+$55.50
Free shipping	130	$0.00	$14.80	−$14.80	−$1,924.00
Total	600				−$1,846.50

Check the totals the long way:

Total charged = (260 × $9.95) + (140 × $12.95) + (40 × $12.95) + (30 × $18.95) + (130 × $0)
              = $2,587.00 + $1,813.00 + $518.00 + $568.50 + $0
              = $5,486.50

Total cost    = (260 × $8.40) + (140 × $13.20) + (40 × $21.60) + (30 × $17.10) + (130 × $14.80)
              = $2,184.00 + $1,848.00 + $864.00 + $513.00 + $1,924.00
              = $7,333.00

Net shipping  = $5,486.50 − $7,333.00 = −$1,846.50

Blended margin per order = −$1,846.50 ÷ 600 = −$3.08

Now compare it with product margin. Say the store's average product gross margin is $32 an order:

Product gross margin = 600 × $32 = $19,200
Shipping's share     = $1,846.50 ÷ $19,200 = 9.6%

Shipping is costing this store just under a tenth of its product margin.

What the example tells you

• Paid shipping roughly breaks even. The four paid groups together make $403.00 − $35.00 − $346.00 + $55.50 = +$77.50, or about $0.16 across their 470 orders. Look only at paid orders and shipping seems fine.
• Free shipping is the main cost. It accounts for $1,924.00 of the loss. That may be a good trade if the threshold is lifting basket sizes, but it should be a known trade. Our guide to setting a free shipping threshold shows how to test whether it's paying for itself, and the free shipping threshold calculator gives you a starting figure.
• Remote orders are the quiet leak. Just 40 orders lose $346.00, nearly as much as 260 satchel orders make. A flat box rate can't cover them.

Why your blended margin moves when prices don't

Say next month the store changes nothing, but a promotion pushes more customers over the free-shipping threshold: free-shipping orders rise from 130 to 200, and satchel orders fall from 260 to 190. Still 600 orders.

Lose 70 satchel orders:       70 × +$1.55  = −$108.50 of margin gone
Gain 70 free-shipping orders: 70 × −$14.80 = −$1,036.00

New net shipping = −$1,846.50 − $108.50 − $1,036.00 = −$2,991.00
New blended margin per order = −$2,991.00 ÷ 600 = −$4.99

The blended loss jumps from $3.08 to $4.99 an order without a single rate changing. Whether that's a problem depends on how much extra product margin those bigger baskets brought in, which is exactly why you check blended margin and product margin together.

The same thing happens when more orders come from remote areas, when customers start choosing express, or when a bulky product starts selling well. Your order mix is a pricing decision you didn't know you were making.

Don't average the averages

A common shortcut is to take each group's margin per order and average them:

(+$1.55 − $0.25 − $8.65 + $1.85 − $14.80) ÷ 5 = −$20.30 ÷ 5 = −$4.06

That's wrong, because it gives 30 express orders the same say as 260 satchel orders. The correct figure is −$3.08. Always add up the dollars first, then divide by total orders.

Set a target and check it

Blended margin is most useful when you compare it with a number you've chosen. A simple decision rule:

1. Pick a target. For example, "shipping can cost us no more than 8% of product margin", or "blended shipping margin of −$2.00 an order or better".
2. Check it monthly or quarterly, and after any change to rates, thresholds, packaging or your product range.
3. If you're off target, fix the biggest group total first, not the worst per-order margin. In the example, free shipping (−$1,924.00) matters more than remote orders (−$346.00), even though remote orders lose less per order.
4. Re-run the numbers after each fix so you know it worked.

The levers are the ones you'd expect: raise or restructure the free-shipping threshold, charge remote zones closer to cost, use a dollar add-on or a minimum shipping price rather than relying on a percentage markup, and cut packaging and handling costs. Our guide to shipping profitability covers how shipping margin fits into the profit on a whole order.

Where TrkShp fits

If remote and bulky orders are dragging your blended margin down, live rates help because each order is quoted on its own parcel and destination rather than a flat average. TrkShp quotes live domestic Australia Post rates at Shopify checkout, with your markup and any minimum or maximum prices applied, and its reports show quoted postage and margin across your orders. Treat that as the quoted side of the picture: your Australia Post invoice is still the final word on what you paid, and a markup isn't profit until packaging, handling and the rest are covered.

Key takeaways

• Blended shipping margin = (total shipping charged − total true shipping cost) ÷ total orders, counting free-shipping orders as $0 charged.
• In the example, paid shipping roughly broke even, but the blended margin was −$3.08 an order, or 9.6% of product margin.
• The order mix moves the number: more free-shipping orders took the loss to −$4.99 an order with no price changes.
• Weight by order count. A simple average of group margins gave −$4.06, which is wrong.
• Set a target, check it regularly, and fix the group with the biggest dollar total first.

On GST: the ATO's GST guidance covers the basics, and your accountant can confirm how it applies to your store.

Want to see what your Shopify checkout quotes for each type of order? See how TrkShp works.