Inventory Items

This dataset provides comprehensive warehouse inventory records, including item details, stock levels, storage locations, supplier contacts, and detailed movement tracking. It is ideal for optimizing inventory management, automating reorder processes, and analyzing supply chain efficiency in logistics operations.

  • opened 6 times
  • last updated 29 Oct 2025
  • by GoMask
The brief that made it

Warehouse stock level monitoring and optimization

Sample rows

preview · 8 of 200 rows · all 18 columns
item_idstringmovement_typestringquantity_on_handintegercategorystringitem_namestringskustringreorder_pointintegerwarehouse_idstringlocation_aislestringlocation_shelfstringsupplier_idstringsupplier_namestringsupplier_contact_namestringsupplier_phonestringsupplier_emailstringmovement_quantityintegermovement_datedatetimemovement_referencestring
ITEM0001inbound120ElectronicsWireless Barcode ScannerSKU-B123456725WH-01A2S3SUP-1001TechNova SolutionsAndrea Mills+1-415-555-8765andrea.mills@technova.com1002024-03-15T10:22:00PO-10001
ITEM0002outbound45FurnitureErgonomic Desk ChairSKU-F987654310WH-02B1S1SUP-1002SeatWorks Inc.Peter Chan+1-212-555-3344peter.chan@seatworks.com72024-04-01T14:05:00SO-10002
ITEM0003adjustment22Building MaterialsCopper Pipe 1in x10ftSKU-BM1029385WH-04C3S2SUP-1003BuildSource Ltd.Charlie Gomez+1-303-555-2498cgomez@buildsource.com22024-05-10T11:45:00ADJ-10003
ITEM0004inbound5000Medical SuppliesDisposable Face Mask BoxSKU-MS983745800WH-05D4S5SUP-1004MedPrime Corp.Linda Huang+1-617-555-9008linda.huang@medprime.com50002024-03-22T09:30:00PO-10004
ITEM0005outbound35FastenersStainless Steel Fastener SetSKU-FA92736410WH-06E1S1SUP-1005Bolt & Nut SupplySam Patel+1-818-555-7071sam.patel@boltandsupply.com32024-04-18T15:18:00SO-10005
ITEM0006transfer150IoT DevicesIoT Temperature SensorSKU-IOT56738230WH-03F2S3SUP-1006SensorGrid Ltd.Emily Tran+1-646-555-3487emily.tran@sensorgrid.com452024-05-04T13:35:00TRF-10006
ITEM0007outbound18Electronics4K UHD ProjectorSKU-ELE2837464WH-01A1S4SUP-1007AV DirectSophie Lee+1-510-555-1123sophie.lee@avdirect.com22024-06-01T16:20:00SO-10007
ITEM0008inbound3200HygienePortable Hand Sanitizer 8ozSKU-HYG283746750WH-07G5S2SUP-1008CleanCare SuppliesPriya Verma+1-312-555-8654priya.verma@cleancare.com32002024-04-10T10:15:00PO-10008

What the 200 rows show

from the 200-row sample
  • 50.5median quantity_on_hand
  • 10warehouses
  • 35location shelfs
  • 12median reorder_point
  • 18.5median movement_quantity
movement_type200 rows by value
0459082inbound41%53outbound27%33transfer17%32adjustme…16%
quantity_on_hand200 rows, in bands of 1,000
085170165108533121205,00010kquantity_on_hand →

Median 50.5, from 0 to 9,400.

category196 rows with a value · 4 left blank
  1. Fasteners16
  2. Electronics14
  3. Furniture12
  4. Medical Supplies12
  5. Building Materials11
  6. HVAC11
  7. Hygiene10
  8. Drinkware10
  9. Collectibles10
  10. Beverages10
18 columns by typefrom the column list below
  • string 14
  • integer 3
  • datetime 1

Columns

18 columns in three groups
blueprint · 18 columns
columntypedescriptionexample
Text 14 columns
item_idstringUnique identifier for each inventory itemuniqueITEM0001
item_namestringName or description of the inventory itemWireless Barcode Scanner
skustringStock Keeping Unit code for the itemuniqueSKU-B1234567
categorystringCategory or type of the inventory itemoptionalElectronics
warehouse_idstringIdentifier for the warehouse where the item is stored10 warehousesWH-01
location_aislestringAisle location within the warehouseoptionalA2
location_shelfstringShelf location within the aisleoptionalS3
supplier_idstringUnique identifier for the supplierSUP-1001
supplier_namestringName of the supplieroptionalTechNova Solutions
supplier_contact_namestringContact person's name at the supplieroptionalAndrea Mills
supplier_phonestringSupplier contact phone numberoptional+1-415-555-8765
supplier_emailstringSupplier contact email addressoptionalpeter.chan@seatworks.com
movement_typestringType of inventory movement (inbound, outbound, transfer, adjustment)inbound · outbound · transfer · adjustmentinbound
movement_referencestringReference or document number for the movement transactionoptionalPO-10001
Numbers 3 columns
quantity_on_handintegerCurrent quantity of the item in stock0 or more120
reorder_pointintegerMinimum stock level before reorder is triggered0 or more25
movement_quantityintegerQuantity of items moved in the transaction1 or more100
Dates and times 1 column
movement_datedatetimeDate and time of the inventory movement2024-03-15T10:22:00

Use it for

  • median quantit…50.5200 rowsmean quantity on hand…1.2kinbo…50.8outb…59.2tran…1.2kadju…

    A logistics dashboard

    Quantity_on_hand by movement_type and a breakdown of category. 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 items with item_name, sku and category to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 18 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 rows18 columns
Yours1,000 rows18 columnslocation_aisle: UK only

blueprint · inventory-items

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 18 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
  • Current stock is non-negative integer
  • Reorder point triggers purchase order
  • Warehouse location in bin/shelf format
  • Last counted date for accuracy tracking
  • Expiration dates for perishable items
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
inventory-items

What should your data show?

Preview 20 rows free
No signup. No card.