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.

  • opened 50 times
  • last updated 20 Aug 2025
  • by GoMask
The brief that made it

Real-time inventory tracking and reconciliation

Sample rows

preview · 8 of 200 rows · all 23 columns
inventory_flow_idstringsource_location_typestringquantityintegerwarehouse_postal_codestringwarehouse_idstringwarehouse_namestringwarehouse_street_addressstringwarehouse_citystringwarehouse_statestringwarehouse_countrystringproduct_idstringproduct_namestringskustringmovement_typestringunit_of_measurestringmovement_datetimedatetimesource_location_idstringdestination_location_typestringdestination_location_idstringreference_document_numberstringmovement_reasonstringhandled_by_user_idstringcommentsstring
INVFLW0001supplier90060601WH001Central Distribution100 Main StChicagoILUSAPRD00001Electric Drill 500WEDRILL500Winboundpieces2024-05-03T10:23:00ZSUP1234warehouseWH001PO-20240503-01Restocking after salesUSR0012Received from regular supplier.
INVFLW0002warehouse15055401WH002North Hub2211 North AveMinneapolisMNUSAPRD00002Heavy Duty HammerHDHAMMERoutboundpieces2024-05-04T14:55:00ZWH002customerCUST9981SO-20240504-02Order fulfillmentUSR0033Shipped for online order #A2345.
INVFLW0003warehouse200002118WH003East Storage76 Long DrBostonMAUSAPRD00003Safety Gloves LargeSGLOVELtransferboxes2024-05-02T09:05:00ZWH003warehouseWH001TR-20240502-01Stock balancingUSR0020Moved due to high demand in Chicago.
INVFLW0004warehouse8080202WH004West Logistics401 Pine StDenverCOUSAPRD00004Packing Tape RollPTAPEadjustmentpieces2024-04-28T16:10:00ZWH004warehouseWH004ADJ-20240428-01Inventory audit adjustmentUSR0045Adjusted after physical count.
INVFLW0005supplier42075201WH005South Depot5555 South StDallasTXUSAPRD00005LED Work LightLEDWL100inboundpieces2024-05-05T11:45:00ZSUP3210warehouseWH005PO-20240505-03New product launchUSR0058First batch for new SKU.
INVFLW0006warehouse6064106WH006Midwest Storage302 Maple RdKansas CityMOUSAPRD00006All-Purpose CleanerAPCLNR1Loutboundbottles2024-05-05T13:41:00ZWH006customerCUST4552SO-20240505-04Retail orderUSR0067Bulk order for store chain.
INVFLW0007warehouse30094107WH007Pacific Hub789 Ocean PkwySan FranciscoCAUSAPRD00007Industrial Mop HeadIMOPHtransferpieces2024-05-01T08:20:00ZWH007warehouseWH002TR-20240501-02Seasonal demand shiftUSR0072Increase inventory for summer season.
INVFLW0008supplier140033101WH008Atlantic Fulfillment200 Harbor DrMiamiFLUSAPRD00008Plastic Storage BinPSBIN20Linboundpieces2024-04-30T15:30:00ZSUP9843warehouseWH008PO-20240430-05Restocking storage itemsUSR0081Full truck delivery.

What the 200 rows show

from the 200-row sample
  • 120median quantity
  • 2destination location types
  • 3warehouse countries
  • 4movement types
  • 12unit of measures
  • 22warehouse states
source_location_type200 rows by value
07014062supplier31%138warehouse69%
quantity200 rows, in bands of 2,500
090180177145210001012.5k22.5kquantity →

Median 120, from 1 to 21,000.

warehouse_postal_code200 rows · top 10 of 39 values
  1. 9513418
  2. 6060110
  3. 7520110
  4. 7520710
  5. 4823410
  6. 8021610
  7. 554019
  8. 021185
  9. 802025
  10. 641065
23 columns by typefrom the column list below
  • string 21
  • integer 1
  • datetime 1

Columns

23 columns in three groups
blueprint · 23 columns
columntypedescriptionexample
Text 21 columns
inventory_flow_idstringUnique identifier for each inventory movement recorduniqueINVFLW0001
warehouse_idstringUnique identifier for the warehouse where the movement occursWH001
warehouse_namestringName of the warehouseCentral Distribution
warehouse_street_addressstringStreet address of the warehouseoptional100 Main St
warehouse_citystringCity where the warehouse is locatedoptionalChicago
warehouse_statestringState or region of the warehouse locationoptionalIL
warehouse_postal_codestringPostal code of the warehouse locationoptional60601
warehouse_countrystringCountry of the warehouse location3 countries · optionalUSA
product_idstringUnique identifier for the product being movedPRD00001
product_namestringName or description of the productElectric Drill 500W
skustringStock Keeping Unit identifier for the productoptionalEDRILL500W
movement_typestringType of inventory movement: inbound, outbound, transfer, adjustmentinbound · outbound · transfer · adjustmentinbound
unit_of_measurestringUnit of measure for the product quantity (e.g., pieces, boxes, kg)12 measures · optionalpieces
source_location_typestringType of source location: supplier, warehouse, customer, othersupplier · warehouse · customer · other · optionalsupplier
source_location_idstringIdentifier for the source location (if applicable)optionalSUP1234
destination_location_typestringType of destination location: warehouse, customer, otherwarehouse · customer · other · optionalwarehouse
destination_location_idstringIdentifier for the destination location (if applicable)optionalWH001
reference_document_numberstringReference number for related documents (e.g., purchase order, sales order, transfer order)optionalPO-20240503-01
movement_reasonstringReason for inventory movement (e.g., order fulfillment, restocking, damage, audit adjustment)optionalRestocking after sales
handled_by_user_idstringIdentifier for the user or employee who processed the movementoptionalUSR0012
commentsstringAdditional notes or comments about the movementoptionalFirst batch for new SKU.
Numbers 1 column
quantityintegerNumber of product units moved1 or more900
Dates and times 1 column
movement_datetimedatetimeDate and time when the inventory movement occurred2024-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.

  1. 01BeginnerFreeWHERE · ORDER BY · LIMIT

    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 rows
  2. 02BeginnerFreeDISTINCT · ORDER BY

    Country 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 rows
  3. 03BeginnerFreeGROUP BY · COUNT

    Number 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
  1. 04Total and average quantity by countryBeginner
  2. 05Total quantity for outbound and adjustmentPower BI
  3. 06Warehouses with at least 8 movementsIntermediate
  4. 07Movement size bucketsIntermediate
  5. 08Movements per monthIntermediate
  6. 09Products above the overall averageIntermediate
  7. 10Average quantity by movement typePower BI
  8. 11Top three products per countryAdvanced
  9. 12Days since previous movement at WH001Advanced
  10. 13Running total of inbound quantityAdvanced
  11. 14Share of total quantity by typeAdvanced
  12. 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.99

Use it for

  • median quantity120200 rowsmean quantity by sour…1.2ksuppli…723.1wareho…

    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.

  • A software demo

    Believable inventory flows with warehouse_id, warehouse_name and warehouse_street_address to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 23 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset200 rows23 columns
Yours1,000 rows23 columnswarehouse_street_address: UK only

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.

Rules it was built with
  • Log SKU, quantity, and location
  • Track inbound and outbound timestamps
  • Flag inventory discrepancies
  • Aggregate daily flow rates
Rows
Open the blueprint in Data Factory

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

What should your data show?

Preview 20 rows free
No signup. No card.