Shopify Refunded Quantity Analytics

Refunded Quantity measures units associated with Shopify refund activity. It helps identify products and variants where the number of refunded units is meaningful even when the refund amount is small.

How Shopify Refunded Quantity is calculated

Refunded Quantity = the number of units attached to Shopify refund activity

It counts units, not orders and not return requests. One refunded order can contribute several units, and a return request that has not been refunded yet does not contribute at all.

Why count refunded units, not just refunded money

Refund amounts are dominated by price. A single expensive item can outweigh dozens of cheap ones, so a money-based view keeps pointing you at your premium products whether or not anything is wrong with them.

Counting units strips price out. That is what surfaces the low-priced product quietly going out and coming back over and over, costing you picking, packing, return shipping, and restocking time on every trip, while barely registering on a refund-amount report.

Refunded Quantity is the metric to use when you want to know:

• Which products and variants generate the most physical handling work after the sale
• How many units of a size or color you are really selling, once refunds are removed
• Whether a refund problem is broad across many units or concentrated in a few big-ticket orders
• How much of your stock is cycling out and back rather than staying sold

Read it beside Gross Quantity Sold and Net Quantity Sold. The three together show units ordered, units refunded, and units kept, which is the sequence you need before committing to a reorder.

Refunded Quantity and other return metrics

These metrics describe different events:

A refund can exist without a physical return, and a return request can exist before a refund. Do not use Refunded Quantity as a substitute for Return Quantity when you are analyzing the return-management workflow.

Add Refunded Quantity to a Shopify data worksheet

1. Open a supported Product, Product Variant, Collection, Company, or Company Location worksheet

2. Click ＋ Shopify data in the header row of an empty column, or choose Column > Add Shopify data… from the menu bar. The field picker opens

3. Click Sales & analytics in the list of sections on the left, or type the metric's name in the search box

   

4. Click Refunded Quantity. The metric's settings open with it already chosen under Which metric?

5. Under Over what time period?, choose All time, Fixed dates, Rolling period, Calendar year, or Calendar month

6. Under Limit which orders count, add any optional filters supported by the metric

7. Click Save Column

Add Gross Quantity Sold and Net Quantity Sold with the same dates and filters.

Compare refunded quantities with a Pivot Table worksheet

The Pivot Table worksheet builder includes Refunded Quantity in the Quantity metric group.

1. Click the + button beside the worksheet tabs, select Reporting worksheet, then click Continue
2. Choose a ready-made report under Pivot table, or choose Blank pivot table, then click Continue
3. Under Break down by, choose vendor, product type, product category, product tag, Market, or customer segment
4. Under Metrics, add Gross Quantity Sold, Refunded Quantity, and Net Quantity Sold
5. Under Time period, choose the period
6. Click Create Worksheet

This layout reveals whether refunded units are concentrated with a supplier, merchandise group, campaign tag, Market, or customer audience.

Collections are not a Pivot Table breakdown. To compare them, add Refunded Quantity analytics columns to a Collections worksheet, as described in Shopify Collection Analytics.

Calculate a refunded-unit rate

Add a formula column such as:

Refunded Quantity / Gross Quantity Sold

Format the result as a percentage: click a cell in the formula column, then choose Column > Number format > Percent from the menu bar. This creates a unit-based ratio that is different from Percent of Orders Refunded, which uses orders rather than units.

Keep both the rate and the counts visible. A high rate on a small number of units is less conclusive than the same rate across large volume.

Use the Product Returns template

The Product Returns template creates one row per Shopify product with:

• Gross Quantity Ordered
• Returned Quantity, using the Refunded Quantity metric
• Return Rate, using Percent of Orders Refunded

The template’s historical labels use return language, but the underlying quantity and rate follow Shopify refund activity. Use Shopify Return Request Analytics when you need return-request status, reasons, open requests, or closure time.

Investigate the products behind the number

After finding a high Refunded Quantity:

• Compare the rate against Gross Quantity Sold
• Check whether one variant drives the product total
• Review Total Refund Amount to understand financial impact
• Compare earlier and recent timeframes
• Review return reasons where Shopify return data exists
• Check product descriptions, size information, images, packaging, and supplier quality

Quantity analytics finds where to look. Raw refund and return-line-item worksheets provide the individual records needed for detailed investigation.