Workflow · Stock and products · Opening soon

Safety stock by SKU

Calculate safety stock and reorder point for each SKU from your Shopify exports and supplier lead times. Use daily sales variability and a 95% service level to set stock levels by SKU.

Book a demo

Someone typed

“calculate safety stock and reorder point for each SKU from daily sales variability and supplier lead time”

The agent read it as

Calculate safety stock and reorder point for each SKU from daily sales variability and supplier lead time using Shopify orders export, Shopify products export and Supplier lead times, using a 95% service level.

What the agent built

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

File

Shopify products export

CSV export · 8 rows

File

Shopify orders export

CSV export · 30 rows

File

Supplier lead times

CSV export · 8 rows

Step

Summarize daily sales

Step 1

Step

Make lead time SKU key

Step 2

Step

Make product SKU key

Step 3

Join

Bring in daily sales

7 of 8 paired

Join

Bring in supplier lead time

8 of 8 paired

Step

Calculate stock levels

Step 6

Result

SKU Reorder Points

8 rows

Schedule

Runs when you say

Proposed

File
Shopify products export
CSV export · 8 rows
File
Shopify orders export
CSV export · 30 rows
File
Supplier lead times
CSV export · 8 rows
Step
Make product SKU key
Step 3
Step
Summarize daily sales
Step 1
Step
Make lead time SKU key
Step 2
Join
Bring in daily sales
7 of 8 paired
Join
Bring in supplier lead time
8 of 8 paired
Step
Calculate stock levels
Step 6
Result
SKU Reorder Points
8 rows
Schedule
Runs when you say
Proposed

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

Download Shopify products export sample (8 rows)Shopify admin: Products > Export > All products > CSV for Excel, Numbers, or other spreadsheet programs
Download Shopify orders export sample (30 rows)Shopify admin: Orders > Export > All orders > CSV for Excel, Numbers, or other spreadsheet programs
Download Supplier lead times sample (8 rows)Manual spreadsheet used with Shopify SKU history for replenishment planning

What you get back

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

SKU Reorder PointsSample data8 rows

SKU	Safety stock (units)	Reorder point (units)	Average daily sales	Daily sales variability	Lead time days
sku_aurora_mug	8	44	4	1.58	9
sku_trail_bottle	12	88	4	1.58	19
sku_studio_lamp	6	34	2	0.82	14
sku_pocket_notebook	8	52	6.25	1.71	7
sku_cedar_planter	6	38	2	0.82	16
sku_arc_pen	7	66	9.75	1.71	6
sku_nova_thermos	8	41	2.50	1.29	13
sku_ember_socks	0	0	·	·	11

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

How do you calculate safety stock by SKU?

Export your Shopify orders and products, and add a supplier lead time file. The workflow summarizes daily sales, matches rows by SKU, and calculates safety stock and reorder point for each item using your lead time data.

How it works

How to use the SKU Reorder Points 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 Reorder Points: questions

What export should I use?

Use exports that contain the rows you need, such as orders, products, and a supplier lead time file. The workflow reads those files and uses shared fields like SKU to match records.

What happens to rows that do not match?

Rows that do not match a key are not joined to the rest of the data. You can review them separately and fix the source file or the matching rule if needed.

How do I change the rules?

Edit the rule words in plain language, such as which column is the SKU key, which lead time field to use, or which service level to apply. Then run the workflow again with the updated files or steps.