Shopify shipping cost report: label cost vs what you charged
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
- 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.
- One ShopifyQL query puts both on one row per order, with the difference: open the shipping profit by order report.
- 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.
- The report leaves out price adjustments, label taxes added at billing, return labels and labels bought outside Shopify. Add those from your Shopify bill.
- 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 shipping | What you paid for the label | |
|---|---|---|
| Dataset in reports | sales | shipping_labels |
| Field to use | shipping_charges: after shipping discounts, before shipping tax | shipping_label_costs, in your store currency |
| Which date it's counted on | The day the sale happened | The day the label was created |
| Left out | Nothing for shipping: a charge that a discount covers in full counts as 0 | Return 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:
FROM sales, shipping_labelsreads both datasets in one report.shipping_charges - shipping_label_costs AS shipping_profitadds a column with the difference. A negative number is an order where the label cost more than the customer paid.GROUP BY order_namegives one row per order. Don't addday: that's what splits orders in two (Step 2).ORDER BY shipping_profit ASCputs the biggest losses at the top.SINCE startOfDay(-90d)covers the last 90 days. Change it to a fixed range, likeSINCE 2026-11-27 UNTIL 2026-12-07, for a sale period.
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
- Free shipping. If a discount covered the shipping in full, Shopify reports the charge as 0. That's a real cost, and the report is doing its job.
- A second label. A reshipment or replacement has a label but no new charge.
- The order is older than your date range. It was placed before the start date and shipped after it, so only the label is inside the range. Start the range a week or two earlier.
A shipping charge with a label cost of 0
- The label wasn't bought in Shopify. Labels from a shipping app, your own carrier account or a 3PL aren't in Shopify's label reports at all.
- The label is too new or too late. It can take up to 24 hours for a label to appear, and a label bought after your end date falls outside the range.
- The label was voided. Voided labels are left out.
- It hasn't shipped. Unfulfilled orders, local delivery and pickup have no label.
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:
- Price adjustments. When a carrier finds a package heavier or bigger than the label said, it bills the difference later, sometimes weeks later. Shopify shows the adjustment in the order's timeline and charges or credits it on your next bill. Label reports leave adjustments out.
- Taxes on labels. In Canada and some US states and territories, label tax is added when you're billed, not when you buy, so it isn't in the label price.
- Return labels. They're left out of label reports.
- Currency. Canada Post labels are priced in CAD but billed in USD (or with a conversion fee if you're billed in CAD).
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:
| Cause | What 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 orders | Set 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 wrong | Weigh 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) rate | A 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 US | UPS 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 threshold | Compare 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
- Before the sale: run the losing orders report for the last 90 days. If the same products or zones keep showing up, fix their weights, packages or rates now, before the volume arrives.
- After the sale: on 8 December, run the order report with
SINCE 2026-11-27 UNTIL 2026-12-07. The extra week lets late labels arrive. Free shipping offers show up as orders with a charge of 0. - In January: check the December and January bills for adjustments on those orders.
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.