What Is the Shopify Product Return Rate Report?
Returns are unavoidable, but they are rarely spread evenly across a catalog. The Product Return Rate report isolates how often each item comes back by putting ordered quantity and returned quantity side by side and expressing the relationship as a single percentage. For the period you choose, every row shows what was ordered, what was returned, and the resulting Return %.
The report is keyed on Variant ID, so each row represents a specific variant rather than a whole product. That distinction matters: a product can look acceptable overall while one size or color is responsible for most of its returns. Net Quantity closes the loop by showing the units that stayed sold after returns were removed.
This report answers a different question than the Refund report. Refund reporting measures the money involved in returns. Product Return Rate measures the frequency of returns per item, which is what you need when deciding which products to fix, re-photograph, resize, or reconsider stocking.
Which Fields Are Included in the Product Return Rate Report?
These fields let you measure return frequency at the item level and separate genuine problem products from ordinary return activity.
You can customize the pre-made report by adding, removing, or rearranging fields, or by filtering to a single product, variant, or period so the return picture matches how you review your store.
Important Insights You Can Find in This Report
Which variant is driving a product's returns that the product-level view hides?
Because each row is tied to a Variant ID, you can compare Return % across the variants of the same Product Name. A jacket may sit at an unremarkable overall rate while a single size returns far more often than the rest. Grouping by Product Name and reading Return % variant by variant tells you whether the fix is the whole product or one specific option, which changes whether you edit the size chart, swap a supplier, or leave the item alone.
How much real demand is left after returns?
Ordered Quantity is the headline, but Net Quantity is what you actually kept. An item with strong ordered volume and a high Return % may retain far fewer net units than a quieter item with almost no returns. Reading Net Quantity next to Ordered Quantity keeps reorder decisions honest, since reordering to the sold figure can overstock a variant that a large share of buyers send back.
Which items are outliers against the rest of your catalog?
Sorting the report by Return % surfaces the items sitting well above the pattern set by everything else you sell. Rather than judging a number in isolation, compare each item's Return % against the spread across the report. The rows that stand apart from your own typical range are the ones worth investigating first.
THE ANALYST'S READ: The Signal Most Merchants Miss
A high Return % is not automatically a high-priority problem. The percentage is only as reliable as the Ordered Quantity behind it. A variant with two orders and one return shows 50 percent, but that number is noise. The row that deserves attention is the one with a substantial Ordered Quantity and an elevated Return %, because that combination means a large absolute number of returned units and a real dent in Net Quantity. Sort by Return % to find candidates, then read Ordered Quantity and Returned Quantity on the same row before acting. The items quietly costing you the most are often mid-table on percentage but high on volume, not the eye-catching small-sample rows at the top.
How Can You Automate the Product Return Rate Report?
Open the pre-made Product Return Rate report in Report Pundit and press Save. The columns are already configured. To build your own version, go to Custom Reports, add the fields listed above, set your date range, and apply a filter if you want to focus on one product or category.
Once saved, schedule it to email automatically on a daily, weekly, or monthly cadence so it is never rebuilt by hand, and route the same delivery to a colleague or supplier review. You can export it as Excel, CSV, or PDF, or push it to Google Sheets or Google Drive for deeper analysis.
Frequently Asked Questions
How is Return % calculated in this report?
Return % is Returned Quantity divided by Ordered Quantity for the same variant and period, shown as a percentage. It measures how often an item comes back, not the money refunded.
Does the report measure returns per product or per variant?
Per variant. Each row is tied to a Variant ID, so returns are visible at the size, color, or option level. The Product Name field lets you roll those variants back up to the parent product when you want the combined view.
What does Net Quantity tell me that Ordered Quantity does not?
Net Quantity is ordered units minus returned units, so it shows the demand that actually stuck. It is the more accurate figure to reorder against, since Ordered Quantity alone counts units that customers later sent back.
How is this different from the Refund report?
Product Return Rate measures return frequency per item as a percentage. The Refund report measures the financial side of returns, including net, shipping, and tax amounts returned. Use this report to decide which products to fix, and the Refund report to quantify what returns cost.
Can I schedule or export the Product Return Rate report?
Yes. Save it, then schedule automatic delivery by email on a daily, weekly, or monthly basis, or export it to Excel, CSV, or PDF, and send it to Google Sheets or Google Drive.