Workflow · Stock and products · Opening soon

Days of supply by SKU

See how long each SKU should last from stock on hand and recent sales. Use your Shopify products export and orders export to work out days of supply by SKU.

Book a demo

Someone typed

“calculate days of supply for each SKU from stock on hand and average daily sales over the last 30 days”

The agent read it as

Calculate days of supply for each SKU from stock on hand in Shopify products export and average daily sales over the last 30 days in Shopify orders export.

What the agent built

4 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 · 24 rows

Step

Make product SKU key

Step 1

Step

Average sales over 30 days

Step 2

Join

Bring in average sales

8 of 8 paired

Step

Calculate days of supply

Step 4

Result

SKU Days Of Supply

8 rows

Schedule

Runs when you say

Proposed

File
Shopify products export
CSV export · 8 rows
File
Shopify orders export
CSV export · 24 rows
Step
Make product SKU key
Step 1
Step
Average sales over 30 days
Step 2
Join
Bring in average sales
8 of 8 paired
Step
Calculate days of supply
Step 4
Result
SKU Days Of Supply
8 rows
Schedule
Runs when you say
Proposed

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

Download Shopify products export sample (8 rows)Shopify Admin: Products > Export > Current page or all products (CSV)
Download Shopify orders export sample (24 rows)Shopify Admin: Orders > Export > All orders matching criteria (CSV)

What you get back

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

SKU Days Of SupplySample data8 rows

SKU	Days of supply	Stock on hand	Average daily sales
sku_rivet_pen	276.92	120	0.43
sku_bloom_notebook	168.75	90	0.53
sku_cedar_bottle	250	150	0.60
sku_mint_tote	240	80	0.33
sku_ember_candle	257.14	60	0.23
sku_onyx_tee	350	140	0.40
sku_drift_mug	2,000	200	0.10
sku_zen_stand	825	110	0.13

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

How do you calculate days of supply by SKU?

Export your Shopify products file and your Shopify orders file, then match them by SKU. The workflow uses stock on hand from products and average daily sales over the last 30 days from orders, then calculates days of supply for each SKU.

How it works

How to use the SKU Days Of Supply 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 Days Of Supply: questions

Which export files do I need?

Use the products export for stock on hand and the orders export for sales over the last 30 days. The workflow reads those exported files and uses the SKU to match rows.

What happens if a SKU appears in one file but not the other?

Rows that do not match are left out of the final calculation or stay unmatched, depending on the step. You can review the unmatched rows and decide whether to add, fix, or exclude them.

How do you change the rules?

Edit the step in words, for example by changing the sales window, the SKU match field, or the formula for days of supply. Then rerun the workflow on the same exported files.