Shopify sales by product report

What did each product actually earn after discounts and refunds?

Install on Shopify

14-day free trial.

Make it the report your team actually wants

Break it down your way

SKU and week in one table. Channels pivoted across the top. A calculated column for return rate. One filter for the vendor meeting.

In the inbox every Monday

Schedule it as CSV, Excel or PDF to the people who need it, filtered to last week, and nobody exports it by hand again.

Or we build the version you need

Describe it in the app. Our team builds it and emails you when it is ready, soon after. How it works.

What it looks like

One row per product, variants and SKUs rolled up: gross sales, then the discounts and refunds that came off, then what was left. Sorted by net sales, so the products that carried the month sit at the top and the revenue lost to returns is easy to spot.

Sample output, September 2026The built-in "Sales by product" report. Made-up store, made-up numbers.
ProductNet quantityGross salesDiscountsReturnsNet sales
Trail Runner 21,284$166,920-$12,418-$9,360$145,142
Merino Crew Sock, 3-pack3,910$109,480-$8,205-$1,960$99,315
Alpine Shell Jacket412$98,880-$6,120-$7,200$85,560
Daypack 22L736$66,240-$3,975-$2,880$59,385
Insulated Bottle 750ml2,118$52,950-$2,640-$750$49,560
Total8,460$494,470-$33,358-$22,150$438,962

What each number means

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

Gross sales
Price times quantity on each sold line, before discounts, taxes and shipping.
Discounts
Line discounts plus each line's share of order-level discounts, as a signed amount. Discounts reduce sales; discount reversals on refunds add back to this column.
Returns
Returned product value before discounts and tax, as a negative amount. A refund counts whether or not the goods came back.
Net sales
Product revenue after discounts, refunds and order adjustments. No tax, shipping, duties or payment fees, so this is what the products earned.
Net quantity
Units sold minus units refunded in the period.
Dates
Every sale and every refund is dated to the day it happened. A September refund of an August order lands in September.

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