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.
Sample rows
preview · 8 of 200 rows · all 17 columns| movement_idstring | trigger_typestring | quantity_movedinteger | unit_of_measurestring | item_idstring | item_namestring | skustring | movement_datetimedatetime | from_location_idstring | from_location_namestring | to_location_idstring | to_location_namestring | trigger_detailsstring | performed_bystring | inventory_level_beforeinteger | inventory_level_afterinteger | movement_notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MV0001 | restock | 1200 | pieces | IT1001 | UltraSoft Bath Towels | TWL-ULTRA-001 | 2024-01-05T09:12:45 | LOC-001-W | Central Warehouse | LOC-002-B | Retail Store Downtown | Restock request for Q1 sales | emp_1001 | 8000 | 3200 | Bulk restock ahead of winter sale |
| MV0002 | restock | 1800 | bottles | IT1002 | Premium Liquid Soap | SOAP-PRM-002 | 2024-01-07T11:23:58 | LOC-001-W | Central Warehouse | LOC-003-O | Outlet Store West | Restock request - West outlet | emp_1002 | 7000 | 2800 | Inventory replenishment for new promotions |
| MV0003 | loss | 1 | vase | IT1003 | Ceramic Flower Vase | VAS-CERAM-003 | 2024-01-10T14:19:21 | LOC-002-B | Retail Store Downtown | LOC-007-RP | Returns Processing | Damaged item returned | emp_1003 | 10 | 0 | Breakage reported by staff |
| MV0004 | transfer | 900 | packs | IT1004 | Organic Coffee Beans | COF-ORG-004 | 2024-01-12T13:03:44 | LOC-001-W | Central Warehouse | LOC-004-P | Partner Store East | Regional transfer | emp_1004 | 4000 | 900 | Transfer for regional balance |
| MV0005 | loss | 1 | bottle | IT1005 | Stainless Steel Water Bottle | BOT-SS-005 | 2024-01-15T16:37:20 | LOC-003-O | Outlet Store West | LOC-007-RP | Returns Processing | Customer return - damaged | emp_1005 | 5 | 0 | Returned due to lid breakage |
| MV0006 | order_fulfillment | 500 | jars | IT1006 | Luxury Hand Cream | CRM-LUX-006 | 2024-01-19T08:45:32 | LOC-001-W | Central Warehouse | LOC-005-R | Retail Store Riverside | Order #ORD-2024-015 | emp_1006 | 2500 | 500 | Fulfillment for Riverside store |
| MV0007 | loss | 1 | can | IT1007 | Classic Scented Candle | CND-CLSC-007 | 2024-01-20T12:41:55 | LOC-005-R | Retail Store Riverside | LOC-007-RP | Returns Processing | Damaged during transit | emp_1007 | 4 | 0 | Candle melted in shipment |
| MV0008 | restock | 110 | units | IT1008 | Refillable Soap Dispenser | DISP-RFL-008 | 2024-01-21T09:29:36 | LOC-001-W | Central Warehouse | LOC-002-B | Retail Store Downtown | Restock request for new product line | emp_1008 | 1000 | 210 | Dispenser restock for spring |
| MV0009 | transfer | 30 | packs | IT1009 | Holiday Gift Basket | GBSKT-HOL-009 | 2024-01-22T17:13:11 | LOC-004-P | Partner Store East | LOC-005-R | Retail Store Riverside | Special event transfer | emp_1009 | 210 | 60 | Holiday basket promotion |
| MV0010 | transfer | 10 | pieces | IT1010 | Eco-Friendly Tote Bag | blank | 2024-01-23T10:22:58 | LOC-002-B | Retail Store Downtown | LOC-003-O | Outlet Store West | Inventory shuffle | emp_1010 | 50 | 30 | SKU not assigned; tote bag shuffle |
| MV0011 | restock | 200 | bars | IT1011 | Handcrafted Soap Bars | SOAP-HCFT-011 | 2024-01-25T15:36:18 | LOC-001-W | Central Warehouse | LOC-002-B | Retail Store Downtown | Restock request | emp_1011 | 1200 | 400 | Soap bars for new season |
| MV0012 | loss | 1 | bottle | IT1012 | Reusable Water Bottle | BOT-RSB-012 | 2024-01-28T08:14:49 | LOC-003-O | Outlet Store West | LOC-007-RP | Returns Processing | Customer return | emp_1012 | 15 | 0 | Returned for leakage |
| MV0013 | transfer | 25 | pieces | IT1001 | UltraSoft Bath Towels | TWL-ULTRA-001 | 2024-01-30T13:27:32 | LOC-002-B | Retail Store Downtown | LOC-003-O | Outlet Store West | Outlet redistribution | emp_1013 | 3200 | 50 | Redistribution for new collection |
| MV0014 | restock | 500 | packs | IT1013 | Scented Wax Melts | WMELT-SC-013 | 2024-02-02T10:03:07 | LOC-001-W | Central Warehouse | LOC-002-B | Retail Store Downtown | Restock request | emp_1014 | 3000 | 700 | Inventory boost for Valentine's promotion |
| MV0015 | loss | 1 | box | IT1014 | Spa Gift Set | SPA-GIFT-014 | 2024-02-04T13:55:36 | LOC-002-B | Retail Store Downtown | LOC-007-RP | Returns Processing | Damaged gift set | emp_1015 | 8 | 0 | Spa set written off |
| MV0016 | order_fulfillment | 2 | units | IT1015 | All-Natural Face Mask | MASK-NAT-015 | 2024-02-07T16:49:20 | LOC-004-P | Partner Store East | LOC-002-B | Retail Store Downtown | Order #ORD-2024-026 | emp_1016 | 21 | 2 | Online order for Downtown pickup |
| MV0017 | restock | 700 | packs | IT1016 | Herbal Tea Sampler | TEA-HERB-016 | 2024-02-09T11:28:02 | LOC-001-W | Central Warehouse | LOC-004-P | Partner Store East | Restock request | emp_1017 | 3200 | 1000 | Restocking for spring teas |
| MV0018 | order_fulfillment | 50 | pieces | IT1017 | Microfiber Cleaning Cloth | CLTH-MF-017 | 2024-02-11T14:17:29 | LOC-001-W | Central Warehouse | LOC-003-O | Outlet Store West | Order #ORD-2024-041 | emp_1018 | 400 | 60 | Outlet order for cleaning supplies |
| MV0019 | transfer | 12 | packs | IT1018 | Aromatherapy Oil Set | OIL-AROM-018 | 2024-02-14T10:05:49 | LOC-002-B | Retail Store Downtown | LOC-003-O | Outlet Store West | Outlet inventory balance | emp_1019 | 150 | 36 | Transfer to support spring events |
| MV0020 | restock | 1500 | pieces | IT1019 | Bamboo Toothbrush | TB-BAMBOO-019 | 2024-02-17T09:53:32 | LOC-001-W | Central Warehouse | LOC-005-R | Retail Store Riverside | Restock Q1 | emp_1020 | 7000 | 2200 | Bulk restock for eco campaign |
What the 200 rows show
from the 200-row sampleRestock (trigger type) stands out: mean quantity_
- 29.5median quantity_
moved - 12from locations
- 16to locations
- 17from location names
- 19to location names
- 160median inventory_
level_ before
Median 29.5, from 1 to 3,500.
- string 13
- integer 3
- datetime 1
Columns
17 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 13 columns | |||
movement_id | string | Unique identifier for each inventory movement eventunique | MV0001 |
item_id | string | Unique identifier for the item being moved | IT1001 |
item_name | string | Name or description of the item | UltraSoft Bath Towels |
sku | string | Stock Keeping Unit code for the itemoptional | TWL-ULTRA-001 |
from_location_id | string | Identifier for the location from which the item was moved12 locations | LOC-001-W |
from_location_name | string | Name or description of the source locationoptional | Central Warehouse |
to_location_id | string | Identifier for the location to which the item was moved | LOC-002-B |
to_location_name | string | Name or description of the destination locationoptional | Retail Store Downtown |
unit_of_measure | string | Unit of measure for the item (e.g., pieces, boxes, pallets) | pieces |
trigger_type | string | Reason or trigger for the movement (e.g., restock, order fulfillment, audit, transfer, loss)6 values | restock |
trigger_details | string | Additional details about the movement trigger (e.g., order number, audit reference)optional | Damaged item returned |
performed_by | string | Identifier or name of the employee or system that performed the movementoptional | emp_1001 |
movement_notes | string | Optional notes or comments about the movement eventoptional | Holiday basket promotion |
| Numbers 3 columns | |||
quantity_moved | integer | Number of units moved in this event1 or more | 1200 |
inventory_level_before | integer | Inventory level of the item at the source location before movement0 or more · optional | 8000 |
inventory_level_after | integer | Inventory level of the item at the destination location after movement0 or more · optional | 3200 |
| Dates and times 1 column | |||
movement_datetime | datetime | Timestamp when the inventory movement occurred | 2024-01-05T09:12:45 |
Use it for
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.
- Movements200MV00011200restockMV00021800restockMV00031loss
A software demo
Believable movements with item_
id, item_ name and sku to fill a screen in front of a buyer.
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.
- 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
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