Refund rate by product
“show each product from the shopify orders and refunds for the last 90 days, calculate refund rate from refunded amount versus sales, and mark agrees for matched refunds, duplicate refund, or unmatched refund”
show each product from the Shopify Orders and Shopify Refunds for the last 90 days, calculate refund rate from refunded amount versus sales, and mark agrees for matched refunds, duplicate refund, or unmatched refund
What the agent built
4 steps, each one an ordinary Mammoth step you can open and change.
- FileShopify OrdersCSV export · 24 rows
- FileShopify RefundsCSV export · 10 rows
- StepTotal sales by productStep 1
- StepTotal refunds by productStep 2
- JoinBring refunds over6 of 8 paired
- StepCalculate refund rateStep 4
- ResultProduct refund review9 rows · 1 flagged
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 9 rows came out, and the join paired 6 of 8 rows.
- Download Shopify Orders sample (24 rows)Shopify admin: Orders > Export > All orders > CSV for Excel, Numbers, or other spreadsheet programs
- Download Shopify Refunds sample (10 rows)Shopify admin: Orders > Refunds > Export CSV
What you get back
The result of that run, the rows to look at first.
| Product sku | Product name | Sales amount | Refund amount | Refund rate | Status |
|---|---|---|---|---|---|
| aura-bag | Aura Sling Bag | 0 | 39 | · | Unmatched refund |
| ember-cap | Ember Dad Cap | 112 | 28 | 25 | Agrees |
| luna-mug | Luna Ceramic Mug | 144 | 48 | 33.3 | Agrees |
| mint-sc | Mint Travel Scarf | 136 | 34 | 25 | Agrees |
| nova-note | Nova Notebook | 108 | 0 | 0 | Agrees |
| pine-tote | Pine Canvas Tote | 156 | 78 | 50 | Agrees |
| sol-pad | Sol Desk Pad | 154 | 22 | 14.3 | Agrees |
| trail-btl | Trail Steel Bottle | 192 | 0 | 0 | Agrees |
| wave-sock | Wave Crew Socks | 132 | 12 | 9.1 | Agrees |
How do you calculate refund rate by product?
Export your Shopify Orders and Shopify Refunds files, then upload them to Mammoth. It totals sales by product, totals refunds by product, and calculates refund rate from refunded amount versus sales for the last 90 days. You can also see matched refunds, duplicate refunds, and unmatched refunds.
How it works
How to use the Product refund review workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Product refund review: questions
Which export files should I use?
What happens to rows that do not match?
How do I change the rules?
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Find the few products that make most of your sales, what sells together, and the stock that sits too long.
- Shopify sales by productBuild weekly Shopify sales by product from orders and refunds exports. See gross sales, discounts, refunds, net sales, and status by SKU.See the workflow Built by the agent
- Shopify inventory reportBuild a Shopify inventory report with on hand, last 4 weeks of sales, and weeks of cover for each product and location.See the workflow Built by the agent
- GA4 vs Shopify revenue gapCompare daily GA4 revenue with Shopify orders, match the dates, and flag days where one side is more than 5% higher.See the workflow Built by the agent
- Shopify returns by productBuild a Shopify returns report by SKU with return reason and return rate from exported orders and returns files.See the workflow Built by the agent
- Pareto (ABC) analysisEvery item ranked by its total, with its share, the running share and an A, B or C classSee the workflow Template
- Market basket analysisEvery pair of products bought together, with support, confidence and liftSee the workflow Template