Workflow · Stock and products · Opening soon

Product return rate

See return rate by product and reason from your Shopify exports. Use closed returns only, then divide units returned by units sold.

Book a demo

Someone typed

“calculate the return rate by product and reason: units returned divided by units sold”

The agent read it as

Calculate the return rate by product and reason: units returned divided by units sold in Shopify returns and Shopify order line items, counting closed returns only.

What the agent built

4 steps, each one an ordinary Mammoth step you can open and change.

File

Shopify returns

CSV export · 18 rows

File

Shopify order line items

CSV export · 20 rows

Step

Total closed returns by product and reason

Step 1

Step

Total units sold by product

Step 2

Join

Add units sold

10 of 10 paired

Step

Calculate return rate

Step 4

Result

Product Return Rates

10 rows

Schedule

Runs when you say

Proposed

File
Shopify returns
CSV export · 18 rows
File
Shopify order line items
CSV export · 20 rows
Step
Total closed returns by product and reason
Step 1
Step
Total units sold by product
Step 2
Join
Add units sold
10 of 10 paired
Step
Calculate return rate
Step 4
Result
Product Return Rates
10 rows
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 10 rows came out, and the join paired 10 of 10 rows.

Download Shopify returns sample (18 rows)Shopify Admin: Orders > Returns > Export
Download Shopify order line items sample (20 rows)Shopify Admin: Orders > Export > Current page / All orders, then use the line-item columns in the CSV

What you get back

The result of that run, the rows to look at first.

Product Return RatesSample data10 rows

Product	Reason	Units returned	Units sold	Return rate
Harbor Mug - Sea Glass	Arrived damaged	2	9	0.2
Ridge Socks - Pine / L	Wrong size	3	9	0.3
Luna Candle - Cedar	Changed mind	2	3	0.7
Moss Knit Beanie - Black / OS	Changed mind	2	5	0.4
Trail Runner Jacket - Navy / M	Too small	2	4	0.5
Studio Tee - White / S	Defective item	2	6	0.3
Coast Scarf - Clay	Color mismatch	1	3	0.3
Dune Notebook - Sand	Not as described	3	5	0.6
Moss Knit Beanie - Black / OS	Too small	1	5	0.2
Trail Runner Jacket - Navy / M	Changed mind	1	4	0.3

10 rows in the result. Sample data: illustrative figures, not business results.

How do you calculate return rate by product and reason?

Export your Shopify returns and Shopify order line items, then upload them to Mammoth. It totals closed returns by product and reason, totals units sold by product, adds the sales data, and calculates return rate as units returned divided by units sold.

How it works

How to use the Product Return Rates 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 Return Rates: questions

Which export should you use?

Use the exported files from Shopify returns and Shopify order line items. The workflow reads those exported rows and uses the fields in them to build the result.

What happens to rows that do not match?

Rows that do not match the workflow rules are left out of the matched totals. You can review the unmatched rows and adjust the rules if needed.

How do you change the rules?

Edit the matching words and grouping rules in plain language, then run the workflow again. You can change which product or reason values are grouped together and which rows are included.