Stock Movements
This dataset provides detailed logs of inventory stock movements, including inbound, outbound, transfers, and adjustments, with full traceability of quantities, reasons, timestamps, and warehouse locations. It enables robust tracking of inventory flows, supports audit trails, and facilitates optimization of warehouse operations and supply chain management.
Sample rows
preview · 8 of 200 rows · all 24 columns| movement_idstring | movement_typestring | quantityinteger | destination_citystring | item_idstring | item_namestring | unit_of_measurestring | reason_codestring | timestampdatetime | warehouse_idstring | warehouse_namestring | location_street_addressstring | location_citystring | location_statestring | location_postal_codestring | location_countrystring | destination_warehouse_idstring | destination_warehouse_namestring | destination_street_addressstring | destination_statestring | destination_postal_codestring | destination_countrystring | user_idstring | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MVMT001 | inbound | 500 | blank | SKU-A1234 | Widget Pro - Blue - 10cm | pieces | restock | 2023-03-15T09:15:00Z | WH-US-01 | New York Central | 123 Broadway Ave | New York | NY | 10001 | USA | blank | blank | blank | blank | blank | blank | USR101 | Routine replenishment from supplier |
| MVMT002 | outbound | 48 | blank | SKU-B4321 | Gadget Lite - Red - 7cm | pieces | sale | 2024-01-08T12:45:00Z | WH-UK-03 | London East Depot | 44 King St | London | London | EC1A 1BB | UK | blank | blank | blank | blank | blank | blank | USR102 | Online order #18421 shipped |
| MVMT003 | transfer | 150 | Marseille | SKU-C2103 | Toolset Max - Black - 25pcs | boxes | stock_rebalance | 2023-10-02T16:22:00Z | WH-FR-01 | Paris North Hub | 12 Rue Lafayette | Paris | Île-de-France | 75010 | France | WH-FR-02 | Marseille South Hub | 5 Quai de la Joliette | Provence | 13002 | France | USR103 | Regional transfer for Q4 sales |
| MVMT004 | adjustment | 7 | blank | SKU-D1209 | Accessory Pack - Green - Large | pieces | damage | 2023-07-21T13:00:00Z | WH-US-02 | Chicago Midwest | 789 Lake Shore Dr | Chicago | IL | 60611 | USA | blank | blank | blank | blank | blank | blank | USR104 | Damaged during unloading |
| MVMT005 | inbound | 1200 | blank | SKU-E3333 | Bottle Cooler - Silver - 2L | pieces | restock | 2024-04-05T08:30:00Z | WH-AU-01 | Sydney Main | 225 Pitt St | Sydney | NSW | 2000 | Australia | blank | blank | blank | blank | blank | blank | USR105 | Bulk restock for autumn |
| MVMT006 | outbound | 5 | blank | SKU-F2781 | Mini Widget - Yellow - 5cm | packs | promotion | 2023-11-15T17:10:00Z | WH-NL-01 | Amsterdam Center | 19 Damrak | Amsterdam | North Holland | 1012LG | Netherlands | blank | blank | blank | blank | blank | blank | USR106 | Store opening giveaway |
| MVMT007 | transfer | 80 | Osaka | SKU-G1842 | Gizmo Pack - Orange - XL | units | urgent_order_fulfillment | 2022-12-03T11:30:00Z | WH-JP-01 | Tokyo Bay | 2-1-1 Odaiba | Tokyo | Tokyo | 135-0091 | Japan | WH-JP-02 | Osaka East | 34 Namba St | Osaka | 542-0076 | Japan | USR107 | Immediate shipment for customer order |
| MVMT008 | outbound | 99 | blank | SKU-H6572 | Smart Tool - White - Medium | pieces | charity_donation | 2023-09-29T14:30:00Z | WH-US-03 | Miami Hub | 808 Ocean Dr | Miami | FL | 33139 | USA | blank | blank | blank | blank | blank | blank | USR108 | Donated to local charity |
| MVMT009 | inbound | 750 | blank | SKU-I7711 | Widget Pro - Black - 12cm | boxes | restock | 2024-02-18T10:20:00Z | WH-CH-01 | Shanghai Port | 88 Bund Rd | Shanghai | Shanghai | 200002 | China | blank | blank | blank | blank | blank | blank | USR109 | Shipment from overseas supplier |
| MVMT010 | adjustment | 2 | blank | SKU-J1119 | Gadget Lite - Silver - 8cm | pairs | inventory_count | 2023-06-22T07:10:00Z | WH-US-04 | Boston North | 67 Cambridge Rd | Boston | MA | 02114 | USA | blank | blank | blank | blank | blank | blank | USR110 | Stocktake variance detected |
| MVMT011 | transfer | 25 | Barcelona | SKU-K5782 | Accessory Pack - Red - Small | pieces | seasonal_stock_redistribution | 2023-01-15T09:50:00Z | WH-ES-01 | Madrid Central | 30 Gran Via | Madrid | Madrid | 28013 | Spain | WH-ES-02 | Barcelona West | 55 Carrer de la Marina | Catalonia | 08005 | Spain | USR111 | Preparing for spring promotion |
| MVMT012 | inbound | 220 | blank | SKU-L8123 | Bottle Cooler - Blue - 1.5L | pieces | restock | 2023-10-27T11:13:00Z | WH-IN-01 | Mumbai Gateway | 101 Gateway Rd | Mumbai | Maharashtra | 400001 | India | blank | blank | blank | blank | blank | blank | USR112 | Restock after Diwali sale |
| MVMT013 | outbound | 15 | blank | SKU-M5421 | Widget Pro - Green - 11cm | pieces | sample_giveaway | 2023-03-18T16:40:00Z | WH-US-05 | San Francisco Bay | 210 Market St | San Francisco | CA | 94105 | USA | blank | blank | blank | blank | blank | blank | USR113 | Sample giveaway at tech expo |
| MVMT014 | transfer | 120 | Abu Dhabi | SKU-N3912 | Gizmo Pack - Blue - Medium | pieces | sample_review | 2024-03-29T15:00:00Z | WH-UAE-01 | Dubai Logistics | 12 Sheikh Zayed Rd | Dubai | Dubai | 00000 | UAE | WH-UAE-02 | Abu Dhabi Storage | 45 Corniche Rd | Abu Dhabi | 11111 | UAE | USR114 | Review for new client proposal |
| MVMT015 | inbound | 60 | blank | SKU-O4582 | Toolset Max - Silver - 50pcs | boxes | restock | 2022-06-25T19:45:00Z | WH-UK-01 | Manchester Main | 100 Oxford Rd | Manchester | London | M13 9PG | UK | blank | blank | blank | blank | blank | blank | USR115 | Routine supplier order |
| MVMT016 | outbound | 1 | blank | SKU-P1423 | Gadget Lite - Black - 6cm | bottle | system_test | 1970-01-01T00:00:00Z | WH-US-01 | New York Central | 123 Broadway Ave | New York | NY | 10001 | USA | blank | blank | blank | blank | blank | blank | USR999 | Edge case: epoch time outbound |
| MVMT017 | adjustment | 99999 | blank | SKU-Q8932 | Accessory Pack - White - XL | pieces | audit_discrepancy | 2021-06-10T10:00:00Z | WH-US-02 | Chicago Midwest | 789 Lake Shore Dr | Chicago | IL | 60611 | USA | blank | blank | blank | blank | blank | blank | USR777 | Edge case: max quantity adjustment |
| MVMT018 | inbound | 9999 | blank | SKU-R5721 | Widget Pro - Silver - 14cm | pieces | restock | 2023-12-25T11:00:00Z | WH-ES-01 | Madrid Central | 30 Gran Via | Madrid | Madrid | 28013 | Spain | blank | blank | blank | blank | blank | blank | USR116 | Bulk restock for year-end |
| MVMT019 | outbound | 86 | blank | SKU-S1531 | Gizmo Pack - Red - Small | pieces | sale | 2022-02-13T21:55:00Z | WH-US-03 | Miami Hub | 808 Ocean Dr | Miami | FL | 33139 | USA | blank | blank | blank | blank | blank | blank | USR117 | Online order #18498 |
| MVMT020 | transfer | 45 | Melbourne | SKU-T7212 | Toolset Max - Blue - 20pcs | boxes | stock_rebalance | 2023-05-08T13:22:00Z | WH-AU-01 | Sydney Main | 225 Pitt St | Sydney | NSW | 2000 | Australia | WH-AU-02 | Melbourne East | 52 Swanston St | VIC | 3000 | Australia | USR118 | Regional transfer for inventory balancing |
What the 200 rows show
from the 200-row sampleAdjustment (movement type) stands out: mean quantity is 245,432,424, against 3,275 for the rest.
- 77.5median quantity
- 8unit of measures
- 11location countries
- 11destination countries
- 15reason codes
- 24location cities
Median 77.5, from 1 to 2,147,483,647.
- string 22
- integer 1
- datetime 1
Columns
24 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 22 columns | |||
movement_id | string | Unique identifier for each stock movement log entryunique | MVMT001 |
item_id | string | Unique identifier for the inventory item being moved | SKU-A1234 |
item_name | string | Name or description of the inventory item | Widget Pro - Blue - 10cm |
movement_type | string | Type of movement: inbound (stock in), outbound (stock out), transfer (between locations), adjustment (correction)inbound · outbound · transfer · adjustment | inbound |
unit_of_measure | string | Unit of measure for the quantity (e.g., pieces, boxes, kg)8 measures | pieces |
reason_code | string | Code or description indicating the reason for the movement (e.g., sale, return, damage, restock) | restock |
warehouse_id | string | Unique identifier for the warehouse where the movement originated | WH-US-01 |
warehouse_name | string | Name of the warehouse where the movement originated | New York Central |
location_street_address | string | Street address of the warehouse where the movement originatedoptional | 123 Broadway Ave |
location_city | string | City of the warehouse where the movement originatedoptional | New York |
location_state | string | State or region of the warehouse where the movement originatedoptional | NY |
location_postal_code | string | Postal code of the warehouse where the movement originatedoptional | 10001 |
location_country | string | Country of the warehouse where the movement originated11 countries · optional | USA |
destination_warehouse_id | string | Unique identifier for the destination warehouse (for transfers only)optional | WH-FR-02 |
destination_warehouse_name | string | Name of the destination warehouse (for transfers only)optional | Marseille South Hub |
destination_street_address | string | Street address of the destination warehouse (for transfers only)optional | 5 Quai de la Joliette |
destination_city | string | City of the destination warehouse (for transfers only)optional | Marseille |
destination_state | string | State or region of the destination warehouse (for transfers only)optional | Provence |
destination_postal_code | string | Postal code of the destination warehouse (for transfers only)optional | 13002 |
destination_country | string | Country of the destination warehouse (for transfers only)11 countries · optional | France |
user_id | string | Identifier for the user or system that logged the movementoptional | USR101 |
notes | string | Additional notes or comments about the movementoptional | Damaged during unloading |
| Numbers 1 column | |||
quantity | integer | Number of units moved in this transaction1 or more | 500 |
| Dates and times 1 column | |||
timestamp | datetime | Date and time when the movement occurred | 2023-03-15T09:15:00Z |
Use it for
A logistics dashboard
Quantity by movement_
type and a breakdown of destination_ city. Excel, Power BI or Tableau. Why do the 35 adjustment rows have a mean quantity of 245,432,424?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Movements200MVMT001500inboundMVMT00248outboundMVMT003150transfer
A software demo
Believable movements with item_
id, item_ name and movement_ type to fill a screen in front of a buyer.
blueprint · stock-movements
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 24 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.
- Movement type: in, out, transfer, adjustment
- Quantity matches before/after stock levels
- Reason codes for each movement type
- User/system that initiated movement
- Location tracking for transfers
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
- stock-movements