Workflow · Search and ads · Opening soon

Affiliate commissions

Use your Shopify orders export and your affiliate commission rate table. The workflow matches referral codes to rates, keeps paid orders, and totals commissions by month.

Book a demo

Someone typed

“calculate affiliate commissions by affiliate and month from orders with their referral codes and commission rates”

The agent read it as

Calculate affiliate commissions by affiliate and month from Shopify orders with their referral codes and Affiliate commission rates, using the order subtotal.

What the agent built

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

File

Shopify orders

CSV export · 24 rows

File

Affiliate commission rates

CSV export · 8 rows

Step

Make rate code key

Step 1

Step

Keep paid orders

Step 2

Join

Add affiliate rates

23 of 23 paired

Step

Total commissions by month

Step 4

Result

Affiliate Commission Totals

18 rows

Schedule

Runs when you say

Proposed

File
Shopify orders
CSV export · 24 rows
File
Affiliate commission rates
CSV export · 8 rows
Step
Keep paid orders
Step 2
Step
Make rate code key
Step 1
Join
Add affiliate rates
23 of 23 paired
Step
Total commissions by month
Step 4
Result
Affiliate Commission Totals
18 rows
Schedule
Runs when you say
Proposed

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

Download Shopify orders sample (24 rows)Shopify admin: Orders > Export > All orders CSV
Download Affiliate commission rates sample (8 rows)Internal spreadsheet: Commissions > Affiliate Rates

What you get back

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

Affiliate Commission TotalsSample data18 rows

Affiliate	Month	Commission	Order subtotal	Commission rate
Sunrise Studio	2026-10-01	6	75	0.1
Northstar Collective	2026-10-01	17.16	132	0.1
Harbor House Media	2026-10-01	21	210	0.1
Verve Loop	2026-10-01	16.20	180	0.1
Evergreen Audience	2026-10-01	6.16	88	0.1
Harbor House Media	2026-11-01	24.40	244	0.1
Sunrise Studio	2026-11-01	22.16	277	0.1
Ridge Path Creators	2026-11-01	49.20	410	0.1
Evergreen Audience	2026-11-01	12.74	182	0.1
Coastline Partners	2026-11-01	34.10	310	0.1
Sunrise Studio	2026-09-01	9.60	120	0.1
Harbor House Media	2026-09-01	8.40	84	0.1

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

How do you calculate affiliate commissions by affiliate and month?

Export your Shopify orders and your affiliate commission rates, then load both files into the workflow. It matches each order to a rate using the referral code, keeps paid orders, and calculates commission from the order subtotal. Then it groups the results by affiliate and month.

How it works

How to use the Affiliate Commission Totals 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.

Affiliate Commission Totals: questions

What export should you use from Shopify?

Use the orders export from Shopify. It needs the order fields that include the referral code, paid status, order date, and order subtotal.

What happens to rows that do not match a rate?

Rows that do not match a rate stay out of the matched commission result unless you decide otherwise in the rules. You can review them separately and update the rate table or matching rule.

How do you change the rules?

You change the rules in plain words. For example, you can say which orders to keep, which column to match on, how to calculate commission, and how to group the totals.