Warehouse Inventory Movement Dataset

This dataset provides detailed, timestamped logs of warehouse inventory movements, capturing item identifiers, source and destination locations, movement triggers, and inventory levels before and after each event. It enables comprehensive analysis for process optimization, loss prevention, and predictive modeling in warehouse operations.

  • opened 19 times
  • last updated 20 Aug 2025
  • by GoMask
The brief that made it

Warehouse process optimization and bottleneck analysis

Sample rows

preview · 8 of 200 rows · all 17 columns
movement_idstringtrigger_typestringquantity_movedintegerunit_of_measurestringitem_idstringitem_namestringskustringmovement_datetimedatetimefrom_location_idstringfrom_location_namestringto_location_idstringto_location_namestringtrigger_detailsstringperformed_bystringinventory_level_beforeintegerinventory_level_afterintegermovement_notesstring
MV0001restock1200piecesIT1001UltraSoft Bath TowelsTWL-ULTRA-0012024-01-05T09:12:45LOC-001-WCentral WarehouseLOC-002-BRetail Store DowntownRestock request for Q1 salesemp_100180003200Bulk restock ahead of winter sale
MV0002restock1800bottlesIT1002Premium Liquid SoapSOAP-PRM-0022024-01-07T11:23:58LOC-001-WCentral WarehouseLOC-003-OOutlet Store WestRestock request - West outletemp_100270002800Inventory replenishment for new promotions
MV0003loss1vaseIT1003Ceramic Flower VaseVAS-CERAM-0032024-01-10T14:19:21LOC-002-BRetail Store DowntownLOC-007-RPReturns ProcessingDamaged item returnedemp_1003100Breakage reported by staff
MV0004transfer900packsIT1004Organic Coffee BeansCOF-ORG-0042024-01-12T13:03:44LOC-001-WCentral WarehouseLOC-004-PPartner Store EastRegional transferemp_10044000900Transfer for regional balance
MV0005loss1bottleIT1005Stainless Steel Water BottleBOT-SS-0052024-01-15T16:37:20LOC-003-OOutlet Store WestLOC-007-RPReturns ProcessingCustomer return - damagedemp_100550Returned due to lid breakage
MV0006order_fulfillment500jarsIT1006Luxury Hand CreamCRM-LUX-0062024-01-19T08:45:32LOC-001-WCentral WarehouseLOC-005-RRetail Store RiversideOrder #ORD-2024-015emp_10062500500Fulfillment for Riverside store
MV0007loss1canIT1007Classic Scented CandleCND-CLSC-0072024-01-20T12:41:55LOC-005-RRetail Store RiversideLOC-007-RPReturns ProcessingDamaged during transitemp_100740Candle melted in shipment
MV0008restock110unitsIT1008Refillable Soap DispenserDISP-RFL-0082024-01-21T09:29:36LOC-001-WCentral WarehouseLOC-002-BRetail Store DowntownRestock request for new product lineemp_10081000210Dispenser restock for spring

What the 200 rows show

from the 200-row sample

Restock (trigger type) stands out: mean quantity_moved is 918.3, against 47.1 for the rest.

  • 29.5median quantity_moved
  • 12from locations
  • 16to locations
  • 17from location names
  • 19to location names
  • 160median inventory_level_before
Mean quantity_moved by trigger_type200 rows
05001,000918.3resto…61 rows31.0order…43 rows128.7audit12 rows75.5trans…46 rows1.0loss28 rows16.3other10 rows
quantity_moved200 rows, in bands of 500
0801601532118330202,0003,500quantity_moved →

Median 29.5, from 1 to 3,500.

unit_of_measure200 rows · top 10 of 22 values
  1. pieces36
  2. packs28
  3. bottles27
  4. units26
  5. bars22
  6. jars9
  7. box9
  8. boxes8
  9. bottle5
  10. can5
17 columns by typefrom the column list below
  • string 13
  • integer 3
  • datetime 1

Columns

