Workflow · Stock and products · Opening soon

SKU rationalization

Use your Shopify orders export and products export to review each SKU over the past 12 months. See which SKUs have low sales, low margin, or both, with their revenue share.

Book a demo

Someone typed

“from shopify orders and products exports, show each sku with last-year revenue before discounts, units sold, revenue share, and gross margin %; status Agrees when orders are 2+ and margin is 30%+, else Low sales or Low margin”

The agent read it as

From Shopify orders export and Shopify products export, show each sku with last-year revenue before discounts, units sold, revenue share, and gross margin %; status Agrees when orders are 2+ and margin is 30%+, else Low sales or Low margin, using the past 12 months.

What the agent built

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

File

Shopify products export

CSV export · 11 rows

File

Shopify orders export

CSV export · 36 rows

Step

Make product SKU key

Step 1

Step

Total past-year sales by SKU

Step 2

Join

Bring in SKU sales

8 of 11 paired

Step

Work out SKU results

Step 4

Result

SKU Sales Margins

11 rows · 3 flagged

Schedule

Runs when you say

Proposed

File
Shopify products export
CSV export · 11 rows
File
Shopify orders export
CSV export · 36 rows
Step
Make product SKU key
Step 1
Step
Total past-year sales by SKU
Step 2
Join
Bring in SKU sales
8 of 11 paired
Step
Work out SKU results
Step 4
Result
SKU Sales Margins
11 rows · 3 flagged
Schedule
Runs when you say
Proposed

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

Download Shopify products export sample (11 rows)Shopify Admin: Products > Export > All products
Download Shopify orders export sample (36 rows)Shopify Admin: Orders > Export > All orders

What you get back

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

SKU Sales MarginsSample data11 rows

8 agrees3 low sales

Product SKU	Revenue before discounts	Units sold	Revenue share %	Gross margin %	Orders	Status
KEY-HARBOR	0	0	0	·	0	Low sales
PLANT-POCKET	0	0	0	·	0	Low sales
POUCH-EMBER	0	0	0	·	0	Low sales
BOTTLE-COP	294	7	10.8	54.8	5	Agrees
CANDLE-LUNA	280	10	10.3	55.4	4	Agrees
HOOD-SUMMIT	408	6	15	54.4	4	Agrees
MUG-ATLAS	288	12	10.6	68.8	5	Agrees
NOTE-NORTH	270	15	9.9	66.7	5	Agrees
SOCK-TRAIL	288	18	10.6	75	4	Agrees
TEE-SUNRISE	520	20	19.1	65.4	4	Agrees
TOTE-EVER	374	11	13.7	67.6	5	Agrees

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

How do you rationalize SKUs from Shopify exports?

Export your Shopify orders and products, then upload them to Mammoth. It matches SKUs, totals the past 12 months by SKU, and shows revenue before discounts, units sold, revenue share, and gross margin %. Each SKU gets a status of Agrees when it has 2 or more orders and at least 30% margin, otherwise Low sales or Low margin.

How it works

How to use the SKU Sales Margins 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 Sales Margins: questions

Which Shopify exports should you use?

Use the Shopify orders export and the Shopify products export. The workflow reads the exported files, then matches them by SKU.

What happens to SKUs that do not meet the rules?

They still appear in the results. They are marked Low sales or Low margin based on the rules, so you can review them for cuts.

How do you change the rules?

Change the rule text in plain words, for example the order count, margin threshold, or time window. The workflow follows the updated wording when it runs on your exported files.