Skip to content
Workflow · Track and forecast · Opening soon

SQL Server inventory reorder report

Export your inventory and recent sales tables from SQL Server, then load both files into the workflow. Match the item keys, bring in the last 30 days of sales, and calculate stock left and reorder flags for each item.

Early access opens shortly. Check back soon.

Someone typed

“build a reorder report from our sql server inventory and sales tables: days of stock left for each item based on the last thirty days of sales, and flag items below their reorder point, items with stock but no sales in thirty days, and items missing a reorder point”

The agent read it as

Build a reorder report from our dbo.Inventory and dbo.SalesLast30 tables: days of stock left for each item based on the last thirty days of sales, and flag items below their reorder point, items with stock but no sales in thirty days, and items missing a reorder point.

What the agent built

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

  1. File
    dbo.Inventory
    CSV export · 25 rows
  2. File
    dbo.SalesLast30
    CSV export · 20 rows
  3. Step
    Make inventory item key
    Step 1
  4. Step
    Make sales item key
    Step 2
  5. Join
    Bring in recent sales
    20 of 25 paired
  6. Step
    Calculate stock and flags
    Step 4
  7. Result
    Inventory Reorder Report
    25 rows
  8. Schedule
    Runs when you say
    Proposed

On the sample files, every step runs and the result has 25 rows.

What you get back

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

Inventory Reorder ReportSample data25 rows
30 sales days
Item codeDescriptionDays of stock leftAverage units sold per dayReorder statusSales statusOn handReorder pointUnits sold in last 30 days
A1011Marker Pen Black Fine·0Missing reorder pointStock with no sales77·0
A1018Barcode Scanner Sleeve·0Missing reorder pointStock with no sales72·0
A1003Packing Tape 48mm Clear12.221.80Below reorder pointSales recorded223554
A1007Corrugated Box 16x12x85.633.20Below reorder pointSales recorded184596
A1014Carton Sealer Tape Dispenser9.640.93Below reorder pointSales recorded93528
A1021Corner Protector Foam150.93Below reorder pointSales recorded144028
A1019Shelf Label Holder 3in·0Reorder point metStock with no sales130700
A1023Shipping Paper 24in Roll·0Reorder point metStock with no sales2101000
A1025Heat Seal Pouch 6x9·0Reorder point metStock with no sales120600
A1001Steel Shelf Bracket 6in25.717Reorder point metSales recorded18060210
A1002Plastic Bin 12qt Blue21.924.33Reorder point metSales recorded9540130
A1004Bubble Mailer 8x10455.33Reorder point metSales recorded24075160
25 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How it works

How to use the Inventory Reorder Report workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Inventory Reorder Report: questions

How do you build a reorder report from SQL Server?
Export your inventory and recent sales tables from SQL Server, then load both files into the workflow. Match the item keys, bring in the last 30 days of sales, and calculate stock left and reorder flags for each item. The report can also show items with stock but no sales in 30 days, and items missing a reorder point.
What export should you use from SQL Server?
Use an export of the tables that hold your inventory and recent sales data. The workflow reads the exported files, then uses the item key to line the rows up.
What happens when a row does not match?
If a row from one file does not find a match in the other file, it stays out of the matched result and can be flagged or reviewed on its own. You can keep unmatched rows visible so you can check missing items or missing data.
How do you change the rules in words?
You change the steps by describing the rule you want, such as which fields to match, which rows to keep, and how to calculate the result. You can also change the flag logic, like what counts as low stock or no recent sales.

Get early access to this workflow

It opens already built and working on sample files. Swap in your own exports to see your result.

Early access opens shortly. Check back soon.

Workflows like this

The number you report every month, rebuilt from the latest export, plus the forecast that follows from it.

All track and forecast workflows →