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.

  • opened 16 times
  • last updated 12 Jul 2025
  • by GoMask
The brief that made it

Real-time inventory tracking and stockout prevention

Sample rows

preview · 8 of 200 rows · all 14 columns
inventory_movement_idstringmovement_typestringmovement_quantityintegerstockout_flagbooleansupplier_idstringproduct_idstringproduct_namestringlocation_idstringlocation_namestringmovement_datetimedatetimecurrent_inventory_levelintegershipment_idstringcustomer_idstringnotesstring
IM-00001incoming8500falseSUP-001P-10001Standard Ballpoint Pen BlueLOC-001Central Warehouse2023-01-03T09:13:24Z8500SHIP-1001blankRoutine restock from supplier for Q1 demand
IM-00002outgoing-3200falseblankP-10001Standard Ballpoint Pen BlueLOC-001Central Warehouse2023-01-04T13:44:18Z5300SHIP-1002CUST-0001Bulk order for retail partner
IM-00003outgoing-5300trueblankP-10001Standard Ballpoint Pen BlueLOC-001Central Warehouse2023-01-06T11:01:08Z0SHIP-1003CUST-0002Unexpected high demand, inventory depleted
IM-00004incoming7200falseSUP-002P-10002A4 Copy Paper 80gsmLOC-002East Distribution2023-01-03T10:22:57Z7200SHIP-1004blankPallet delivery, eastern region
IM-00005outgoing-1000falseblankP-10002A4 Copy Paper 80gsmLOC-002East Distribution2023-01-05T15:19:12Z6200SHIP-1005CUST-0003Contract delivery for office park
IM-00006stockout0trueblankP-10002A4 Copy Paper 80gsmLOC-002East Distribution2023-01-08T09:05:00Z0blankblankStockout event - all paper distributed
IM-00007incoming12falseSUP-003P-10003Executive Notepad A5 LinedLOC-003Small Retail Store - Urban2023-01-02T08:27:11Z12SHIP-1006blankDirect delivery, urban retail
IM-00008outgoing-7falseblankP-10003Executive Notepad A5 LinedLOC-003Small Retail Store - Urban2023-01-03T11:32:52Z5SHIP-1007CUST-0004Sold during back-to-school promo

What the 200 rows show

from the 200-row sample

Stockout (movement type) stands out: 23 of its 23 rows have stockout_flag = true, against 42 of 177 for the rest.

  • 33%stockout_flag = true
  • -1median movement_quantity
  • 10locations
  • 20products
  • 21location names
  • 57product names
Stockout flag rate by movement_typestockout_flag = true
0%50%100%0%incoming0 of 7742%outgoing42 of 100100%stockout23 of 23
movement_quantity200 rows, in bands of 2,000
0501003592895312-6,0002,00010kmovement_quantity →

Median -1, from -6,000 to 9,000.

supplier_id77 rows with a value · 123 left blank
  1. SUP-0106
  2. SUP-0116
  3. SUP-0145
  4. SUP-0024
  5. SUP-0034
  6. SUP-0044
  7. SUP-0074
  8. SUP-0094
  9. SUP-0124
  10. SUP-0134
14 columns by typefrom the column list below
  • string 10
  • integer 2
  • datetime 1
  • boolean 1

Columns

14 columns in four groups
blueprint · 14 columns
columntypedescriptionexample
Text 10 columns
inventory_movement_idstringUnique identifier for each inventory movement recorduniqueIM-00001
product_idstringUnique identifier for the product involved in the movementP-10001
product_namestringDescriptive name of the productA4 Copy Paper 80gsm
location_idstringUnique identifier for the warehouse or storage location10 locationsLOC-001
location_namestringName or description of the warehouse or storage locationCentral Warehouse
movement_typestringType of inventory movement: incoming, outgoing, or stockoutincoming · outgoing · stockoutincoming
shipment_idstringIdentifier for the associated shipment, if applicableoptionalSHIP-1001
supplier_idstringUnique identifier for the supplier (for incoming movements only)optionalSUP-001
customer_idstringUnique identifier for the customer (for outgoing movements only)optionalCUST-0001
notesstringAdditional notes or comments about the movementoptionalPeak season restock
Numbers 2 columns
movement_quantityintegerNumber of product units moved (positive for incoming, negative for outgoing, zero for stockout)8500
current_inventory_levelintegerInventory level of the product at the location immediately after the movement0 or more8500
Dates and times 1 column
movement_datetimedatetimeTimestamp when the inventory movement occurred2023-01-03T09:13:24Z
True or false 1 column
stockout_flagbooleanIndicates if the movement resulted in a stockout (true if inventory level is zero after movement)false

15 SQL practice questions for the Supply Chain Inventory Movements

Written for this data and checked against it: 12 SQL and 3 Power BI exercises from beginner to advanced. Try the first three free; the practice kit has all 15, a starter .sql file and an answer key with every expected result.

  1. 01BeginnerFreeSELECT · WHERE · ORDER BY

    Stockout movements list

    List every movement flagged as a stockout (stockout_flag = 1). Return the columns inventory_movement_id, product_id, location_id, movement_quantity and movement_datetime. Order the rows by movement_datetime ascending, then by inventory_movement_id.

    Tables: supply_chain_inventory_movements · your result: 5 columns, 65 rows
  2. 02BeginnerFreeDISTINCT · ORDER BY

    Distinct locations

    Return each distinct combination of location_id and location_name. Return the columns location_id and location_name, ordered by location_id and then location_name.

    Tables: supply_chain_inventory_movements · your result: 2 columns, 21 rows
  3. 03BeginnerFreeGROUP BY · COUNT

    Movements per type

    Count how many movements exist for each movement_type. Return the columns movement_type and movement_count, ordered by movement_count from highest to lowest, then by movement_type.

    Tables: supply_chain_inventory_movements · your result: 2 columns, 3 rows
  1. 04Incoming quantity by locationBeginner
  2. 05Card: total units shipped outPower BI
  3. 06Products with repeated stockoutsIntermediate
  4. 07Movement size bucketsIntermediate
  5. 08Monthly movement countsIntermediate
  6. 09Locations above average inventoryIntermediate
  7. 10Matrix: movements by type and yearPower BI
  8. 11Rank products by outgoing volumeAdvanced
  9. 12Days since previous movementAdvanced
  10. 13Running net quantity per locationAdvanced
  11. 14Share of incoming by locationAdvanced
  12. 15Percent of total incoming by locationPower BI

Get the practice kit: the full dataset, all 15 exercises, a starter .sql and the answer key. One-time $3.99.

Get the practice kit · $3.99

Use it for

  • stockout flag33%65 of 200 rowsstockout flag by move…0%incomi…42%outgoi…100%stocko…

    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.

  • A software demo

    Believable inventory movements with product_id, product_name and location_id to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 14 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset200 rows14 columns
Yours1,000 rows14 columnslocation_id: UK only

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.

Rules it was built with
  • Include product ID, warehouse, date
  • Record quantity in/out, current stock
  • Simulate random supply disruptions
  • No SKU-level identifiers
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
supply-chain-inventory-movements

What should your data show?

Preview 20 rows free
No signup. No card.