Shopify gross margin by product report

Which products make money after the cost of goods, and which only look like they do?

Install on Shopify

14-day free trial.

The products that earn, and the ones that only sell

Margin next to sales, not in another tab

Net sales, cost of goods and margin in one row per product and variant. Sort by margin and the quiet earners rise above the loud sellers.

Sliced the way you buy

Group by vendor, product type or month. Pivot months across the top and watch a margin drift as costs change.

On the desk every Monday

Schedule it for last week or last month as CSV, Excel or PDF, to whoever sets prices. Nobody rebuilds the spreadsheet again.

Or we build the version you need

Margin after shipping and payment fees, or landed cost from a metafield? Describe it in the app and our team builds it. How it works.

What it looks like

One row per product and variant: net sales after discounts and refunds, the cost of the units sold, and what was left, as money and as a share of net sales. Sorted by net sales, so the biggest sellers sit at the top and a thin margin on one of them is hard to miss. This version shows the margin column as a percentage. The bottle has no cost in Shopify, so it shows $0.00 cost and a 100% margin. That's the row to fix first.

Sample output, September 2026The built-in "Gross margin by product" report. Made-up store, made-up numbers.
ProductVariantNet salesTotal COGS (approx.)Gross margin (approx.)Gross margin % (approx.)
Trail Runner 2Black, 10$38,220.00$14,432.00$23,788.0062.2%
Alpine Shell JacketNavy, M$31,680.00$11,682.00$19,998.0063.1%
Merino Crew Sock 3-packL$27,440.00$9,212.00$18,228.0066.4%
Daypack 22LGreen$17,820.00$5,385.60$12,434.4069.8%
Insulated Bottle 750mlSteel$9,975.00$0.00$9,975.00100.0%
Trail Runner 2Black, 11$9,360.00$2,952.00$6,408.0068.5%
Total$134,495.00$43,663.60$90,831.4067.5%

What each number means

So the figure means the same thing to everyone who reads it.

Net sales
Product revenue after discounts and refunds. Order adjustments on their own lines stay out. No tax, shipping, duties or payment fees. A refund is dated to the day it happened.
Total COGS (approx.)
Units sold times the variant's "Cost per item" in Shopify. The cost is the one on the variant today, so if you changed a cost last month, last month's sales use the new figure. That is why the column says approx.
Gross margin (approx.)
Net sales minus total COGS, in money.
Gross margin % (approx.)
Gross margin divided by net sales. Zero net sales gives a blank, never an error.
Missing costs
A variant with no cost in Shopify counts as $0.00, so it shows a 100% margin and lifts the total. A 100% row almost always means a missing cost. Fill it in and the row corrects itself.
One order, by hand
The free profit margin calculator runs the same sum for a single item, with shipping and the payment fee taken off as well.

Already have Shopify's reports?

Shopify's own reports can be edited, saved and exported to a spreadsheet (Shopify Help). That covers a one-off. ReportNerds keeps the exact version your team needs, sends it on a schedule, and our nerds build the ones you would rather not.

Want this report for your store?

Install ReportNerds and run it on your own orders, or tell us the version you need and our nerds build it. 14-day free trial.

Install on Shopify