What is Shopify refund rate?

How to calculate it by product, what healthy looks like, and how to track it over time

Definition

What it is

Shopify refund rate is the percentage of orders (or revenue) that results in a full or partial refund within a given time period. It is a key operational metric for eCommerce stores — a rising refund rate can signal product quality issues, fulfilment errors, misleading product descriptions, or customer service problems. Unlike Amazon, Shopify does not display refund rate per product by default; it requires querying the orders and refunds data directly.

Formula

Refund Rate Formula

Formula

Refund Rate (%) = (Refunded Orders ÷ Total Orders) × 100

You can also calculate by revenue: (Refunded Revenue ÷ Gross Revenue) × 100. Calculate at the product or variant level by joining the refund line items table to the order line items table on product_id. A spike in refund rate on a specific product — even if overall refund rate looks healthy — is a signal the aggregate view will miss.

Business impact

Why it matters

Refund rate directly erodes net revenue and contribution margin. A product with $20,000 monthly revenue and a 12% refund rate loses $2,400 to refunds — money that was already counted in gross revenue, triggered shipping costs, and may have generated ad spend to acquire the customer. Tracking refund rate by product over time is the earliest warning system for quality or listing issues, often surfacing problems before customer reviews do.

The challenge

How most teams track this today

Shopify Analytics shows total refunds in the Finances summary but does not break refund rate down by product. To get per-product refund rate you need to join the Orders, Refunds, and Refund Line Items tables — which requires either a BI tool or an export to a spreadsheet followed by a VLOOKUP.

Run it on your data

Calculate this automatically with Taptic Data

Connect your Shopify account and Taptic generates this calculation from plain English against your actual data — no Excel exports, no manual joins. The SQL runs against your real schema, your real tables, your real numbers.

SQL query for Shopify refund rate by product →Connect Shopify →Try Free — $29.99/mo

FAQ

Common questions

What is a good refund rate for a Shopify store?

Industry averages vary by category. Apparel: 20–30% is common. Electronics: 10–15%. Home goods: 5–8%. Consumables and food: below 2%. As a baseline, a refund rate above 10% in any non-apparel category is worth investigating at the product level.

How is a Shopify refund different from a return?

In Shopify, a return refers to the physical item being sent back by the customer. A refund is the financial transaction — the money being returned to the customer. A refund can be issued without a return (goodwill refund, partial refund), and a return can be processed without a full refund. The Shopify refunds API tracks the financial side; the returns API tracks the physical item.

Can I see which products have the highest refund rate in Taptic?

Yes. Taptic imports the orders, refunds, refund line items, and order line items tables from Shopify. The refund rate by product query joins these tables, groups by product title, and calculates refunded units ÷ sold units for any date range. You can rank products by refund rate descending to immediately see your highest-risk items.

Does Shopify track partial refunds separately?

Yes. The Shopify refunds table includes a "kind" field that distinguishes full refunds from partial refunds. The refund line items table records the specific line items and quantities refunded. Taptic imports both, so you can query partial vs full refund rates separately if needed.

Analytics hub

All Shopify queries, use cases, and SQL examples in one place.

Shopify Analytics hub — queries, use cases, and SQL examples →

Stop calculating this in spreadsheets

Connect Shopify to Taptic Data and run this calculation automatically from plain English — against your real data, on a schedule, delivered to your team.

Start Free — $29.99/mo Try the Live Demo