Warehouse Inventory Flow Dataset
This dataset provides detailed records of goods movement into, out of, and between warehouses, including product details, quantities, movement types, and timestamps. It enables comprehensive tracking for inventory optimization, order fulfillment, and operational analysis in logistics and supply chain management. The structure supports audit trails, loss prevention, and process improvement.
Sample rows
preview · 8 of 200 rows · all 23 columns| inventory_flow_idstring | source_location_typestring | quantityinteger | warehouse_postal_codestring | warehouse_idstring | warehouse_namestring | warehouse_street_addressstring | warehouse_citystring | warehouse_statestring | warehouse_countrystring | product_idstring | product_namestring | skustring | movement_typestring | unit_of_measurestring | movement_datetimedatetime | source_location_idstring | destination_location_typestring | destination_location_idstring | reference_document_numberstring | movement_reasonstring | handled_by_user_idstring | commentsstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| INVFLW0001 | supplier | 900 | 60601 | WH001 | Central Distribution | 100 Main St | Chicago | IL | USA | PRD00001 | Electric Drill 500W | EDRILL500W | inbound | pieces | 2024-05-03T10:23:00Z | SUP1234 | warehouse | WH001 | PO-20240503-01 | Restocking after sales | USR0012 | Received from regular supplier. |
| INVFLW0002 | warehouse | 150 | 55401 | WH002 | North Hub | 2211 North Ave | Minneapolis | MN | USA | PRD00002 | Heavy Duty Hammer | HDHAMMER | outbound | pieces | 2024-05-04T14:55:00Z | WH002 | customer | CUST9981 | SO-20240504-02 | Order fulfillment | USR0033 | Shipped for online order #A2345. |
| INVFLW0003 | warehouse | 2000 | 02118 | WH003 | East Storage | 76 Long Dr | Boston | MA | USA | PRD00003 | Safety Gloves Large | SGLOVEL | transfer | boxes | 2024-05-02T09:05:00Z | WH003 | warehouse | WH001 | TR-20240502-01 | Stock balancing | USR0020 | Moved due to high demand in Chicago. |
| INVFLW0004 | warehouse | 80 | 80202 | WH004 | West Logistics | 401 Pine St | Denver | CO | USA | PRD00004 | Packing Tape Roll | PTAPE | adjustment | pieces | 2024-04-28T16:10:00Z | WH004 | warehouse | WH004 | ADJ-20240428-01 | Inventory audit adjustment | USR0045 | Adjusted after physical count. |
| INVFLW0005 | supplier | 420 | 75201 | WH005 | South Depot | 5555 South St | Dallas | TX | USA | PRD00005 | LED Work Light | LEDWL100 | inbound | pieces | 2024-05-05T11:45:00Z | SUP3210 | warehouse | WH005 | PO-20240505-03 | New product launch | USR0058 | First batch for new SKU. |
| INVFLW0006 | warehouse | 60 | 64106 | WH006 | Midwest Storage | 302 Maple Rd | Kansas City | MO | USA | PRD00006 | All-Purpose Cleaner | APCLNR1L | outbound | bottles | 2024-05-05T13:41:00Z | WH006 | customer | CUST4552 | SO-20240505-04 | Retail order | USR0067 | Bulk order for store chain. |
| INVFLW0007 | warehouse | 300 | 94107 | WH007 | Pacific Hub | 789 Ocean Pkwy | San Francisco | CA | USA | PRD00007 | Industrial Mop Head | IMOPH | transfer | pieces | 2024-05-01T08:20:00Z | WH007 | warehouse | WH002 | TR-20240501-02 | Seasonal demand shift | USR0072 | Increase inventory for summer season. |
| INVFLW0008 | supplier | 1400 | 33101 | WH008 | Atlantic Fulfillment | 200 Harbor Dr | Miami | FL | USA | PRD00008 | Plastic Storage Bin | PSBIN20L | inbound | pieces | 2024-04-30T15:30:00Z | SUP9843 | warehouse | WH008 | PO-20240430-05 | Restocking storage items | USR0081 | Full truck delivery. |
| INVFLW0009 | warehouse | 20 | 84101 | WH009 | Rocky Mountain Depot | 12 Aspen Way | Salt Lake City | UT | USA | PRD00009 | Industrial Fan | FANINDL | adjustment | units | 2024-05-04T17:15:00Z | WH009 | warehouse | WH009 | ADJ-20240504-02 | Damaged in transit | USR0094 | Removed damaged fans from count. |
| INVFLW0010 | warehouse | 90 | 38103 | WH010 | Delta Transfer | 88 River Rd | Memphis | TN | USA | PRD00010 | Portable Tool Case | PTCASE | transfer | pieces | 2024-05-06T10:10:00Z | WH010 | warehouse | WH008 | TR-20240506-01 | Balancing tool inventory | USR0103 | Expedited transfer required. |
| INVFLW0011 | supplier | 1200 | 60601 | WH001 | Central Distribution | 100 Main St | Chicago | IL | USA | PRD00011 | Safety Goggles | SGOG001 | inbound | pieces | 2024-05-07T09:30:00Z | SUP2222 | warehouse | WH001 | PO-20240507-02 | Bulk protective gear | USR0012 | Rush shipment received. |
| INVFLW0012 | warehouse | 21000 | 55401 | WH002 | North Hub | 2211 North Ave | Minneapolis | MN | USA | PRD00012 | Steel Nails 50mm | SNL50MM | outbound | kg | 2024-05-08T11:52:00Z | WH002 | customer | CUST1023 | SO-20240508-07 | Large construction order | USR0033 | Order for city construction project. |
| INVFLW0013 | warehouse | 400 | 02118 | WH003 | East Storage | 76 Long Dr | Boston | MA | USA | PRD00013 | Rubber Gasket Set | RGASKETSET | transfer | sets | 2024-05-03T13:00:00Z | WH003 | warehouse | WH006 | TR-20240503-03 | Seasonal increase | USR0020 | Moved for Midwest ramp up. |
| INVFLW0014 | warehouse | 50 | 80202 | WH004 | West Logistics | 401 Pine St | Denver | CO | USA | PRD00014 | Corrugated Boxes | CBOX100 | adjustment | boxes | 2024-05-09T15:44:00Z | WH004 | warehouse | WH004 | ADJ-20240509-01 | Shrinkage found | USR0045 | Missing items after audit. |
| INVFLW0015 | supplier | 700 | 75201 | WH005 | South Depot | 5555 South St | Dallas | TX | USA | PRD00015 | Heavy Duty Extension Cord | HDEXTCORD | inbound | pieces | 2024-05-10T08:40:00Z | SUP1999 | warehouse | WH005 | PO-20240510-02 | Restocking after sale | USR0058 | High demand item restocked. |
| INVFLW0016 | warehouse | 5000 | 64106 | WH006 | Midwest Storage | 302 Maple Rd | Kansas City | MO | USA | PRD00016 | Stainless Steel Screws | SSSCREW | outbound | kg | 2024-05-10T12:22:00Z | WH006 | customer | CUST3911 | SO-20240510-03 | Contract order | USR0067 | Delivered for manufacturing contract. |
| INVFLW0017 | warehouse | 55 | 94107 | WH007 | Pacific Hub | 789 Ocean Pkwy | San Francisco | CA | USA | PRD00017 | Aluminum Ladder | ALAD10FT | transfer | pieces | 2024-05-09T09:10:00Z | WH007 | warehouse | WH005 | TR-20240509-01 | Redistribution | USR0072 | Low demand in Pacific Hub. |
| INVFLW0018 | supplier | 320 | 33101 | WH008 | Atlantic Fulfillment | 200 Harbor Dr | Miami | FL | USA | PRD00018 | Work Boots Size 10 | WBOOT10 | inbound | pairs | 2024-05-10T14:00:00Z | SUP5555 | warehouse | WH008 | PO-20240510-05 | Seasonal restocking | USR0081 | Annual Q2 restock. |
| INVFLW0019 | warehouse | 10 | 84101 | WH009 | Rocky Mountain Depot | 12 Aspen Way | Salt Lake City | UT | USA | PRD00019 | Safety Cone Orange | SCONEORG | adjustment | pieces | 2024-05-06T18:22:00Z | WH009 | warehouse | WH009 | ADJ-20240506-03 | Lost in transit | USR0094 | Documented by inbound team. |
| INVFLW0020 | warehouse | 130 | 38103 | WH010 | Delta Transfer | 88 River Rd | Memphis | TN | USA | PRD00020 | Hand Saw | HSAW20IN | transfer | pieces | 2024-05-11T10:50:00Z | WH010 | warehouse | WH009 | TR-20240511-01 | Transfer to support new project | USR0103 | Requested by SLC operations. |
What the 200 rows show
from the 200-row sample- 120median quantity
- 2destination location types
- 3warehouse countries
- 4movement types
- 12unit of measures
- 22warehouse states
Median 120, from 1 to 21,000.
- string 21
- integer 1
- datetime 1
Columns
23 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 21 columns | |||
inventory_flow_id | string | Unique identifier for each inventory movement recordunique | INVFLW0001 |
warehouse_id | string | Unique identifier for the warehouse where the movement occurs | WH001 |
warehouse_name | string | Name of the warehouse | Central Distribution |
warehouse_street_address | string | Street address of the warehouseoptional | 100 Main St |
warehouse_city | string | City where the warehouse is locatedoptional | Chicago |
warehouse_state | string | State or region of the warehouse locationoptional | IL |
warehouse_postal_code | string | Postal code of the warehouse locationoptional | 60601 |
warehouse_country | string | Country of the warehouse location3 countries · optional | USA |
product_id | string | Unique identifier for the product being moved | PRD00001 |
product_name | string | Name or description of the product | Electric Drill 500W |
sku | string | Stock Keeping Unit identifier for the productoptional | EDRILL500W |
movement_type | string | Type of inventory movement: inbound, outbound, transfer, adjustmentinbound · outbound · transfer · adjustment | inbound |
unit_of_measure | string | Unit of measure for the product quantity (e.g., pieces, boxes, kg)12 measures · optional | pieces |
source_location_type | string | Type of source location: supplier, warehouse, customer, othersupplier · warehouse · customer · other · optional | supplier |
source_location_id | string | Identifier for the source location (if applicable)optional | SUP1234 |
destination_location_type | string | Type of destination location: warehouse, customer, otherwarehouse · customer · other · optional | warehouse |
destination_location_id | string | Identifier for the destination location (if applicable)optional | WH001 |
reference_document_number | string | Reference number for related documents (e.g., purchase order, sales order, transfer order)optional | PO-20240503-01 |
movement_reason | string | Reason for inventory movement (e.g., order fulfillment, restocking, damage, audit adjustment)optional | Restocking after sales |
handled_by_user_id | string | Identifier for the user or employee who processed the movementoptional | USR0012 |
comments | string | Additional notes or comments about the movementoptional | First batch for new SKU. |
| Numbers 1 column | |||
quantity | integer | Number of product units moved1 or more | 900 |
| Dates and times 1 column | |||
movement_datetime | datetime | Date and time when the inventory movement occurred | 2024-05-03T10:23:00Z |
15 SQL practice questions for the Warehouse Inventory Flow Dataset
Written for this data and checked against it: 12 SQL and 3 Power BI exercises from beginner to advanced. Try the first three free; the practice kit has all 15, a starter .sql file and an answer key with every expected result.
Ten largest inbound movements
Return inventory_flow_id, product_name and quantity for the 10 inbound movements with the highest quantity. Sort by quantity from highest to lowest, then by inventory_flow_id ascending.
Tables: warehouse_inventory_flow_dataset · your result: 3 columns, 10 rowsCountry and movement type pairs
Return each distinct combination of warehouse_country and movement_type, with the columns warehouse_country and movement_type. Sort by warehouse_country, then by movement_type.
Tables: warehouse_inventory_flow_dataset · your result: 2 columns, 6 rowsNumber of movements per type
Count the movements for each movement_type. Return movement_type and movement_count, sorted by movement_count from highest to lowest, then by movement_type.
Tables: warehouse_inventory_flow_dataset · your result: 2 columns, 4 rows
- 04Total and average quantity by countryBeginner
- 05Total quantity for outbound and adjustmentPower BI
- 06Warehouses with at least 8 movementsIntermediate
- 07Movement size bucketsIntermediate
- 08Movements per monthIntermediate
- 09Products above the overall averageIntermediate
- 10Average quantity by movement typePower BI
- 11Top three products per countryAdvanced
- 12Days since previous movement at WH001Advanced
- 13Running total of inbound quantityAdvanced
- 14Share of total quantity by typeAdvanced
- 15Percent of total quantity by typePower BI
Get the practice kit: the full dataset, all 15 exercises, a starter .sql and the answer key. One-time $3.99.
Get the practice kit · $3.99Use it for
A logistics dashboard
Quantity by source_
location_ type and a breakdown of warehouse_ postal_ code. Excel, Power BI or Tableau. What pattern can you find in 200 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 200 rows.
- Inventory flows200INVFLW0001900supplierINVFLW0002150warehouseINVFLW00032000warehouse
A software demo
Believable inventory flows with warehouse_
id, warehouse_ name and warehouse_ street_ address to fill a screen in front of a buyer.
blueprint · warehouse-inventory-flow-dataset
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 23 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.
- Log SKU, quantity, and location
- Track inbound and outbound timestamps
- Flag inventory discrepancies
- Aggregate daily flow rates
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-flow-dataset