Workflow · Stock and products · Opening soon

Shopify returns by product

Use your Shopify orders export and returns export to group returns by product for the last 90 days. Add a return rate so you can see which SKUs are being returned most.

Book a demo

Someone typed

“show sku and return reason from the shopify orders and returns exports for the last 90 days, with return rate returned units / sold units, and Status says "Agrees" when it's 0, else short reason”

The agent read it as

show sku and return reason from Shopify orders export and Shopify returns export for the last 90 days, with return rate returned units / sold units, and Status says "Agrees" when it's 0, else short reason

What the agent built

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

File

Shopify orders export

CSV export · 16 rows

File

Shopify returns export

CSV export · 12 rows

Step

Sum sold units

Step 1

Step

Summarize returns

Step 2

Join

Bring in returns

8 of 10 paired

Step

Add rate and status

Step 4

Result

SKU return rates

10 rows · 8 flagged

Schedule

Runs when you say

Proposed

File
Shopify orders export
CSV export · 16 rows
File
Shopify returns export
CSV export · 12 rows
Step
Sum sold units
Step 1
Step
Summarize returns
Step 2
Join
Bring in returns
8 of 10 paired
Step
Add rate and status
Step 4
Result
SKU return rates
10 rows · 8 flagged
Schedule
Runs when you say
Proposed

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

Download Shopify orders export sample (16 rows)Shopify admin: Orders > Export > All orders > CSV
Download Shopify returns export sample (12 rows)Shopify admin: Orders > Returns > Export

What you get back

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

SKU return ratesSample data10 rows

2 agrees2 changed mind2 damaged in transit1 arrived late, Damaged in transit1 defective item1 too small1 wrong item sent

SKU	Sold units	Returned units	Return reason	Return rate	Status
NOTE-LIN-01	5	3	Changed mind	0.6	Changed mind
SOCK-STR-02	5	1	Wrong item sent	0.2	Wrong item sent
PLNT-POT-06	3	2	Damaged in transit	0.7	Damaged in transit
CANDLE-LAV-08	2	1	Damaged in transit	0.5	Damaged in transit
MUG-RED-12	3	2	Arrived late, Damaged in transit	0.7	Arrived late, Damaged in transit
BAG-CAN-01	3	1	Changed mind	0.3	Changed mind
TEE-NAVY-S	2	1	Too small	0.5	Too small
BOTTLE-SS-20	3	1	Defective item	0.3	Defective item
CANDLE-VAN-08	1	0	·	0	Agrees
TEE-OLI-M	1	0	·	0	Agrees

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

How do you build a Shopify returns report by product?

Export your Shopify orders for the last 90 days, then export your Shopify returns for the same period. Use the SKU from both files to group sold units, bring in return reasons, and calculate return rate as returned units divided by sold units. Add a Status rule that says Agrees when the rate is 0, and show a short reason when it is not.

How it works

How to use the SKU 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.

SKU return rates: questions

Which export should you use?

Use the Shopify orders export for sold units and the Shopify returns export for returned units and return reasons. Use the same date range in both files, such as the last 90 days.

What happens to rows that do not match?

Rows that do not match stay out of the matched result. You can keep them in a separate list if you want to review products with sales but no returns, or returns that do not line up with a sold SKU.

How do you change the rules?

Edit the steps in words, for example change the date range, choose a different product field, or change the status rule. You can also change how return rate is calculated or what text appears when the rate is not zero.