Workflow · Stock and products · Opening soon

Demand forecast by SKU

Use your Shopify order line export to forecast next month’s demand for each SKU. The workflow uses the last 12 months, a recent monthly average, and a 12 month trend.

Book a demo

Someone typed

“forecast next month's demand for each SKU from the last 12 months of order lines, using the recent monthly average and trend”

The agent read it as

Forecast next month's demand for each SKU from the last 12 months of order lines, using the recent monthly average and trend, with a 3-month average plus 12-month trend from my Shopify order line items.

What the agent built

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

File

Shopify order line items

CSV export · 36 rows

Step

Forecast demand by SKU

Step 1

Result

SKU Demand Forecast

8 rows

Schedule

Runs when you say

Proposed

File
Shopify order line items
CSV export · 36 rows
Step
Forecast demand by SKU
Step 1
Result
SKU Demand Forecast
8 rows
Schedule
Runs when you say
Proposed

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

Download Shopify order line items sample (36 rows)Shopify Admin: Orders > Export > CSV (line items included)

What you get back

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

SKU Demand ForecastSample data8 rows

SKU	Forecast demand	3-month average	12-month trend
QUILL-PEN	2.66	2.67	-0.01
AURA-PLATE	0	0	-0.10
NOVA-CABLE	0	0	-0.28
PULSE-TRAY	1.56	1.67	-0.10
AURA-MUG	2.06	2	0.06
PULSE-BOTTLE	4.24	4	0.24
QUILL-NOTE	1.22	1.33	-0.11
NOVA-LAMP	1.71	1.67	0.04

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

How do you forecast demand by SKU?

Export your Shopify order lines and upload the file. The workflow groups rows by SKU, uses the last 12 months of order lines, then calculates next month’s demand from a 3 month average and a 12 month trend. You get a forecast for each SKU in the result.

How it works

How to use the SKU Demand Forecast 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 Demand Forecast: questions

What export should you use?

Use a Shopify export that includes order line items, SKU, date, and quantity. The file needs enough history to cover the period you want to analyse.

What happens to rows that do not match?

Rows that are missing required fields or do not fit the rules are left out of the step that needs them. You can review the output and fix the source file if needed.

How do you change the rules?

Edit the step in words, for example, change the time window, the grouping field, or the averaging method. Then run the workflow again on the same exported file or a new one.