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.
| Product | Variant | Net sales | Total COGS (approx.) | Gross margin (approx.) | Gross margin % (approx.) |
|---|---|---|---|---|---|
| Trail Runner 2 | Black, 10 | $38,220.00 | $14,432.00 | $23,788.00 | 62.2% |
| Alpine Shell Jacket | Navy, M | $31,680.00 | $11,682.00 | $19,998.00 | 63.1% |
| Merino Crew Sock 3-pack | L | $27,440.00 | $9,212.00 | $18,228.00 | 66.4% |
| Daypack 22L | Green | $17,820.00 | $5,385.60 | $12,434.40 | 69.8% |
| Insulated Bottle 750ml | Steel | $9,975.00 | $0.00 | $9,975.00 | 100.0% |
| Trail Runner 2 | Black, 11 | $9,360.00 | $2,952.00 | $6,408.00 | 68.5% |
| Total | $134,495.00 | $43,663.60 | $90,831.40 | 67.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.
More reports
Sales by product
What did each product actually earn after discounts and refunds?
Inventory value
What is the stock we hold worth right now, at cost and at retail?
Sales by vendor
Which vendors' products earned the most after discounts and refunds?
Inventory by location
How many units of each SKU sit at each location, and how many are already spoken for?
Inventory on a date
What did we hold, where, and what was it worth, on any past day?
Monthly tax summary
How much tax was recorded on last month's orders, and where?
Custom reporting
Your reports, your shape, on schedule. Or our team builds them for you.