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.
| Vendor | Orders | Net quantity | Gross sales | Discounts | Returns | Net sales |
|---|---|---|---|---|---|---|
| Summit Supply Co | 1,412 | 1,604 | $208,520 | -$15,639 | -$11,470 | $181,411 |
| Northwind Knits | 2,230 | 4,118 | $115,304 | -$8,648 | -$2,306 | $104,350 |
| Ridgeline Outdoor | 388 | 412 | $98,880 | -$6,120 | -$7,200 | $85,560 |
| Basecamp Goods | 702 | 736 | $66,240 | -$3,975 | -$2,880 | $59,385 |
| Hydro Steel | 1,910 | 2,118 | $52,950 | -$2,640 | -$750 | $49,560 |
| Total | 8,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.
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?
Gross margin by product
Which products make money after the cost of goods, and which only look like they do?
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.