SQL Server inventory reorder report
“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”
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.
- Filedbo.InventoryCSV export · 25 rows
- Filedbo.SalesLast30CSV export · 20 rows
- StepMake inventory item keyStep 1
- StepMake sales item keyStep 2
- JoinBring in recent sales20 of 25 paired
- StepCalculate stock and flagsStep 4
- ResultInventory Reorder Report25 rows
- ScheduleRuns when you sayProposed
On the sample files, every step runs and the result has 25 rows.
- Download dbo.Inventory sample (25 rows)SQL Server: Database > Tables > dbo.Inventory > Select Rows > Results to Grid > Copy with Headers
- Download dbo.SalesLast30 sample (20 rows)SQL Server: Database > Tables > dbo.SalesLast30 > Select Rows > Results to Grid > Copy with Headers
What you get back
The result of that run, the rows to look at first.
| Item code | Description | Days of stock left | Average units sold per day | Reorder status | Sales status | On hand | Reorder point | Units sold in last 30 days |
|---|---|---|---|---|---|---|---|---|
| A1011 | Marker Pen Black Fine | · | 0 | Missing reorder point | Stock with no sales | 77 | · | 0 |
| A1018 | Barcode Scanner Sleeve | · | 0 | Missing reorder point | Stock with no sales | 72 | · | 0 |
| A1003 | Packing Tape 48mm Clear | 12.22 | 1.80 | Below reorder point | Sales recorded | 22 | 35 | 54 |
| A1007 | Corrugated Box 16x12x8 | 5.63 | 3.20 | Below reorder point | Sales recorded | 18 | 45 | 96 |
| A1014 | Carton Sealer Tape Dispenser | 9.64 | 0.93 | Below reorder point | Sales recorded | 9 | 35 | 28 |
| A1021 | Corner Protector Foam | 15 | 0.93 | Below reorder point | Sales recorded | 14 | 40 | 28 |
| A1019 | Shelf Label Holder 3in | · | 0 | Reorder point met | Stock with no sales | 130 | 70 | 0 |
| A1023 | Shipping Paper 24in Roll | · | 0 | Reorder point met | Stock with no sales | 210 | 100 | 0 |
| A1025 | Heat Seal Pouch 6x9 | · | 0 | Reorder point met | Stock with no sales | 120 | 60 | 0 |
| A1001 | Steel Shelf Bracket 6in | 25.71 | 7 | Reorder point met | Sales recorded | 180 | 60 | 210 |
| A1002 | Plastic Bin 12qt Blue | 21.92 | 4.33 | Reorder point met | Sales recorded | 95 | 40 | 130 |
| A1004 | Bubble Mailer 8x10 | 45 | 5.33 | Reorder point met | Sales recorded | 240 | 75 | 160 |
How it works
How to use the Inventory Reorder Report workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on 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.
Inventory Reorder Report: questions
How do you build a reorder report from SQL Server?
What export should you use from SQL Server?
What happens when a row does not match?
How do you change the rules in words?
Get early access to this workflow
It opens already built and working on sample files. Swap in your own exports to see your result.
Workflows like this
The number you report every month, rebuilt from the latest export, plus the forecast that follows from it.
- Customer lifetime value by cohortWork out customer lifetime value by signup month cohort from Shopify customers and orders exports, with revenue per customer and average order count.See the workflow Built by the agent
- Profit and loss by monthBuild a monthly profit and loss statement from a QuickBooks general ledger export, with revenue, COGS, gross profit, expenses, and net income.See the workflow Built by the agent
- Pareto (ABC) analysisEvery item ranked by its total, with its share, the running share and an A, B or C classSee the workflow Template
- Inventory turnover by SKURank Shopify SKUs by inventory turnover ratio using product, order, and inventory exports from the last 12 months.See the workflow Built by the agent
- Cohort retentionEach month's new customers, and the share still buying 1, 2, 3… months laterSee the workflow Template
- Customer segmentation by revenueSegment Stripe customers into revenue tiers from exported customer, charge, and threshold files, then count customers and revenue in each tier.See the workflow Built by the agent