Blog

Shopify shipping cost report: label cost vs what you charged

17 November 2026 · 9 min read · Wren Commerce

Shopify shows you two shipping numbers, and never side by side: what the customer paid you for shipping, and what you paid for the label. Merchants who offer free shipping, or a flat rate, often have no idea which orders lose money on shipping until the bill arrives. With Black Friday on 27 November and free shipping offers everywhere, this is the week to find out.

This guide shows how to build that report in Shopify's own analytics, one row per order with the label cost, the shipping charge and the difference, with a link that opens it in your admin. Then it explains every reason the two numbers don't match, and what the report leaves out.

The short version

  1. Shopify keeps the customer's shipping charge in sales and the label cost in shipping labels. The default Shipping labels by order report shows only the label cost.
  2. One ShopifyQL query puts both on one row per order, with the difference: open the shipping profit by order report.
  3. Group by order, not by day. The charge is dated the day of the order and the label the day you bought it, so a day-by-day report splits most orders into two rows.
  4. The report leaves out price adjustments, label taxes added at billing, return labels and labels bought outside Shopify. Add those from your Shopify bill.
  5. Check the losing orders for the usual causes: free shipping, wrong product weights, the default package, manual rates and UPS surcharges.

Where Shopify keeps shipping charges and label costs

What the customer paid for shippingWhat you paid for the label
Dataset in reportssalesshipping_labels
Field to useshipping_charges: after shipping discounts, before shipping taxshipping_label_costs, in your store currency
Which date it's counted onThe day the sale happenedThe day the label was created
Left outNothing for shipping: a charge that a discount covers in full counts as 0Return labels, canceled or voided labels, adjustments, and labels not bought in Shopify. New labels can take up to 24 hours to show

Why shipping_charges and not total shipping charges? total_shipping_charges adds the shipping tax you collected, which isn't yours to keep. Label costs in reports are before tax too, so shipping_charges is the fair comparison.

Step 1: Open the shipping profit by order report

In the admin, go to Analytics › Reports, click New exploration, and paste this query into the editor. Or open it in your admin with one click: the link goes to Shopify, which opens the query in the store you're signed in to. Nothing is saved until you click Save.

FROM sales, shipping_labels
  SHOW shipping_charges, shipping_label_costs,
    shipping_charges - shipping_label_costs AS shipping_profit
  GROUP BY order_name WITH TOTALS
  SINCE startOfDay(-90d) UNTIL today
  ORDER BY shipping_profit ASC
  LIMIT 1000

What each line does:

Only want the orders that lost money? Add HAVING shipping_profit < 0, or open the losing orders report:

FROM sales, shipping_labels
  SHOW shipping_charges, shipping_label_costs,
    shipping_charges - shipping_label_costs AS shipping_profit
  GROUP BY order_name WITH TOTALS
  HAVING shipping_profit < 0
  SINCE startOfDay(-90d) UNTIL today
  ORDER BY shipping_profit ASC
  LIMIT 1000

LIMIT 1000 shows up to 1,000 orders. If you shipped more than that in the range, use a shorter range, so the orders you're looking for aren't cut off.

Step 2: Why shipping charges don't match label costs

Before you treat a row as a loss, rule out the reporting reasons. These are the ones that come up again and again on the Shopify Community.

The same order shows up on two rows

You grouped by day. An order placed on Monday and shipped on Tuesday has its shipping charge on Monday and its label on Tuesday, so it shows once with a charge and no label, and once with a label and no charge. Group by order_name only.

Orders are missing from the report

Look for ONLY TOP 5 order_name (or another number) in your query. It keeps five orders per period and drops the rest entirely; TOP 5 without ONLY would put them in an "Other" row instead. Delete the TOP clause.

A label cost with a shipping charge of 0

A shipping charge with a label cost of 0

Refunded shipping

Shipping you refund is reported separately as shipping_reversals, dated the day of the refund. If you refund shipping often, add shipping_reversals to the SHOW line to see it next to each order.

Step 3: See the month-by-month total, including free shipping

One row per month, for the last 12 months: what shipping would have brought in, what discounts gave away, what customers actually paid, what labels cost and the difference. Open the monthly shipping report, or paste:

FROM sales, shipping_labels
  SHOW gross_shipping_charges, shipping_charge_discounts, shipping_charges,
    shipping_label_costs, shipping_labels,
    shipping_charges - shipping_label_costs AS shipping_profit
  TIMESERIES month WITH TOTALS
  SINCE startOfMonth(-11m) UNTIL today
  ORDER BY month ASC

shipping_charge_discounts is what your shipping discounts and free shipping offers gave up. Splitting by month also makes the date mismatch from Step 2 mostly disappear, because only orders shipped across a month end land in different rows.

Step 4: Add label price adjustments and other missing costs

The report shows the price of each label when you bought it. Your real cost can be higher:

To see them per order: go to Settings › Billing, open a bill, and in the Shipping section click the number of shipping fees. You get a breakdown by order, and each order number opens the order, where the timeline shows the reason for any adjustment. Do this monthly for the orders at the top of your loss report.

Step 5: Fix the orders that lose money

Shopify lists the reasons a label price differs from the checkout rate. Each one has a fix:

CauseWhat to do
Checkout used a different package from the one you shipped in. Checkout rates use your store's default package, or the variant's package for single-item ordersSet your default package to the box you use most, and assign packages to variants that ship in their own box
Product weights are missing or wrongWeigh the products you sell most and correct the weight on each variant. Weight drives both the checkout rate and adjustments
The customer picked a manual (flat) rateA flat rate doesn't follow the label price. Check that it covers your average_shipping_label_cost for that zone
Checkout rates come from an app, labels from Shopify (or the other way round)The two prices are unrelated. Use the same source for both
UPS in the USUPS demand and additional handling surcharges apply to labels but aren't in checkout rates. Shopify suggests adding a handling fee to UPS rates
Free shipping over a thresholdCompare the threshold with your average label cost. If an order just over the threshold costs a fifth of its value to ship, the threshold is too low

To avoid adjustments, Shopify's advice is to measure the outside of the sealed box, round up to the next whole inch, and keep the box from bulging.

A shipping check for Black Friday

Shipping is one cost; the other is what you paid for the stock. Our guide to cost per item covers the product side of your margin, and if you put prices on sale for Black Friday, the guide to putting prices back afterwards picks up from there.

Questions merchants ask

Does Shopify show the shipping label cost for each order?
Yes. The Shipping labels by order report in Analytics › Reports lists each label's cost by order, for labels bought in Shopify. It doesn't show what the customer paid for shipping, so use the query in Step 1 to see both on one row.

Why doesn't the shipping charge match the label cost?
They're calculated separately. The checkout rate uses your default or variant package and the rates you set up, while the label uses the package and service you pick when you buy it. Free shipping, flat rates, wrong weights, UPS surcharges and later price adjustments all make them differ.

Where can I see shipping label price adjustments?
In the order's timeline, and on your Shopify bill: Settings › Billing, open the bill, then click the number of shipping fees for a breakdown by order. Label reports don't include adjustments.

How much did I spend on shipping labels this year?
Open the Shipping labels over time report in Analytics › Reports and set the date range. It covers labels bought in Shopify, before adjustments and before any label tax added at billing.

Are labels from my shipping app in these reports?
No. Shopify's label reports only include labels bought in Shopify. For labels bought in an app or with your own carrier account, use that app's or carrier's billing records.