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 |
Use 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. 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-flow-dataset