Workflow · Stock and products · Opening soon

Reorder points

Upload your Shopify orders export and reorder settings export. Mammoth calculates reorder point per SKU, skips refunded orders, and flags items below point.

Book a demo

Someone typed

“show every sku from the shopify orders export and reorder settings, dedupe repeats and skip refunded orders, then calculate reorder point from daily sales, lead time, and safety stock; Status says "Agrees" when stock is safely above it”

The agent read it as

show every sku from the Shopify orders export and Shopify reorder settings, dedupe repeats and skip refunded orders, then calculate reorder point from daily sales, lead time, and safety stock; Status says "Agrees" when stock is safely above it

What the agent built

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

File

Shopify orders export

CSV export · 30 rows

File

Shopify reorder settings

CSV export · 8 rows

Step

Skip refunded orders

Step 1

Step

Work out daily sales

Step 2

Step

Dedupe settings

Step 3

Join

Add reorder settings

8 of 9 paired

Step

Compare to reorder point

Step 5

Result

Reorder point check

9 rows · 7 flagged

Schedule

Runs when you say

Proposed

File
Shopify orders export
CSV export · 30 rows
File
Shopify reorder settings
CSV export · 8 rows
Step
Skip refunded orders
Step 1
Step
Dedupe settings
Step 3
Step
Work out daily sales
Step 2
Join
Add reorder settings
8 of 9 paired
Step
Compare to reorder point
Step 5
Result
Reorder point check
9 rows · 7 flagged
Schedule
Runs when you say
Proposed

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

Download Shopify orders export sample (30 rows)Shopify: Orders > Export > All orders (line items)
Download Shopify reorder settings sample (8 rows)Shopify: Products > Export (including metafields)

What you get back

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

Reorder point checkSample data9 rows

2 agrees6 below point1 no settings

SKU	Stock on hand	Lead time days	Safety stock units	Daily sales	Reorder point	Status
kite-sticker	·	·	·	5	0	No settings
aurora-bottle	18	9	10	1.50	23.50	Below point
cedar-mug	24	12	8	1.75	29	Below point
ember-tumbler	11	7	9	1.67	20.67	Below point
frost-planner	16	14	12	1.33	30.67	Below point
halo-candle	14	8	7	2.50	27	Below point
ivy-bag	9	15	11	1.33	31	Below point
grove-notebook	32	10	14	1.75	31.50	Agrees
juniper-pen	41	6	10	2.75	26.50	Agrees

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

How do you calculate reorder point per SKU from exported Shopify data?

Upload your Shopify orders export and your Shopify reorder settings export. Mammoth skips refunded orders, dedupes repeated settings, works out daily sales, then compares stock to each SKU's reorder point. Rows with stock safely above the point show Agrees, rows below the point show Below point, and rows with no matching settings show No settings.

How it works

How to use the Reorder point check 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.

Reorder point check: questions

Which Shopify export should you use?

Use the orders export for sales history and a settings export that lists each SKU with its reorder settings, such as lead time and safety stock.

What happens to rows that do not match?

Rows with no matching settings stay in the result and are marked No settings. Refunded orders are skipped, and repeated settings rows are deduped before the calculation runs.

How do you change the rules?

Edit the workflow steps in words. You can change the filters, the matching fields, or the calculation inputs such as daily sales, lead time, and safety stock.