Analytics ๐Ÿ’Ž Built for Sidekick โšก Sidekick does this for you
shopify sidekick analytics refunds

Report Refund Rate by Product

Rank products by refund rate and refunded dollar amount to spot quality or listing problems.

๐Ÿ“‹ Prompt
Run in Sidekick
Build a refund rate report by product for orders placed in [LAST 60 DAYS / LAST QUARTER].

Per product:

  Units sold
  Units refunded (full or partial refund)
  Refund rate % = units refunded รท units sold
  Total dollars refunded
  Refund rate compared to the store-wide average refund rate for the same period


Ranking:

  Top 15 products by refund rate %, limited to products with at least [10] units sold (to avoid noise from low-volume items)
  Top 10 products by total dollars refunded, regardless of rate
  Trend: is the store-wide refund rate rising or falling vs the prior period?


Output format:

  Table: product, units sold, units refunded, refund rate %, $ refunded
  Store-wide refund rate for context


Deliverables:

  The ranked tables
  Flag any product whose refund rate is more than 2x the store average โ€” these are the strongest candidates for a listing, sizing-chart, or quality review
  One-line note on total refunded dollars as a % of total revenue for the period

How to Use

  1. Copy the prompt above
  2. Open Shopify Sidekick in your Shopify admin
  3. Paste the prompt and replace the bracketed placeholders with your details
  4. Review Sidekick's response and apply the suggestions