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

​
At a glance

The top-N most-refunded products by refund value (or refund count) over the period. The card refund-investigation always lands on. Refund value clusters disproportionately on a tiny minority of SKUs: typically 5-10 SKUs explain 30-50% of total refund value on most stores. Identifying these and acting on them (relisting with better images, fixing size charts, pulling defect batches, hiding offending SKUs) is the highest-leverage refund reduction lever available. On BigCommerce specifically, refund-without-return cases (Amazon A-to-Z claims, “keep it” goodwill) means this card may show items that never came back to the warehouse, which differs from the BC Return Status view of physically-received returns.

​
Calculation

Calculated automatically from your BigCommerce 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 US apparel brand on BigCommerce, 90-day window 14 Feb 26 to 14 May 26. Total refund value across the period: $58,200 from 1,840 refund events. What’s interesting:
  1. Top 10 SKUs = 63% of refund value (from 28% of gross sales). Refund value is wildly concentrated; finding and fixing the top three closes 30%+ of total refund value.
  2. The Linen shirt (M) at 13.8% refund rate is the clear quality issue. Almost twice the rate of the next-worst SKU. Investigate: is it a fit issue (sizing chart wrong), a fabric issue (shrinkage in wash), an expectation issue (description / images don’t match reality)? Pull customer refund reasons for this SKU specifically; usually 3-5 distinct reasons explain 80% of refunds.
  3. Slim-fit chinos in 4 sizes all appear in top 10 (sizes 30, 32, 34, 36). This is a classic “size-fit issue across the range” pattern: customers don’t know their size in this fit, order multiple sizes, return all but one. Either improve the size guide, offer a try-before-you-buy option, or accept the structural higher refund rate as the cost of doing fit-sensitive apparel.
  4. Wool overcoat appears at #3 by value but only 4.4% refund rate. This is “high-AOV product with normal refund rate”; the refund value is high because the AOV is high, not because the SKU has issues. Don’t optimise this SKU for lower refund rate; it’s already healthy.
  5. The 220 long-tail SKUs at 1.7% blended refund rate are healthy. Most stores’ “average” SKU runs 1-3% refund rate; the top-10 outliers are where attention belongs.
Action playbook this card surfaces:
  1. Investigate the Linen shirt (M) immediately. 13.8% refund rate on a high-volume SKU is the highest-leverage fix in the catalog. £5,800 of refund value over 90 days = £23,200/year on that single SKU.
  2. Address the chino sizing issue systemically. Better size guide with body measurements, “try multiple sizes” promo (free returns), or accept 7-9% as the structural rate.
  3. Audit refund reasons for top-3 SKUs. Free-text reasons from BC’s refund flow typically cluster into 3-5 categories per SKU; this is the diagnostic input.
  4. Consider relisting with better images. Apparel refund rates drop 2-4pp after image quality upgrades (multiple angles, model wearing, scale references).
  5. Watch for new SKUs entering the top 10. A new SKU appearing in the top-5 within 30 days of launch is the early-defect signal; pull it from active inventory pending investigation.
  6. Pair with BC Top Products to find SKUs that are top-revenue and top-refunded simultaneously; these are the highest-leverage targets.

​
Sibling cards merchants should reference together

​
Reconciling against the vendor’s own dashboard

Where to look in BigCommerce’s own dashboard: The closest native view is BC Control Panel → Analytics → Insights → Refunds → By Product (Plus and Enterprise tiers). For Standard tier, use the Orders export filtered to refunded orders and pivot on product_id in spreadsheet. For per-channel breakdowns: Channel Manager → (channel) → Returns / Refunds reports. Amazon Channel Manager surfaces marketplace refunds separately. Why our number may legitimately differ from the vendor’s: Cross-connector reconciliation (when both connectors are connected for this merchant):

​
Known limitations / merchant FAQs

Should I rank by absolute value or by rate? Both, for different decisions. Absolute value finds where most refund dollars are. Rate finds where the worst quality issues are. A high-value, low-rate SKU is fine (just sells a lot); a low-value, high-rate SKU has a quality issue regardless of dollar impact. My #1 SKU is also my #1 best-seller, is that a problem? Not necessarily. Refund value scales with sales volume; if your top product is 18% of revenue and 18% of refunds, that’s just normal proportionality. The diagnostic is rate: if refund rate matches the store average, it’s structurally fine; if rate exceeds store average significantly, there’s a quality issue. Why is one of my SKUs at 25% refund rate? That’s outrageous. Apparel SKUs frequently hit 20-30% refund rates due to size-fit issues; this is normal for that category. For non-apparel categories, 25% is concerning and warrants immediate investigation. Pull customer refund reasons; common high-rate causes are sizing (apparel), defects (electronics), color mismatch (home goods), expectation mismatch (anything). My Amazon channel has different top-refunded products than web, why? Channel-specific listing strategies, different customer expectations, and Amazon’s A-to-Z claim system all contribute. Filter by channel for accurate diagnostics. Amazon refunds without returns are common; they inflate value here without reflecting physical quality issues. Should I delist a high-refund-rate SKU? If rate is >30% and the SKU has been live for 30+ days, yes (or pull pending investigation). The customer-experience damage and CS workload usually exceed any margin contribution. Better to delist than to keep selling something that consistently disappoints customers. My linen shirt has high refunds, but customers love it. What’s happening? Customers love it once it fits. The refund issue is fit, not quality. Solutions: (1) better size guide with body-measurement chart, (2) customer reviews exposing fit feedback, (3) “true to size / runs small / runs large” tag on product page, (4) free exchanges instead of returns (lifts repeat-purchase 8-12%). How does this differ from BC’s Reports → Refunds report? BC’s report is order-level; this card is product-level. BC’s report sums refund value by date; this card sums by SKU. Different cuts of the same data. Why are my variants showing as the parent product? Default rollup. Toggle “show variants separately” to see SKU-level granularity. For sizing issues (chinos, t-shirts), variant-level view is essential. Can I see refund reasons per top SKU? Yes via Ask Viq: “show refund reasons for product CHN-32-NVY”. Returns the free-text reason field grouped and counted. Most SKUs have 3-5 dominant reasons explaining 80% of refunds. My #1 refunded SKU is a digital download, can that even be refunded? Yes if you allow it. Digital refunds typically arise from: (1) customer accidentally bought wrong file, (2) compatibility issues, (3) goodwill returns. Set a clearer “no refund on digital downloads” policy if these are unwanted; most stores see digital refunds drop 70-80% with policy clarity. Should I treat refund-without-return as fraud? Some are; most aren’t. Genuine causes include: damaged-in-transit (“keep it” goodwill), Amazon A-to-Z, low-value items not worth shipping back. Investigate refund-without-return clusters by customer to identify potential fraud (one customer with many such refunds). My B2B Edition wholesale SKU is at the top of the list, what should I do? Filter to DTC. B2B refunds are large and rare; mixing them with DTC distorts the consumer-product diagnostics. B2B refunds need a different investigation approach (relationship issue with the buyer, contract dispute, quality complaint at scale). Can I track the same product over multiple periods? Yes via Ask Viq: “show refund value for product CHN-32-NVY over last 6 months by month”. Trend monitoring identifies whether the refund issue is acute or chronic. My top refunded SKU is one I haven’t sold in 6 months, why? Refund timing lag. Refunds can be issued months after the original sale (sometimes years for warranty replacements). The card shows the refund timing, not the original sale timing. Use Ask Viq for original-sale-date breakdown if needed.

​
Tracked live in Vortex IQ Nerve Centre

Top Refunding Customers is one of hundreds of KPI pulses Vortex IQ tracks across BigCommerce 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.