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.
Sample rows
preview · 8 of 200 rows · all 18 columns| movement_idstring | movement_typestring | quantityinteger | uomstring | timestampdatetime | item_idstring | item_namestring | skustring | batch_numberstring | source_location_idstring | source_location_namestring | destination_location_idstring | destination_location_namestring | operator_idstring | operator_namestring | reference_documentstring | movement_reasonstring | commentsstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MV000001 | inbound | 32 | pieces | 2024-03-04T08:19:00 | ITM-1012 | Plastic Storage Bin | SKU-PLB-002 | BN-202403A | blank | blank | BIN-17C | Aisle 5, Bin 17C | OP-003 | Dana Patel | PO-20240302-11 | replenishment | Morning delivery from supplier |
| MV000002 | outbound | -5 | rolls | 2024-03-04T09:42:15 | ITM-1045 | Aluminum Sheet Roll | SKU-ALM-019 | ALM-2402-B | RACK-2B | Rack 2B | blank | blank | OP-005 | Luke Chang | SO-20240304-04 | picking | Dispatched for order 1124 |
| MV000003 | inbound | 100 | pieces | 2024-03-04T10:11:00 | ITM-1008 | Corrugated Box Large | SKU-CBX-003 | blank | blank | blank | BIN-9A | Aisle 2, Bin 9A | OP-001 | Samantha Lee | PO-20240302-06 | replenishment | blank |
| MV000004 | outbound | -24 | boxes | 2024-03-04T10:37:36 | ITM-1030 | Packing Tape Clear | SKU-PTC-015 | PTC-20240301 | BIN-3E | Aisle 1, Bin 3E | blank | blank | OP-007 | Jayden Brooks | SO-20240304-07 | picking | For express shipment |
| MV000005 | inbound | 12 | pallets | 2024-03-04T11:02:20 | ITM-1024 | Blue Pallet | SKU-PAL-001 | blank | blank | blank | DOCK-01 | Receiving Dock 01 | OP-009 | Erika Schmidt | PO-20240301-27 | replenishment | blank |
| MV000006 | outbound | -6 | rolls | 2024-03-04T11:12:43 | ITM-1010 | Shrink Wrap Film | SKU-SWF-011 | SWF-2403C | RACK-4C | Rack 4C | blank | blank | OP-002 | Miguel Rivera | SO-20240304-15 | picking | blank |
| MV000007 | inbound | 30 | rolls | 2024-03-04T11:33:12 | ITM-1041 | Bubble Wrap Roll | SKU-BWR-005 | BWR-202312B | blank | blank | BIN-8G | Aisle 2, Bin 8G | OP-010 | Keisha Thomas | PO-20240303-08 | replenishment | blank |
| MV000008 | inbound | 14 | pieces | 2024-03-04T12:01:44 | ITM-1015 | Plastic Crate | SKU-PLC-004 | blank | blank | blank | BIN-15F | Aisle 4, Bin 15F | OP-003 | Dana Patel | PO-20240303-13 | replenishment | blank |
| MV000009 | outbound | -90 | pieces | 2024-03-04T12:22:31 | ITM-1009 | Cardboard Sheet | SKU-CBS-009 | CBS-202402E | BIN-10B | Aisle 3, Bin 10B | blank | blank | OP-011 | Thomas Nguyen | SO-20240304-19 | picking | Bulk customer order |
| MV000010 | inbound | 48 | pieces | 2024-03-04T13:05:57 | ITM-1035 | Foam Corner Protector | SKU-FCP-007 | FCP-202401B | blank | blank | BIN-6F | Aisle 1, Bin 6F | OP-009 | Erika Schmidt | PO-20240303-22 | replenishment | blank |
| MV000011 | outbound | -10 | drums | 2024-03-04T13:15:13 | ITM-1021 | Steel Drum 50L | SKU-STD-006 | blank | DOCK-02 | Shipping Dock 02 | blank | blank | OP-004 | Brian McCarthy | SO-20240304-21 | picking | blank |
| MV000012 | inbound | 60 | boxes | 2024-03-04T13:37:20 | ITM-1002 | Small Hardware Box | SKU-SHB-001 | SHB-202403C | blank | blank | BIN-2A | Aisle 1, Bin 2A | OP-012 | Olivia White | PO-20240304-02 | replenishment | blank |
| MV000013 | inbound | 300 | sheets | 2024-03-04T14:00:01 | ITM-1048 | Blue Label Sticker | SKU-LBL-008 | LBL-202403A | blank | blank | BIN-12B | Aisle 3, Bin 12B | OP-006 | Isabella Suarez | PO-20240304-09 | replenishment | blank |
| MV000014 | outbound | -35 | pieces | 2024-03-04T14:33:29 | ITM-1032 | Metal Bracket | SKU-MBR-014 | MBR-202403B | RACK-1A | Rack 1A | blank | blank | OP-008 | Sophie Bauer | SO-20240304-24 | picking | To be delivered by 3pm |
| MV000015 | inbound | 10 | pieces | 2024-03-04T15:11:10 | ITM-1051 | Red Safety Cone | SKU-RSC-002 | blank | blank | blank | BIN-21D | Aisle 6, Bin 21D | OP-010 | Keisha Thomas | PO-20240304-14 | replenishment | Safety stock |
| MV000016 | outbound | -200 | pieces | 2024-03-04T15:18:55 | ITM-1011 | White Poly Mailer | SKU-WPM-013 | WPM-202403D | BIN-18E | Aisle 5, Bin 18E | blank | blank | OP-002 | Miguel Rivera | SO-20240304-27 | picking | blank |
| MV000017 | inbound | 15 | boxes | 2024-03-04T15:35:07 | ITM-1013 | Packing List Envelope | SKU-PLE-002 | blank | blank | blank | BIN-4C | Aisle 2, Bin 4C | OP-011 | Thomas Nguyen | PO-20240304-20 | replenishment | blank |
| MV000018 | inbound | 36 | rolls | 2024-03-04T15:41:29 | ITM-1039 | Stretch Film Roll | SKU-SFR-010 | SFR-202403A | blank | blank | BIN-14D | Aisle 4, Bin 14D | OP-012 | Olivia White | PO-20240304-25 | replenishment | blank |
| MV000019 | outbound | -7 | boxes | 2024-03-04T15:55:17 | ITM-1017 | Black Utility Knife | SKU-BUK-007 | blank | BIN-7B | Aisle 2, Bin 7B | blank | blank | OP-001 | Samantha Lee | SO-20240304-32 | picking | blank |
| MV000020 | inbound | 80 | rolls | 2024-03-04T16:13:36 | ITM-1052 | Brown Kraft Paper | SKU-BKP-003 | BKP-202402C | blank | blank | BIN-3B | Aisle 1, Bin 3B | OP-004 | Brian McCarthy | PO-20240304-33 | replenishment | blank |
What the 200 rows show
from the 200-row sampleOutbound (movement type) stands out: mean quantity is -35.5, against 26.2 for the rest.
- 2median quantity
- 7movement reasons
- 41operators
- 41operator names
Median 2, from -200 to 300.
- string 16
- integer 1
- datetime 1
Columns
18 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 16 columns | |||
movement_id | string | Unique identifier for each inventory movement eventunique | MV000001 |
item_id | string | Unique identifier for the inventory item being moved | ITM-1012 |
item_name | string | Descriptive name of the inventory item | Plastic Storage Bin |
sku | string | Stock Keeping Unit code for the itemoptional | SKU-PLB-002 |
batch_number | string | Batch or lot number for the item, if applicableoptional | BN-202403A |
uom | string | Unit of measure for the quantity (e.g., pieces, boxes, pallets) | pieces |
movement_type | string | Type of inventory movement (e.g., inbound, outbound, transfer, adjustment, return)inbound · outbound · transfer · adjustment · return | inbound |
source_location_id | string | Identifier for the source warehouse location (e.g., bin, aisle, dock); null if external receiptoptional | RACK-2B |
source_location_name | string | Human-readable name of the source locationoptional | Rack 2B |
destination_location_id | string | Identifier for the destination warehouse location (e.g., bin, aisle, dock); null if external shipmentoptional | BIN-17C |
destination_location_name | string | Human-readable name of the destination locationoptional | Aisle 5, Bin 17C |
operator_id | string | Identifier for the warehouse staff or operator responsible for the movementoptional | OP-003 |
operator_name | string | Name of the warehouse staff or operator responsible for the movementoptional | Dana Patel |
reference_document | string | Reference to related document (e.g., purchase order, sales order, transfer order)optional | PO-20240302-11 |
movement_reason | string | Reason for the movement (e.g., replenishment, picking, cycle count, damage, customer return)7 reasons · optional | replenishment |
comments | string | Additional notes or comments about the movement eventoptional | For express shipment |
| Numbers 1 column | |||
quantity | integer | Number of units moved in this transaction (positive for inbound, negative for outbound) | 32 |
| Dates and times 1 column | |||
timestamp | datetime | Date and time when the inventory movement occurred | 2024-03-04T08:19:00 |
Use it for
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.
- Movements200MV00000132inboundMV000002-5outboundMV000003100inbound
A software demo
Believable movements with timestamp, item_
id and item_ name to fill a screen in front of a buyer.
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.
- 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.
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