Workflow · Stock and products · Opening soon

Shopify sales by product

Turn your Shopify orders export and refunds export into a weekly sales by product report. You can review gross sales, discounts, refunds, net sales, and status by SKU.

Book a demo

Someone typed

“weekly by sku from the shopify orders and refunds files: total gross, discounts, refunds, net sales, status; Agrees when discounts and refunds are each 20% or less of gross sales, otherwise Refund heavy or Discount heavy”

The agent read it as

weekly by sku from the Shopify orders export and Shopify refunds export files: total gross, discounts, refunds, net sales, status; Agrees when discounts and refunds are each 20% or less of gross sales, otherwise Refund heavy or Discount heavy

What the agent built

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

File

Shopify orders export

CSV export · 18 rows

File

Shopify refunds export

CSV export · 12 rows

Step

Sum orders by week

Step 1

Step

Sum refunds by week

Step 2

Join

Bring refunds onto orders

11 of 18 paired

Step

Add net sales and status

Step 4

Result

Weekly SKU summary

18 rows · 8 flagged

Schedule

Runs when you say

Proposed

File
Shopify orders export
CSV export · 18 rows
File
Shopify refunds export
CSV export · 12 rows
Step
Sum orders by week
Step 1
Step
Sum refunds by week
Step 2
Join
Bring refunds onto orders
11 of 18 paired
Step
Add net sales and status
Step 4
Result
Weekly SKU summary
18 rows · 8 flagged
Schedule
Runs when you say
Proposed

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

Download Shopify orders export sample (18 rows)Shopify admin: Orders > Export > Current page as CSV
Download Shopify refunds export sample (12 rows)Shopify admin: Orders > Refunds > Export CSV

What you get back

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

Weekly SKU summarySample data18 rows

10 agrees8 refund heavy

Week	SKU	Gross	Discounts	Refunds	Net sales	Status
2026-08-31	MUG-200	72	3.60	18	50.40	Refund heavy
2026-09-21	CAP-800	84	0	28	56	Refund heavy
2026-09-21	STCK-700	72	7.20	18	46.80	Refund heavy
2026-09-28	MUG-200	108	10.80	36	61.20	Refund heavy
2026-10-05	NOTE-400	64	0	16	48	Refund heavy
2026-10-12	CAND-500	154	15.40	44	94.60	Refund heavy
2026-10-26	MUG-200	72	0	18	54	Refund heavy
2026-10-26	PLA-100	147	0	49	98	Refund heavy
2026-08-31	PLA-100	98	0	0	98	Agrees
2026-09-07	BAG-300	72	0	0	72	Agrees
2026-09-07	NOTE-400	80	4	16	60	Agrees
2026-09-14	CAND-500	132	6.60	22	103.40	Agrees

18 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How do you build weekly Shopify sales by product reports?

Export your Shopify orders file and your Shopify refunds file, then upload both. The workflow groups results by week and SKU, sums orders and refunds, brings refunds onto orders, and calculates net sales and status. Rows that do not match the rule for Agrees are marked Refund heavy or Discount heavy.

How it works

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

Weekly SKU summary: questions

Which Shopify exports should you use?

Use the orders export and the refunds export from Shopify. The workflow reads those files and uses them to build the weekly report.

What happens when a row does not match the Agrees rule?

If discounts and refunds are each 20% or less of gross sales, the row is marked Agrees. If either one is above that level, the row is marked Refund heavy or Discount heavy.

How do you change the rules?

You change the rule text in the workflow steps. For example, you can adjust the week grouping, the SKU grouping, or the percentage threshold for the status labels.