Skip to main content
Metrics type: Supporting Metrics • Category: Ecommerce Platform

​
At a glance

Top customers ranked by total refund value over the 90-day window. Surfaces the chronic-refunder tier, fraud risk, and customers whose net economic value to the business may be negative.

​
Calculation

Calculated automatically from your Shopify data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.

​
Worked example

A UK womenswear DTC brand on Shopify Plus. 90D window 12 Feb 26 to 12 May 26. Six things to notice:
  1. Customer C is a fraud signal. £1,180 refund on £1,290 spend = 91% refund rate. This is either chronic try-and-return (intentional zero-cost wardrobing) or outright fraud (returning empty boxes, returning different items). Investigate the support history.
  2. Customer A is high-risk-but-legitimate. 73% refund rate is excessive but consistent with apparel-shopping behaviour. Some customers buy 4 sizes intending to return 3. Operationally costly for the brand (return-shipping + restock time + write-offs from damage); flag for “single-size order” policy or requested-size confirmation.
  3. Customer D is normal. 27% refund rate at £3,640 spend = a regular shopper who refunds occasionally. Healthy customer; the refunds are part of the service experience.
  4. Top-25 = 22% of refund value. Power-law concentration. The top-5 do most of the damage; addressing them addresses most of the cost.
  5. The list reveals systematic issues. If 8 of top-25 have similar refund-reason patterns (“size too small”, “fit too tight”), the brand has a sizing problem on a specific product family, not a customer problem.
  6. POS in-store returns may be missing. If a customer brings 3 dresses to the London showroom for in-store returns, those don’t always create native Refund records (depends on POS-API config). The list under-counts hybrid-channel refunders.

​
Sibling cards merchants should reference together

Top Refunders is the chronic-refunder list. Companions:

​
Reconciling against the vendor’s own dashboard

Where to look in Shopify Admin: Shopify doesn’t expose a top-refunder ranking directly. Reconstruct from:
  • Customers → Filter by number of refunds or refund total: not directly available; use Shopify customer-segment builder with custom criteria.
  • Reports → Returns: aggregate; doesn’t rank by customer.
  • Apps like Loop Returns / Returnly / AfterShip Returns: their dashboards expose chronic-refunder rankings.
Why our number may legitimately differ: Cross-connector reconciliation:

​
Known limitations / merchant FAQs

How do I tell the difference between “fraud” and “fashion”? Fraud signatures:
  • Refund rate >85%: nearly every order returned. Legitimate customers don’t behave this way.
  • High-velocity short-window orders: 5-10 orders in 2 weeks then bulk return.
  • Multiple addresses or payment cards: same customer using different details to avoid detection.
  • Returned-empty-box pattern: if your warehouse flags items “received but missing”, that’s deliberate fraud.
Fashion signatures (legitimate but expensive):
  • Refund rate 30-60%: chronic try-and-return; common in apparel.
  • Single-customer cluster: same shipping address, same name, normal payment patterns.
  • Multi-size orders: customer ordered 3 sizes intending to return 2.
For fraud, blacklist; for fashion, communicate (size-guide push, “single size only” policy, restocking fee for >X% return rate). My #1 refunder is a VIP. What do I do? Conflict resolution. The customer spends £3,000+ but returns £2,000. Net: £1,000 contribution but operationally costly. Three approaches:
  1. Maintain the relationship if margin on the £1,000 net is acceptable.
  2. Restocking fee policy for orders with >X% return rate; signals the cost.
  3. Direct conversation via account manager: “we love your business, but we need to align on returns expectations.”
VIPs are sensitive; handle with care. Should I blacklist top refunders? Conservatively. Blacklisting risks customer-relations PR (a wronged customer goes public). Only blacklist on clear evidence of fraud (empty-box, address mismatch, payment-card fraud-flag). For fashion-pattern refunders, prefer policy adjustment (restocking fee, single-size policy) over blanket bans. My subscription store, do recurring refunds count? Yes. Each subscription billing’s refund creates a refund record; a customer who refunds 3 monthly billings appears with 3 refund records summed. Why are some customers anonymous? Guest-checkout customers without account creation may show as “Anonymous” or with email-only identifiers. The refund record exists but customer-resolution is incomplete. POS walk-ins are similarly anonymous. Action playbook for using Top Refunders:
  1. Weekly review: scan top-10 for new entrants. Compare to last week’s top-10; new arrivals deserve immediate attention.
  2. Investigate top-3: pull their order history, refund reasons, and customer-service interactions. Identify pattern.
  3. For fraud-signature: blacklist via Shopify customer-tagging or block-list, escalate to fraud team if multiple cards involved.
  4. For fashion-signature: implement policy (restocking fee on >X% return-rate, single-size order suggestion) or proactive communication.
  5. For VIP-conflict: route to account-management; the spend often justifies the cost, but the conversation matters.
  6. Quarterly category audit: if top-10 reveals systematic issue (sizing on a specific product family), fix the product / merchandising rather than the customer.

​
Tracked live in Vortex IQ Nerve Centre

Top Refunding Customers is one of hundreds of KPI pulses Vortex IQ tracks across Shopify and 70+ other ecommerce connectors. Nerve Centre runs the detection layer; Vortex Mind investigates the cause when something moves; Ask Viq lets you interrogate any number in plain English. Start for free or book a demo to see this metric running on your own data.