Workflow · Stock and products · Opening soon

Stockout report

See which SKUs went out of stock in the last 30 days. Track how long each item was unavailable and the sales you likely missed.

Book a demo

Someone typed

“list the SKUs that ran out of stock in the last 30 days, how many days they were out and the sales we likely missed”

The agent read it as

List the SKUs that ran out of stock in the last 30 days, how many days they were out and the sales we likely missed from Shopify stockout periods.

What the agent built

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

File

Shopify stockout periods

CSV export · 10 rows

Step

Keep recent stockouts

Step 1

Result

Recent Stockout Sales

10 rows

Schedule

Runs when you say

Proposed

File
Shopify stockout periods
CSV export · 10 rows
Step
Keep recent stockouts
Step 1
Result
Recent Stockout Sales
10 rows
Schedule
Runs when you say
Proposed

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

Download Shopify stockout periods sample (10 rows)Shopify: Analytics > Reports > Stockouts by SKU > Export

What you get back

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

Recent Stockout SalesSample data10 rows

SKU	Days out	Estimated missed sales
CHG-USB-C2	3	189
JRN-CLN-A5	5	210
SOCK-ANK-3PK	6	234
CAP-RUN-ONE	4	288
BND-REC-2	5	310
BOT-HYD-500	6	624
MAT-YOGA-4MM	2	196
BAG-TRVL-100	5	750
TWL-GYM-XL	4	176
MUG-EMBR-12	3	165

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

How do you list stockout SKUs and missed sales from a Shopify export?

Export your Shopify stockout data, then upload it to Mammoth. The workflow keeps the recent stockouts and returns the SKUs that ran out of stock in the last 30 days, how many days they were out, and the sales you likely missed.

How it works

How to use the Recent Stockout Sales 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.

Recent Stockout Sales: questions

What export should I use?

Use the Shopify export that contains stockout periods or inventory history for the products you want to review. The file should include the SKU and the dates or duration of each stockout.

What happens to rows that do not match the rule?

Rows outside the last 30 days are left out of the result. Only recent stockouts are kept in the output.

How do I change the rule in words?

Change the date rule, for example from the last 30 days to the last 7 days or a custom date range. You can also change which stockout fields you want to keep in the result.