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
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
- Copy the prompt above
- Open Shopify Sidekick in your Shopify admin
- Paste the prompt and replace the bracketed placeholders with your details
- Review Sidekick's response and apply the suggestions