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

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

10,000 rows of yours: $12.99One-time. No subscription. All prices

This dataset200 rows17 columns
Yours10,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. New accounts start with 25 free credits.

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.