What Is the Refunded Products in Order Report?
The Refunded Products in Order report shows the products refunded within each Shopify order. It brings together the order number, refund date, customer, product, variant, SKU, refunded quantity, refund amount and any available refund note in one export.
Review refunded item lines for your selected period to see which products appear repeatedly and which refunds need a closer look. The order reference helps your team find the original transaction when investigating a customer query or preparing a supplier discussion.
A refund does not always mean an item was physically returned. Use this report to review refunded products; confirm return receipt, restocking and the reason for a refund separately when those details are needed.
Report Overview
- Report type
- Refund Reports, with refunded product lines linked to orders.
- Period
- Choose the review window and confirm that the date filter uses Refund Date.
- Data included
- Nine fields covering order references, item details, quantities, amounts and notes.
- Best for
- Reviewing refunds by product, variant or SKU and following up on individual orders.
- Export and delivery
- Excel, CSV or PDF, with daily, weekly or monthly email scheduling.
What Can You Learn from Refunded Product Lines?
1. Which SKUs appear repeatedly
Compare refunded quantities by SKU to identify items that deserve review. A high quantity is a prompt to investigate; sales volume is also needed to calculate a refund rate.
Example: For example, in a week, the same jacket SKU appears in several refunded orders.
What you can do: Review those orders and customer feedback before changing the product listing.
2. Which variants need closer attention
Variant details help you spot patterns that a product total can hide. They show which option was refunded, without proving why the customer requested it.
Example: For example, in an export, most refunded units of one shirt are size small.
What you can do: Check the size guide and fit feedback for that variant.
3. Which refunds account for larger amounts
Sort by Refund Amount to prioritize higher-value item refunds. Use a consistent amount definition when comparing products or periods.
Example: For example, in a month, a few furniture refunds account for the largest item amounts.
What you can do: Open the related orders and review the available refund notes with your team.
What Should You Check First in This Report?
Start with these checks before summarizing or sharing the export.
Refund date range. Confirm the date basis so older orders refunded this month are reviewed in the intended period.
Refunded quantity by SKU. Compare units rather than counting rows; one refunded line can contain more than one unit.
Refund amount definition. Check whether the amount is item-level and how taxes and discounts are handled before totaling it.
Order references and notes. Use them to investigate repeated entries or unclear refunds; do not remove rows solely because an order number repeats.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Reviewing weekly product refunds | Lists refunded SKUs and quantities for a consistent review period. |
| Investigating a variant pattern | Connects refunded sizes or colors to their products and orders. |
| Following up on a customer refund | Provides the order reference, customer name, date and available note. |
| Preparing a supplier discussion | Creates an item-level list to compare with separately verified defect or damage evidence. |
| Sharing a monthly refund export | Gives your team a repeatable list of refunded items and amounts to review. |
How to Create This Report in Data Export
Use the premade report as the starting point for your product refund export.
- Open Data Export and go to Prebuilt Reports.
- Open Refunded Products in Order and review the columns, especially Refund Amount and Refund Note.
- Choose your date range and confirm the date field. Apply an available product or SKU filter if you need a narrower view.
- Save the report and export it in Excel, CSV or PDF. Check a sample against the related Shopify order before using the totals.
- Optionally schedule daily, weekly or monthly email delivery to the people who review refunds.
Make the Most of This Report
Keep the export consistent and useful with these four checks.
01 / PERIOD
Compare like periods. Use the same refund date basis and similar time windows when comparing exports.
02 / COUNTING
Count refunded units. Sum Refunded Quantity instead of treating every row as one refunded unit.
03 / VISUAL REVIEW
Chart the right totals. In Excel or Google Sheets, group verified item refund amounts by SKU before creating a bar chart.
04 / SHARING
Share only needed fields. Remove Customer Name and private refund notes from exports sent outside your internal team.
Frequently Asked Questions
Does a refunded product mean the item was returned?
No. An item can be refunded without a physical return. This field list does not include return receipt or restocking status, so confirm those separately.
Can I calculate a product refund rate from this report alone?
No. Refunded quantities show the units refunded, but you also need the corresponding sales quantities and a consistent comparison basis to calculate a rate.
Does Refund Amount include tax and shipping?
Check the field definition and a sample order before treating it as a complete refund total or adding tax or shipping separately.
Will Refund Note explain every refund?
No. Notes may be blank or too general to identify a cause. Use available notes as investigation context and confirm details from the order or customer conversation.
Can I export and schedule this report?
You can export to Excel, CSV or PDF and schedule daily, weekly or monthly email delivery. Review the saved columns and date settings before scheduling it.