Workflow · Stock and products · Opening soon

Slow moving inventory

See which items are moving slowly, using your NetSuite item list and recent sales export. Mammoth totals units sold, matches each item, and shows stock on hand and inventory value.

Book a demo

Someone typed

“join the netsuite item list with the netsuite item sales last 90 days, total units sold per item, show on hand and inventory value, and mark status Agrees when sold 5 or more, otherwise Slow mover”

The agent read it as

Join the NetSuite item list with the NetSuite item sales last 90 days, total units sold per item, show on hand and inventory value, and mark status Agrees when sold 5 or more, otherwise Slow mover

What the agent built

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

File

NetSuite item list

CSV export · 10 rows

File

NetSuite item sales last 90 days

CSV export · 28 rows

Step

Total units sold per item

Step 1

Step

Make item match key

Step 2

Join

Bring in units sold

8 of 10 paired

Step

Mark sales status

Step 4

Result

Item Sales Status

10 rows · 6 flagged

Schedule

Runs when you say

Proposed

File
NetSuite item list
CSV export · 10 rows
File
NetSuite item sales last 90 days
CSV export · 28 rows
Step
Make item match key
Step 2
Step
Total units sold per item
Step 1
Join
Bring in units sold
8 of 10 paired
Step
Mark sales status
Step 4
Result
Item Sales Status
10 rows · 6 flagged
Schedule
Runs when you say
Proposed

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

Download NetSuite item list sample (10 rows)NetSuite: Lists > Accounting > Items > Export
Download NetSuite item sales last 90 days sample (28 rows)NetSuite: Reports > Sales > Sales by Item > Export (date filter: last 90 days)

What you get back

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

Item Sales StatusSample data10 rows

4 agrees6 slow mover

Item	Units sold	On hand	Inventory value	Status
sku_aurora_mug	2	18	135	Slow mover
sku_boreal_tote	4	60	555	Slow mover
sku_delta_notebook	0	48	326.40	Slow mover
sku_fjord_lamp	3	34	637.50	Slow mover
sku_harbor_frame	0	32	259.20	Slow mover
sku_jade_pen	4	25	140	Slow mover
sku_cedar_candle	10	22	250.80	Agrees
sku_ember_bottle	7	11	163.90	Agrees
sku_grove_planter	6	16	211.20	Agrees
sku_isle_throw	8	9	216	Agrees

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

How do you find slow moving inventory?

Export your NetSuite item list and your item sales for the last 90 days. Mammoth totals units sold per item, joins the files, and marks each item as Agrees when it sold 5 or more units, otherwise Slow mover.

How it works

How to use the Item Sales Status 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.

Item Sales Status: questions

What export should you use?

Use an item list export with stock on hand and inventory value, plus an item sales export for the last 90 days.

What happens to rows that do not match?

Rows that do not find a match in the other file stay in the result if they are part of the source export, but matched fields will be blank where no row is found.

How do you change the rule from Slow mover to Agrees?

Edit the rule in words to change the cutoff, for example sold fewer than 5 units, or use a different status label for items above or below your threshold.