Warehouse Inventory Movement Log

This dataset provides a granular log of all inventory movements within a warehouse, including item details, movement types, source and destination locations, operator information, and contextual notes. It enables precise tracking of stock flow, supports inventory accuracy analysis, and facilitates workflow optimization for warehouse operations. The dataset is ideal for supply chain analytics, process improvement, and operational auditing.

  • opened 11 times
  • last updated 21 Jul 2025
  • by GoMask
The brief that made it

Inventory accuracy and reconciliation analysis

Sample rows

preview · 8 of 200 rows · all 18 columns
movement_idstringmovement_typestringquantityintegeruomstringtimestampdatetimeitem_idstringitem_namestringskustringbatch_numberstringsource_location_idstringsource_location_namestringdestination_location_idstringdestination_location_namestringoperator_idstringoperator_namestringreference_documentstringmovement_reasonstringcommentsstring
MV000001inbound32pieces2024-03-04T08:19:00ITM-1012Plastic Storage BinSKU-PLB-002BN-202403AblankblankBIN-17CAisle 5, Bin 17COP-003Dana PatelPO-20240302-11replenishmentMorning delivery from supplier
MV000002outbound-5rolls2024-03-04T09:42:15ITM-1045Aluminum Sheet RollSKU-ALM-019ALM-2402-BRACK-2BRack 2BblankblankOP-005Luke ChangSO-20240304-04pickingDispatched for order 1124
MV000003inbound100pieces2024-03-04T10:11:00ITM-1008Corrugated Box LargeSKU-CBX-003blankblankblankBIN-9AAisle 2, Bin 9AOP-001Samantha LeePO-20240302-06replenishmentblank
MV000004outbound-24boxes2024-03-04T10:37:36ITM-1030Packing Tape ClearSKU-PTC-015PTC-20240301BIN-3EAisle 1, Bin 3EblankblankOP-007Jayden BrooksSO-20240304-07pickingFor express shipment
MV000005inbound12pallets2024-03-04T11:02:20ITM-1024Blue PalletSKU-PAL-001blankblankblankDOCK-01Receiving Dock 01OP-009Erika SchmidtPO-20240301-27replenishmentblank
MV000006outbound-6rolls2024-03-04T11:12:43ITM-1010Shrink Wrap FilmSKU-SWF-011SWF-2403CRACK-4CRack 4CblankblankOP-002Miguel RiveraSO-20240304-15pickingblank
MV000007inbound30rolls2024-03-04T11:33:12ITM-1041Bubble Wrap RollSKU-BWR-005BWR-202312BblankblankBIN-8GAisle 2, Bin 8GOP-010Keisha ThomasPO-20240303-08replenishmentblank
MV000008inbound14pieces2024-03-04T12:01:44ITM-1015Plastic CrateSKU-PLC-004blankblankblankBIN-15FAisle 4, Bin 15FOP-003Dana PatelPO-20240303-13replenishmentblank

What the 200 rows show

from the 200-row sample

Outbound (movement type) stands out: mean quantity is -35.5, against 26.2 for the rest.

  • 2median quantity
  • 7movement reasons
  • 41operators
  • 41operator names
quantity200 rows, in bands of 50
045903097390147202-20050300quantity →

Median 2, from -200 to 300.

uom200 rows · top 10 of 14 values
  1. pieces80
  2. boxes43
  3. rolls34
  4. pallets19
  5. sheets6
  6. packs6
  7. bags3
  8. bands2
  9. bottles2
  10. drums1
18 columns by typefrom the column list below
  • string 16
  • integer 1
  • datetime 1

Columns

18 columns in three groups
blueprint · 18 columns
columntypedescriptionexample
Text 16 columns
movement_idstringUnique identifier for each inventory movement eventuniqueMV000001
item_idstringUnique identifier for the inventory item being movedITM-1012
item_namestringDescriptive name of the inventory itemPlastic Storage Bin
skustringStock Keeping Unit code for the itemoptionalSKU-PLB-002
batch_numberstringBatch or lot number for the item, if applicableoptionalBN-202403A
uomstringUnit of measure for the quantity (e.g., pieces, boxes, pallets)pieces
movement_typestringType of inventory movement (e.g., inbound, outbound, transfer, adjustment, return)inbound · outbound · transfer · adjustment · returninbound
source_location_idstringIdentifier for the source warehouse location (e.g., bin, aisle, dock); null if external receiptoptionalRACK-2B
source_location_namestringHuman-readable name of the source locationoptionalRack 2B
destination_location_idstringIdentifier for the destination warehouse location (e.g., bin, aisle, dock); null if external shipmentoptionalBIN-17C
destination_location_namestringHuman-readable name of the destination locationoptionalAisle 5, Bin 17C
operator_idstringIdentifier for the warehouse staff or operator responsible for the movementoptionalOP-003
operator_namestringName of the warehouse staff or operator responsible for the movementoptionalDana Patel
reference_documentstringReference to related document (e.g., purchase order, sales order, transfer order)optionalPO-20240302-11
movement_reasonstringReason for the movement (e.g., replenishment, picking, cycle count, damage, customer return)7 reasons · optionalreplenishment
commentsstringAdditional notes or comments about the movement eventoptionalFor express shipment
Numbers 1 column
quantityintegerNumber of units moved in this transaction (positive for inbound, negative for outbound)32
Dates and times 1 column
timestampdatetimeDate and time when the inventory movement occurred2024-03-04T08:19:00

Use it for

  • median quantity2200 rows

    A logistics dashboard

    Quantity by movement_type and a breakdown of uom. Excel, Power BI or Tableau.

  • Why do the 60 outbound rows have a mean quantity of -35.5?

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

Not quite right?

Make it yours.

Same 18 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 rows18 columns
Yours1,000 rows18 columnssource_location_id: UK only

blueprint · warehouse-inventory-movement-log

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 18 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
  • Each row represents a unique inventory movement event.
  • Includes product ID, quantity, timestamp, and movement type (inbound/outbound/relocation).
  • Links to operator ID for each event.
  • Missing or negative quantities are excluded.
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-log

What should your data show?

Preview 20 rows free
No signup. No card.