Workflow · Stock and products · Opening soon

Inventory turnover by SKU

See which SKUs turn stock the slowest. Use Shopify exports to calculate turnover by SKU from the last 12 months.

Someone typed

“match the shopify products, orders, and inventory files by sku, use the trailing 12 months ending today to calculate sales dollars, average stock value, and turnover, then show each sku ranked slowest first”

The agent read it as

match the Shopify products export, Shopify orders export, and Shopify inventory export files by sku, use the trailing 12 months ending today to calculate sales dollars, average stock value, and turnover, then show each sku ranked slowest first, with turnover as cost of sales divided by average stock value, and average stock value based on average available snapshots

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 · 36 rows

File

Shopify inventory export

CSV export · 40 rows

Step

Standardize product SKU

Step 1

Step

Total sales by SKU

Step 2

Step

Average available snapshots

Step 3

Join

Bring in SKU sales

6 of 8 paired

Join

Bring in average stock

8 of 8 paired

Step

Calculate and rank turnover

Step 6

Result

Shopify SKU Turnover

8 rows

Schedule

Runs when you say

Proposed

File
Shopify products export
CSV export · 8 rows
File
Shopify orders export
CSV export · 36 rows
File
Shopify inventory export
CSV export · 40 rows
Step
Standardize product SKU
Step 1
Step
Total sales by SKU
Step 2
Step
Average available snapshots
Step 3
Join
Bring in SKU sales
6 of 8 paired
Join
Bring in average stock
8 of 8 paired
Step
Calculate and rank turnover
Step 6
Result
Shopify SKU Turnover
8 rows
Schedule
Runs when you say
Proposed

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

Download Shopify products export sample (8 rows)Shopify admin: Products > All products > Export
Download Shopify orders export sample (36 rows)Shopify admin: Orders > Export
Download Shopify inventory export sample (40 rows)Shopify admin: Products > Inventory > Export

What you get back

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

Shopify SKU TurnoverSample data8 rows

Product SKU	Sales dollars	Average stock value	Inventory turnover	Cost of sales	Product name
sku_ember_throw	0	1,711.20	0	0	Ember Knit Throw
sku_halo_lamp	0	2,372.82	0	0	Halo Desk Lamp
sku_petal_mug	160	468.86	0.13	59.50	Petal Stoneware Mug
sku_briar_journal	224	251.74	0.26	65.60	Briar Linen Journal
sku_drift_tee	780	571.20	0.44	252	Drift Cotton Tee
sku_fern_planter	336	239.85	0.49	117	Fern Ceramic Planter
sku_copper_tumbler	552	277.89	0.65	180.55	Copper Travel Tumbler
sku_aurora_candle	666	270.32	0.85	229.40	Aurora Soy Candle 8oz

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

How do you calculate inventory turnover ratio by SKU?

Export your Shopify products, orders, and inventory files, then match them by SKU. Use the last 12 months to calculate sales dollars, average stock value from inventory snapshots, and turnover as cost of sales divided by average stock value. The result is a SKU list ranked slowest first.

How it works

How to use the Shopify SKU Turnover 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.