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.
Sample rows
preview · 8 of 200 rows · all 18 columns| item_idstring | movement_typestring | quantity_on_handinteger | categorystring | item_namestring | skustring | reorder_pointinteger | warehouse_idstring | location_aislestring | location_shelfstring | supplier_idstring | supplier_namestring | supplier_contact_namestring | supplier_phonestring | supplier_emailstring | movement_quantityinteger | movement_datedatetime | movement_referencestring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ITEM0001 | inbound | 120 | Electronics | Wireless Barcode Scanner | SKU-B1234567 | 25 | WH-01 | A2 | S3 | SUP-1001 | TechNova Solutions | Andrea Mills | +1-415-555-8765 | andrea.mills@ | 100 | 2024-03-15T10:22:00 | PO-10001 |
| ITEM0002 | outbound | 45 | Furniture | Ergonomic Desk Chair | SKU-F9876543 | 10 | WH-02 | B1 | S1 | SUP-1002 | SeatWorks Inc. | Peter Chan | +1-212-555-3344 | peter.chan@ | 7 | 2024-04-01T14:05:00 | SO-10002 |
| ITEM0003 | adjustment | 22 | Building Materials | Copper Pipe 1in x10ft | SKU-BM102938 | 5 | WH-04 | C3 | S2 | SUP-1003 | BuildSource Ltd. | Charlie Gomez | +1-303-555-2498 | cgomez@ | 2 | 2024-05-10T11:45:00 | ADJ-10003 |
| ITEM0004 | inbound | 5000 | Medical Supplies | Disposable Face Mask Box | SKU-MS983745 | 800 | WH-05 | D4 | S5 | SUP-1004 | MedPrime Corp. | Linda Huang | +1-617-555-9008 | linda.huang@ | 5000 | 2024-03-22T09:30:00 | PO-10004 |
| ITEM0005 | outbound | 35 | Fasteners | Stainless Steel Fastener Set | SKU-FA927364 | 10 | WH-06 | E1 | S1 | SUP-1005 | Bolt & Nut Supply | Sam Patel | +1-818-555-7071 | sam.patel@ | 3 | 2024-04-18T15:18:00 | SO-10005 |
| ITEM0006 | transfer | 150 | IoT Devices | IoT Temperature Sensor | SKU-IOT567382 | 30 | WH-03 | F2 | S3 | SUP-1006 | SensorGrid Ltd. | Emily Tran | +1-646-555-3487 | emily.tran@ | 45 | 2024-05-04T13:35:00 | TRF-10006 |
| ITEM0007 | outbound | 18 | Electronics | 4K UHD Projector | SKU-ELE283746 | 4 | WH-01 | A1 | S4 | SUP-1007 | AV Direct | Sophie Lee | +1-510-555-1123 | sophie.lee@ | 2 | 2024-06-01T16:20:00 | SO-10007 |
| ITEM0008 | inbound | 3200 | Hygiene | Portable Hand Sanitizer 8oz | SKU-HYG283746 | 750 | WH-07 | G5 | S2 | SUP-1008 | CleanCare Supplies | Priya Verma | +1-312-555-8654 | priya.verma@ | 3200 | 2024-04-10T10:15:00 | PO-10008 |
| ITEM0009 | transfer | 8 | Drones | Mini Drone Quadcopter | SKU-DRN939201 | 2 | WH-02 | B2 | S2 | SUP-1009 | SkyFleet | Joseph Kim | +1-718-555-3824 | joseph.kim@ | 4 | 2024-05-20T12:10:00 | TRF-10009 |
| ITEM0010 | inbound | 62 | Lab Equipment | Lab Glassware Set | SKU-LAB192837 | 15 | WH-03 | F3 | S2 | SUP-1010 | LabEssentials | Hannah Clark | +1-617-555-7654 | hannah.clark@ | 60 | 2024-03-25T08:45:00 | PO-10010 |
| ITEM0011 | inbound | 1 | Luxury Goods | Luxury Watch - Platinum | SKU-LUX938210 | 0 | WH-09 | blank | blank | SUP-1011 | EliteTimepieces | Michael Stern | +1-646-555-1987 | m.stern@ | 1 | 2024-05-02T09:00:00 | PO-10011 |
| ITEM0012 | outbound | 110 | Drinkware | Ceramic Coffee Mug | SKU-DW948372 | 12 | WH-02 | B4 | S3 | SUP-1012 | MugMaster | Tina Rivera | +1-415-555-2023 | tina.rivera@ | 15 | 2024-04-24T13:10:00 | SO-10012 |
| ITEM0013 | adjustment | 1700 | Emergency Items | Emergency LED Flashlight | SKU-EMG832014 | 340 | WH-10 | blank | S1 | SUP-1013 | BrightSafe | blank | +1-212-555-4555 | info@ | 1500 | 2024-06-05T16:00:00 | ADJ-10013 |
| ITEM0014 | outbound | 0 | Collectibles | Collectible Comic Book | SKU-COL001234 | 0 | WH-08 | blank | blank | SUP-1014 | RareFinds | Nate Olsen | +1-917-555-0923 | nate.olsen@ | 1 | 2024-05-18T11:10:00 | SO-10014 |
| ITEM0015 | inbound | 38 | Office Equipment | Thermal Printer Roll | SKU-OEQ192837 | 8 | WH-01 | A5 | S1 | SUP-1015 | PrintSupply Co. | Dana Evans | +1-415-555-7712 | dana.evans@ | 30 | 2024-03-29T09:30:00 | PO-10015 |
| ITEM0016 | inbound | 1000 | Packaging | Cardboard Shipping Box | SKU-PKG827364 | 250 | WH-05 | D6 | S2 | SUP-1016 | BoxDepot | Victor Lin | +1-213-555-9987 | victor.lin@ | 1000 | 2024-04-05T10:00:00 | PO-10016 |
| ITEM0017 | inbound | 4100 | Stationery | Assorted Paper Clips 500ct | SKU-STN764839 | 600 | WH-07 | G2 | S5 | SUP-1017 | OfficePro | Marcus Bell | +1-718-555-9912 | marcus.bell@ | 4100 | 2024-04-18T08:55:00 | PO-10017 |
| ITEM0018 | transfer | 80 | Accessories | Smartwatch Charging Cable | SKU-ACC382910 | 18 | WH-03 | F4 | S1 | SUP-1018 | ChargeHub | Olivia King | +1-646-555-3281 | olivia.king@ | 35 | 2024-05-08T12:50:00 | TRF-10018 |
| ITEM0019 | outbound | 250 | Beverages | Insulated Water Bottle | SKU-BEV827364 | 45 | WH-02 | B6 | S6 | SUP-1019 | HydroWare | Liam Watson | +1-212-555-3471 | liam.watson@ | 20 | 2024-06-03T15:05:00 | SO-10019 |
| ITEM0020 | adjustment | 65 | HVAC | HVAC Air Filter 16x25x1 | SKU-HVAC9382 | 12 | WH-04 | C4 | S3 | SUP-1020 | FilterFlow | Paulina Reyes | +1-303-555-8720 | paulina.reyes@ | 15 | 2024-05-16T10:25:00 | ADJ-10020 |
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
Median 50.5, from 0 to 9,400.
- string 14
- integer 3
- datetime 1
Columns
18 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 14 columns | |||
item_id | string | Unique identifier for each inventory itemunique | ITEM0001 |
item_name | string | Name or description of the inventory item | Wireless Barcode Scanner |
sku | string | Stock Keeping Unit code for the itemunique | SKU-B1234567 |
category | string | Category or type of the inventory itemoptional | Electronics |
warehouse_id | string | Identifier for the warehouse where the item is stored10 warehouses | WH-01 |
location_aisle | string | Aisle location within the warehouseoptional | A2 |
location_shelf | string | Shelf location within the aisleoptional | S3 |
supplier_id | string | Unique identifier for the supplier | SUP-1001 |
supplier_name | string | Name of the supplieroptional | TechNova Solutions |
supplier_contact_name | string | Contact person's name at the supplieroptional | Andrea Mills |
supplier_phone | string | Supplier contact phone numberoptional | +1-415-555-8765 |
supplier_email | string | Supplier contact email addressoptional | peter.chan@ |
movement_type | string | Type of inventory movement (inbound, outbound, transfer, adjustment)inbound · outbound · transfer · adjustment | inbound |
movement_reference | string | Reference or document number for the movement transactionoptional | PO-10001 |
| Numbers 3 columns | |||
quantity_on_hand | integer | Current quantity of the item in stock0 or more | 120 |
reorder_point | integer | Minimum stock level before reorder is triggered0 or more | 25 |
movement_quantity | integer | Quantity of items moved in the transaction1 or more | 100 |
| Dates and times 1 column | |||
movement_date | datetime | Date and time of the inventory movement | 2024-03-15T10:22:00 |
Use it for
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.
- Items200ITEM0001120inboundITEM000245outboundITEM000322adjustme…
A software demo
Believable items with item_
name, sku and category to fill a screen in front of a buyer.
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.
- 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
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