Supply Chain Inventory Movements
This dataset provides granular, timestamped records of inventory movements across multiple locations, including incoming and outgoing shipments, stockouts, and resulting inventory levels. It enables comprehensive supply chain analysis, demand forecasting, and real-time stockout monitoring, making it valuable for optimizing inventory management and logistics operations.
Sample rows
preview · 8 of 200 rows · all 14 columns| inventory_movement_idstring | movement_typestring | movement_quantityinteger | stockout_flagboolean | supplier_idstring | product_idstring | product_namestring | location_idstring | location_namestring | movement_datetimedatetime | current_inventory_levelinteger | shipment_idstring | customer_idstring | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| IM-00001 | incoming | 8500 | false | SUP-001 | P-10001 | Standard Ballpoint Pen Blue | LOC-001 | Central Warehouse | 2023-01-03T09:13:24Z | 8500 | SHIP-1001 | blank | Routine restock from supplier for Q1 demand |
| IM-00002 | outgoing | -3200 | false | blank | P-10001 | Standard Ballpoint Pen Blue | LOC-001 | Central Warehouse | 2023-01-04T13:44:18Z | 5300 | SHIP-1002 | CUST-0001 | Bulk order for retail partner |
| IM-00003 | outgoing | -5300 | true | blank | P-10001 | Standard Ballpoint Pen Blue | LOC-001 | Central Warehouse | 2023-01-06T11:01:08Z | 0 | SHIP-1003 | CUST-0002 | Unexpected high demand, inventory depleted |
| IM-00004 | incoming | 7200 | false | SUP-002 | P-10002 | A4 Copy Paper 80gsm | LOC-002 | East Distribution | 2023-01-03T10:22:57Z | 7200 | SHIP-1004 | blank | Pallet delivery, eastern region |
| IM-00005 | outgoing | -1000 | false | blank | P-10002 | A4 Copy Paper 80gsm | LOC-002 | East Distribution | 2023-01-05T15:19:12Z | 6200 | SHIP-1005 | CUST-0003 | Contract delivery for office park |
| IM-00006 | stockout | 0 | true | blank | P-10002 | A4 Copy Paper 80gsm | LOC-002 | East Distribution | 2023-01-08T09:05:00Z | 0 | blank | blank | Stockout event - all paper distributed |
| IM-00007 | incoming | 12 | false | SUP-003 | P-10003 | Executive Notepad A5 Lined | LOC-003 | Small Retail Store - Urban | 2023-01-02T08:27:11Z | 12 | SHIP-1006 | blank | Direct delivery, urban retail |
| IM-00008 | outgoing | -7 | false | blank | P-10003 | Executive Notepad A5 Lined | LOC-003 | Small Retail Store - Urban | 2023-01-03T11:32:52Z | 5 | SHIP-1007 | CUST-0004 | Sold during back-to-school promo |
| IM-00009 | stockout | 0 | true | blank | P-10003 | Executive Notepad A5 Lined | LOC-003 | Small Retail Store - Urban | 2023-01-06T18:45:10Z | 0 | blank | blank | Sold out after weekend sales |
| IM-00010 | incoming | 960 | false | SUP-004 | P-10004 | Desk Organizer Metal Mesh | LOC-004 | North Storage Facility | 2023-01-04T08:15:30Z | 960 | SHIP-1008 | blank | Restock for Q1 new inventory |
| IM-00011 | outgoing | -700 | false | blank | P-10004 | Desk Organizer Metal Mesh | LOC-004 | North Storage Facility | 2023-01-05T12:00:00Z | 260 | SHIP-1009 | CUST-0005 | Bulk purchase by business client |
| IM-00012 | incoming | 2200 | false | SUP-005 | P-10005 | Highlighter Set 5 Colors | LOC-002 | East Distribution | 2023-01-07T15:45:17Z | 2200 | SHIP-1010 | blank | Peak season restock |
| IM-00013 | outgoing | -900 | false | blank | P-10005 | Highlighter Set 5 Colors | LOC-002 | East Distribution | 2023-01-08T13:15:43Z | 1300 | SHIP-1011 | CUST-0006 | Department order for local college |
| IM-00014 | outgoing | -1300 | true | blank | P-10005 | Highlighter Set 5 Colors | LOC-002 | East Distribution | 2023-01-10T10:00:00Z | 0 | SHIP-1012 | CUST-0007 | Stock depleted after school campaign |
| IM-00015 | incoming | 300 | false | SUP-006 | P-10006 | Adjustable Desk Lamp White | LOC-005 | South Distribution Center | 2023-01-01T09:01:00Z | 300 | SHIP-1013 | blank | First delivery of new SKU |
| IM-00016 | outgoing | -100 | false | blank | P-10006 | Adjustable Desk Lamp White | LOC-005 | South Distribution Center | 2023-01-03T13:13:00Z | 200 | SHIP-1014 | CUST-0008 | Order for regional reseller |
| IM-00017 | incoming | 110 | false | SUP-007 | P-10007 | Whiteboard Magnetic 120x90cm | LOC-002 | East Distribution | 2023-01-02T14:14:14Z | 110 | SHIP-1015 | blank | Restock for classroom supplies |
| IM-00018 | outgoing | -110 | true | blank | P-10007 | Whiteboard Magnetic 120x90cm | LOC-002 | East Distribution | 2023-01-05T12:44:09Z | 0 | SHIP-1016 | CUST-0009 | Entire lot sold, restock required |
| IM-00019 | incoming | 5 | false | SUP-008 | P-10008 | Premium Stapler Black | LOC-006 | Flagship Megastore | 2023-01-08T10:08:08Z | 5 | SHIP-1017 | blank | Collector’s edition batch |
| IM-00020 | outgoing | -2 | false | blank | P-10008 | Premium Stapler Black | LOC-006 | Flagship Megastore | 2023-01-09T12:22:22Z | 3 | SHIP-1018 | CUST-0010 | VIP customer purchase |
What the 200 rows show
from the 200-row sampleStockout (movement type) stands out: 23 of its 23 rows have stockout_
- 33%stockout_
flag = true - -1median movement_
quantity - 10locations
- 20products
- 21location names
- 57product names
Median -1, from -6,000 to 9,000.
- string 10
- integer 2
- datetime 1
- boolean 1
Columns
14 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 10 columns | |||
inventory_movement_id | string | Unique identifier for each inventory movement recordunique | IM-00001 |
product_id | string | Unique identifier for the product involved in the movement | P-10001 |
product_name | string | Descriptive name of the product | A4 Copy Paper 80gsm |
location_id | string | Unique identifier for the warehouse or storage location10 locations | LOC-001 |
location_name | string | Name or description of the warehouse or storage location | Central Warehouse |
movement_type | string | Type of inventory movement: incoming, outgoing, or stockoutincoming · outgoing · stockout | incoming |
shipment_id | string | Identifier for the associated shipment, if applicableoptional | SHIP-1001 |
supplier_id | string | Unique identifier for the supplier (for incoming movements only)optional | SUP-001 |
customer_id | string | Unique identifier for the customer (for outgoing movements only)optional | CUST-0001 |
notes | string | Additional notes or comments about the movementoptional | Peak season restock |
| Numbers 2 columns | |||
movement_quantity | integer | Number of product units moved (positive for incoming, negative for outgoing, zero for stockout) | 8500 |
current_inventory_level | integer | Inventory level of the product at the location immediately after the movement0 or more | 8500 |
| Dates and times 1 column | |||
movement_datetime | datetime | Timestamp when the inventory movement occurred | 2023-01-03T09:13:24Z |
| True or false 1 column | |||
stockout_flag | boolean | Indicates if the movement resulted in a stockout (true if inventory level is zero after movement) | false |
Use it for
A logistics dashboard
The stockout_
flag rate, movement_ quantity by movement_ type and a breakdown of supplier_ id. Excel, Power BI or Tableau. Why do 65 of 200 rows have stockout_
flag = true? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Inventory movements200IM-000018500incomingIM-00003-5300outgoingIM-000060stockout
A software demo
Believable inventory movements with product_
id, product_ name and location_ id to fill a screen in front of a buyer.
blueprint · supply-chain-inventory-movements
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 14 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
- Include product ID, warehouse, date
- Record quantity in/out, current stock
- Simulate random supply disruptions
- No SKU-level identifiers
1 credit per row. New accounts start with 25 free credits.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- supply-chain-inventory-movements