Workflow · Stock and products · Opening soon

ABC analysis

See which Shopify SKUs drive the most revenue. Rank each SKU by yearly revenue and label it A, B, or C.

Someone typed

“rank the paid shopify skus by yearly revenue, show revenue, share, running share, and status as A tier, B tier, or C tier using the 80/15 split”

The agent read it as

Rank the paid Shopify SKUs by yearly revenue, show revenue, share, running share, and status as A tier, B tier, or C tier using the 80/15 split, for the latest year in the data.

What the agent built

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

File

Shopify Orders

CSV export · 24 rows

Step

Rank yearly SKU revenue

Step 1

Result

Shopify SKU Tiers

10 rows · 10 flagged

Schedule

Runs when you say

Proposed

File
Shopify Orders
CSV export · 24 rows
Step
Rank yearly SKU revenue
Step 1
Result
Shopify SKU Tiers
10 rows · 10 flagged
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 10 rows came out.

Download Shopify Orders sample (24 rows)Shopify Admin: Orders > Export

What you get back

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

Shopify SKU TiersSample data10 rows

4 C tier3 A tier3 B tier

SKU	Rank	Revenue	Share (%)	Running share (%)	Status
ALP-TSHIRT-S	1	7,000	42.4	42.4	A tier
BET-HOODIE-M	2	4,200	25.4	67.8	A tier
GAM-MUG-01	3	1,800	10.9	78.7	A tier
DEL-CAP-02	4	1,500	9.1	87.8	B tier
ZET-BAG-01	5	600	3.6	91.5	B tier
EPS-STICK-01	6	450	2.7	94.2	B tier
THA-NOTE-01	7	450	2.7	96.9	C tier
ETA-PRINT-01	8	210	1.3	98.2	C tier
IOT-CABLE-01	9	180	1.1	99.3	C tier
KAP-KEY-01	10	120	0.7	100	C tier

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

How do you do ABC analysis on Shopify SKUs?

Export your Shopify data, then use the yearly revenue for each paid SKU. Mammoth ranks the SKUs, shows revenue, share, running share, and assigns A, B, or C using an 80/15 split for the latest year in the file.

How it works

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

Shopify SKU Tiers: questions

What export should I use?

Use a Shopify export that includes SKU, paid order data, and revenue by date so the yearly totals can be calculated. If the file has more than one year, the workflow uses the latest year in the data.

What happens to rows that do not match?

Rows that do not fit the rule stay out of the ranked result. You can review them in the source file and change the rule if you want a different set of rows included.

How do I change the A, B, and C rules?

Edit the thresholds in words, such as top 80 percent for A, next 15 percent for B, and last 5 percent for C. You can also change the fields used for ranking if your export uses different column names.