Orders3 min read

Shopify Refunded Products Report: See Which Items Come Back

Which Shopify reports show refunded and returned products, how to filter them per product, a ShopifyQL query for returns, and when an order export works better.

In this guide
  1. Option 1: Total sales by product, filtered to reversals
  2. Option 2: Orders and reversals by product
  3. Option 3: Returned items with ShopifyQL
  4. When an order export works better
  5. Reading the numbers
  6. FAQ
  7. Try Columna: Order Export & Sheets

To see which products were refunded in Shopify, open Analytics > Reports, choose Total sales by product and add the filter Is reversed = Yes. For quantities ordered against quantities reversed per product, use the Orders and reversals by product report. For returned items only, query the returns data with ShopifyQL. This guide shows each option and when an order export answers the question better.

Refunds by product tell you more than refunds in total. One product with a high refund rate usually means a wrong size chart, a misleading photo, a quality problem or damage in transit, and each of those is cheaper to fix than to keep refunding.

Option 1: Total sales by product, filtered to reversals

The sales reports can be narrowed to reversals:

  1. Go to Analytics > Reports and open Total sales by product.
  2. Set the date range you want to review.
  3. Add the filter Is reversed and set it to Yes.
  4. Remove the Net sales and Discounts columns so only the reversed amounts remain.

The result lists each product with the value that was reversed in the period. “Reversed” is wider than “refunded”: it also covers returns, cancellations and order edits that removed items, so read it as “money that came back off this product”.

Option 2: Orders and reversals by product

The order reports include Orders and reversals by product, with Ordered quantity, Reversed quantity and Reversed quantity rate per product. The rate is the column to sort by: a product with 4 reversals out of 10 orders needs attention sooner than one with 20 out of 2,000.

Option 3: Returned items with ShopifyQL

If you only want items that physically came back, the returns dataset has a returned quantity metric, the product title at the time of sale and the return reason. A query along these lines, run in the report editor, groups returned units by product for the last 30 days:

FROM returns
  SHOW returned_quantity
  GROUP BY product_title_at_time_of_sale
  SINCE -30d

Add the return reason to the grouping to see why each product came back. Shopify renames ShopifyQL fields from time to time, so if a field is rejected, check the dataset reference for its current name.

When an order export works better

Reports answer “how much, per product”. They are less handy when you need the detail behind each refund: the order number, the customer, the date of the refund, the line items, the shipping refunded and any note. That is what you need to:

  • send a monthly list of refunds to your accountant,
  • check a supplier’s damaged-goods claim item by item,
  • or look for patterns, such as the same customer refunding repeatedly.

For that, export the orders with their refunds. Shopify’s own order export includes refunded amounts per order; our guide to exporting orders from Shopify admin (exportar pedidos de Shopify) walks through it. If you need one row per refunded line item, the refund date or a file delivered every month, an export app does it without a spreadsheet clean-up. For refunds across several stores, see refund and order reports across Shopify stores.

If your accountant wants a document for each refund, a credit note with its own number, rather than a list, an order printer app for Shopify prints one from the refund.

Reading the numbers

  • Compare rates, not counts. Best-sellers always have the most refunds.
  • Separate refunds from cancellations. A cancelled order before shipping is a different problem from a return after delivery.
  • Look at the reason. “Too small” points to the size chart; “damaged” points to packaging or the carrier.
  • Check partial refunds. A refund for a missing item or a price adjustment shows up as a reversal without a return. See partial refunds and restocking.

FAQ

Is there a Shopify report of refunds per product?

Yes. Use Total sales by product with the filter Is reversed = Yes, or Orders and reversals by product for reversed quantities and rates.

Why does the report show more than my refunds?

Reversals include returns, cancellations and order edits that removed items, not only refunds.

Can I export the refunded products list?

Yes. Reports can be exported to CSV from the report page. For the order-level detail behind each refund, export the orders instead.

Try Columna: Order Export & Sheets

Columna: Order Export & Sheets exports Shopify orders with the columns you choose, including refunded quantity and amount per line item, refund dates and refund notes, to CSV, Excel or Google Sheets. See the app’s page for every column.

Try Columna: Order Export & Sheets on the Shopify App Store and keep a monthly refunds file without clean-up.