17 columns in three groups
blueprint · 17 columns
columntypedescriptionexample
Text 13 columns
movement_idstringUnique identifier for each inventory movement eventuniqueMV0001
item_idstringUnique identifier for the item being movedIT1001
item_namestringName or description of the itemUltraSoft Bath Towels
skustringStock Keeping Unit code for the itemoptionalTWL-ULTRA-001
from_location_idstringIdentifier for the location from which the item was moved12 locationsLOC-001-W
from_location_namestringName or description of the source locationoptionalCentral Warehouse
to_location_idstringIdentifier for the location to which the item was movedLOC-002-B
to_location_namestringName or description of the destination locationoptionalRetail Store Downtown
unit_of_measurestringUnit of measure for the item (e.g., pieces, boxes, pallets)pieces
trigger_typestringReason or trigger for the movement (e.g., restock, order fulfillment, audit, transfer, loss)6 valuesrestock
trigger_detailsstringAdditional details about the movement trigger (e.g., order number, audit reference)optionalDamaged item returned
performed_bystringIdentifier or name of the employee or system that performed the movementoptionalemp_1001
movement_notesstringOptional notes or comments about the movement eventoptionalHoliday basket promotion
Numbers 3 columns
quantity_movedintegerNumber of units moved in this event1 or more1200
inventory_level_beforeintegerInventory level of the item at the source location before movement0 or more · optional8000
inventory_level_afterintegerInventory level of the item at the destination location after movement0 or more · optional3200
Dates and times 1 column
movement_datetimedatetimeTimestamp when the inventory movement occurred2024-01-05T09:12:45

15 SQL practice questions for the Warehouse Inventory Movement Dataset

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

    Loss movements list

    Return movement_id, item_name and quantity_moved for every movement where trigger_type is 'loss'. Sort by quantity_moved from highest to lowest, then by movement_id ascending.

    Tables: warehouse_inventory_movement_dataset · your result: 3 columns, 28 rows
  2. 02BeginnerFreeDISTINCT · ORDER BY

    Distinct units of measure

    Return each distinct unit_of_measure found in the data, sorted alphabetically. The result should have one column: unit_of_measure.

    Tables: warehouse_inventory_movement_dataset · your result: 1 columns, 22 rows
  3. 03BeginnerFreeGROUP BY · COUNT

    Movements per trigger type

    Count the movements for each trigger_type. Return trigger_type and movement_count, ordered by movement_count from highest to lowest, then by trigger_type alphabetically.

    Tables: warehouse_inventory_movement_dataset · your result: 2 columns, 6 rows
  1. 04Quantity moved by source locationBeginner
  2. 05Power BI cards: units moved and restocksPower BI
  3. 06Busy destinationsIntermediate
  4. 07Movement size bucketsIntermediate
  5. 08Monthly movement countsIntermediate
  6. 09Triggers above the overall averageIntermediate
  7. 10Power BI bar chart: average quantity by triggerPower BI
  8. 11Top two quantities within each triggerAdvanced
  9. 12Days since previous movement of an itemAdvanced
  10. 13Running total of quantity by monthAdvanced
  11. 14Share of quantity by trigger typeAdvanced
  12. 15Power BI: inventory mismatch anomaliesPower 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

  • median quantit…29.5200 rowsmean quantity moved b…918.3rest…31.0orde…128.7audit75.5tran…

    A logistics dashboard

    Quantity_moved by trigger_type and a breakdown of unit_of_measure. Excel, Power BI or Tableau.

  • Why do the 61 restock rows have a mean quantity_moved of 918.3?

    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 movements with item_id, item_name and sku to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 17 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 rows17 columns
Yours1,000 rows17 columnsfrom_location_id: UK only

blueprint · warehouse-inventory-movement-dataset

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 17 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
  • Item movements timestamped per event
  • Include manual and automated actions
  • Stock level calculations per zone
  • Simulate real-world scanning errors
  • Items are unique per category
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
warehouse-inventory-movement-dataset

What should your data show?

Preview 20 rows free
No signup. No card.