Shopify sales by vendor report

Which vendors' products earned the most after discounts and refunds?

Install on Shopify

14-day free trial.

The numbers you want before the vendor meeting

One vendor, every product

Filter to a single vendor and group by product or SKU to see what in their range sold and what came back.

Months across the top

Pivot by month, quarter or channel and a vendor's trend sits in one table instead of six exports.

Sent before the meeting

Schedule it for the first of the month as Excel, filtered to last month, to the buyer who negotiates. The prep is done.

Or we build the version you need

Return rate per vendor, or margin beside sales? Describe it in the app and our team builds it. How it works.

What it looks like

One row per vendor, every product they supply rolled up: the orders and units, gross sales, then the discounts and refunds that came off, then net sales. Sorted by net sales, so the vendor that carried the month is at the top and the one with the heavy returns column is easy to find.

Sample output, September 2026The built-in "Sales by vendor" report. Made-up store, made-up numbers.
VendorOrdersNet quantityGross salesDiscountsReturnsNet sales
Summit Supply Co1,4121,604$208,520-$15,639-$11,470$181,411
Northwind Knits2,2304,118$115,304-$8,648-$2,306$104,350
Ridgeline Outdoor388412$98,880-$6,120-$7,200$85,560
Basecamp Goods702736$66,240-$3,975-$2,880$59,385
Hydro Steel1,9102,118$52,950-$2,640-$750$49,560
Total8,988$541,894-$37,022-$24,606$480,266

What each number means

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

Vendor
The vendor on the product in Shopify. Only product lines count; shipping, tips and fees have no vendor and stay out.
Orders
Distinct orders with a sale or refund of that vendor's products in the period. One order can hold two vendors, so the total row leaves this blank rather than double count.
Net quantity
Units sold minus units refunded.
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, usually a negative amount. A refund gives the discount back, so a period with mostly refunds can show a positive figure.
Returns
Returned product value before discounts and tax, as a negative amount, dated to the day of the refund.
Net sales
Gross sales minus discounts and returns. No tax, shipping, duties or payment fees.

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