Workflow · Stock and products · Opening soon

Dead stock report

See which SKUs have stock on hand, recent sales in the last 90 days, and how much value is tied up in inventory. Mark healthy rows as Agrees and flag the rest with a short reason.

Book a demo

Someone typed

“show every shopify product sku with stock on hand, recent sales in the last 90 days, and tied-up value from inventory times price, with a Status that says "Agrees" for healthy rows and a short reason for the rest”

The agent read it as

show every Shopify Products sku with stock on hand, recent sales in the last 90 days from Shopify Orders, and tied-up value from inventory times price, with a Status that says "Agrees" for healthy rows and a short reason for the rest

What the agent built

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

File

Shopify Products

CSV export · 10 rows

File

Shopify Orders

CSV export · 18 rows

Step

Normalize sku

Step 1

Step

Total recent sales

Step 2

Step

Normalize sku

Step 3

Join

Bring in sales

9 of 10 paired

Step

Add value and status

Step 5

Result

Shopify stock status

10 rows · 1 flagged

Schedule

Runs when you say

Proposed

File
Shopify Products
CSV export · 10 rows
File
Shopify Orders
CSV export · 18 rows
Step
Normalize sku
Step 3
Step
Normalize sku
Step 1
Step
Total recent sales
Step 2
Join
Bring in sales
9 of 10 paired
Step
Add value and status
Step 5
Result
Shopify stock status
10 rows · 1 flagged
Schedule
Runs when you say
Proposed

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

Download Shopify Products sample (10 rows)Shopify Admin: Products > All products > Export
Download Shopify Orders sample (18 rows)Shopify Admin: Orders > Export

What you get back

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

Shopify stock statusSample data10 rows

9 agrees1 no recent sales

SKU	Price	Stock on hand	Recent sales	Tied-up value	Status
DPP-005	24	25	0	600	No recent sales
AMUG-001	18	42	6	756	Agrees
LNBK-002	14	28	4	392	Agrees
CCAN-003	22	31	4	682	Agrees
CTOT-004	16	19	3	304	Agrees
WPS-006	32	14	3	448	Agrees
BCP-007	20	18	3	360	Agrees
BST-008	28	9	1	252	Agrees
SCEL-009	12	21	4	252	Agrees
TTOW-010	15	16	2	240	Agrees

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

How do you build a dead stock report from Shopify exports?

Export your Shopify products and orders, then load them into the workflow. It matches SKUs, totals sales from the last 90 days, calculates tied-up value from stock on hand times price, and adds a Status column. Healthy rows show Agrees, and rows that do not match the rule get a short reason.

How it works

How to use the Shopify stock status 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 stock status: questions

What export should you use?

Use a products export for stock on hand and price, and an orders export for recent sales. The workflow reads the exported files and works from the rows in them.

What happens to rows that do not match the rule?

They stay in the output with a status that shows why they do not match. For this report, that can be things like no recent sales or missing data needed for the match.

How do you change the rules in words?

You can rewrite the rule in plain words, such as changing the sales window, the stock filter, or the value formula. The workflow follows the new wording when it runs on the exported files.