Skip to main content
Metrics type: Supporting MetricsCategory: Ecommerce Platform

At a glance

The top SKUs by refund volume over the last 90 days, ranked by either count of refunded units or refunded dollar value. The single highest-leverage merchandising signal on a BigCommerce store, the SKUs that customers are returning are telling you exactly which products have a quality, sizing, description, or expectation problem.

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 fashion brand on BigCommerce Pro, 90-day window 14 Feb 26 to 14 May 26. What’s interesting:
  1. The linen midi dress at 43.2% refund rate is a five-alarm event. Four out of every ten units shipped come back. The unit-count ranking puts it at #1 with 178 refund units, the dollar-value view at $9,790 makes it the single most expensive SKU in the catalogue. This SKU should be paused immediately, returned-units inspected, and the product page reviewed.
  2. Sizing is the dominant root cause for fashion. Look at refund reasons in the Order tab: if “didn’t fit” or “too small” / “too large” make up >60% of the reasons, the size chart is wrong. Re-shoot the model with explicit measurements; add a “fits true to size” or “runs small” note. Brands that update their size chart typically see refund rates fall by 10-15 percentage points within 30 days.
  3. The leather tote at 26% refund rate is a different pattern: refund reasons probably cluster around “quality not as expected” or “different colour”. This is a photography or description failure, not a sizing one. Action: re-shoot in natural light, add macro shots of the leather grain, add a paragraph describing the actual texture.
  4. A 7.5% refund rate on the cotton tee is healthy for fashion. Don’t waste effort optimising the tail; the leverage is at the top.
  5. Compounding effect. The top-5 refunded SKUs in this example account for 21,305ofrefundvalueover90days,around21,305 of refund value over 90 days, around 7,100/month of avoidable cost. Halving that with size-chart and photography fixes adds $42k of profit annually. This card is the highest-ROI single dashboard on most fashion BC stores.
Action priority order:
  1. Pause or fix the top-2 SKUs by refund rate (anything above 30% gets paused; 20-30% gets a product-page audit; under 20% gets monitored).
  2. Read the actual refund reasons in BC’s Refund tab for the top-5. The pattern (sizing / colour / quality / damage) tells you the exact fix.
  3. Cross-reference with BC Top SKUs Revenue to identify SKUs that are both top-sellers AND top-refunded. These are urgent: high volume × high refund rate = the largest pool of avoidable cost.
  4. Look at variant-level data. A product with 43% refund rate often has one bad variant (the M size) and four healthy ones; the fix is a size-specific adjustment, not a full SKU pull.
  5. Tag the fixed SKUs in BC with refund_audit_v1_complete so you can measure the effect of the fix in 30 days. Did the refund rate fall? If yes, replicate the playbook on the next bottom-5.

Sibling cards merchants should reference together

Reconciling against the vendor’s own dashboard

Where to look in BigCommerce Control Panel: Orders → All orders, filter by status Refunded or Partially Refunded, then sort by date descending. There is no native BC report that ranks refunded products directly; the closest is Analytics → Reports → Returns (Plus / Pro / Enterprise plans only) which lists refund counts but not by product. The per-product breakdown requires either an export of refund data or a third-party app, this card does that aggregation natively. For diagnosis on a specific SKU: click into the order, the refund line items show the per-SKU refund quantity and reason. Aggregating reasons across orders by hand is tedious; this card surfaces the pattern. Why our number may legitimately differ from BC: Cross-connector reconciliation (when ad and email integrations are connected): The most-refunded-products view is BC-aligned with similar cards on Shopify (top_refunded) and Adobe Commerce (adobe_top_refunded); product attribution semantics are equivalent across platforms.

Known limitations / merchant FAQs

My #1 SKU has only 12 refunds, is the ranking meaningful? For low-volume stores (<200 orders/month), the top of this leaderboard is noisier than the tail. Twelve refunds on a SKU that sold 30 units is genuinely a 40% refund rate problem; twelve refunds on a SKU that sold 800 units is 1.5% and probably noise. Always look at refund rate, not just refund count. The card supports a min-units-sold filter; set it to 30-50 to suppress small-sample false positives. Why are some of my refunded SKUs not in this card? Three common causes: (1) the refund happened outside the 90-day window; (2) the refund was processed as a “cancellation” rather than a “refund” in BC’s order workflow (these surface on BC Cancelled Over Time instead); (3) the refund was a shipping-only refund (the customer kept the goods but got the shipping cost back), which doesn’t attribute to a SKU. To see the full picture, cross-reference with Refund Value and BC Cancelled Over Time. My fashion store always has high refund rates, what’s normal? Fashion industry benchmark refund rate is 20-35%. Anything below 15% is exceptional (often signals a “no-returns” policy or a non-fashion catalogue mislabelled). 35-45% is high but recoverable; 45%+ is a structural problem (sizing, photography, expectations, or customer-segment mismatch). Homewares typically run 8-15%; consumer electronics 5-10%; consumables under 3%. Compare your store’s headline refund rate against your category, not against an absolute number. Can I exclude “customer changed their mind” refunds from this view? Not directly, the card aggregates by SKU regardless of refund reason. However, if you click into a high-rank SKU’s refund detail, you’ll see the reason breakdown. SKUs where >70% of refunds are “changed mind” are not a product-quality problem; they’re a marketing-promise problem (the product page promised something the product didn’t deliver). Different fix. Why does the same SKU appear at #1 on the unit-count view but #5 on the dollar-value view? High-volume, low-price items rank high by units; low-volume, high-price items rank high by value. Use both views. Unit count tells you which SKU is causing operational pain (the warehouse processes more returns); dollar value tells you which SKU is causing financial pain. Premium fashion brands often see hero items at #1 by value despite a moderate refund count. My multi-currency store, the dollar values look weird, why? The card sums refund amounts naively across currencies; without FX conversion, $100 USD and £100 GBP both contribute “100”. Filter the card by currency for accurate dollar comparisons. The unit-count view is currency-agnostic and always correct. Can I see refund reasons aggregated across all my refunds? Yes, click “Reason breakdown” at the top of the card for a store-wide reason histogram (defective, sizing, colour, damaged, changed mind, other). This is more useful than per-SKU reasons for spotting systemic problems (e.g. 40% of all refunds being “damaged in transit” points to a fulfilment partner problem, not a product problem). My B2B portal refunds, do they show up here? Yes if you’re on BC Enterprise with B2B Edition enabled. B2B refund rates are typically much lower (5-12%) than B2C; if you see a B2B SKU at the top of this card, investigate immediately, B2B customers tend to refund only for genuine defects, not preference reasons. A specific SKU jumped from rank 50 to rank 3 over two weeks, what happened? Almost certainly a defective batch shipped from the warehouse. Cross-check with BC Alert Refund Rate Spike. Check fulfilment dates of the refunded units, if they cluster on a specific 1-2 day window, that batch had a quality issue. Action: pull remaining inventory of that batch, replace, contact customers proactively. Should I auto-pause SKUs above a threshold? Strongly recommended for SKUs above 40% refund rate, with min 50 units sold. The unit-economics are negative at that rate (refund processing, shipping back, restocking, customer service all cost real money). Vortex Mind can configure this auto-pause via a workflow rule, the SKU is set to availability = disabled until a human reviews the product page.

Tracked live in Vortex IQ Nerve Centre

Most Refunded Products 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.