Warehouse Inventory Turnover Records
This dataset provides detailed inventory turnover records by SKU and warehouse, including movement quantities, turnover rates, and slow-moving item flags for defined periods. It enables granular analysis of stock efficiency, helps optimize inventory levels, and supports cost reduction by identifying underperforming products. The data is ideal for supply chain optimization, warehouse management, and strategic purchasing decisions.
Sample rows
preview · 8 of 65 rows · all 18 columns| record_idstring | categorystring | average_inventory_quantityfloat | is_slow_movingboolean | warehouse_idstring | skustring | product_namestring | warehouse_namestring | period_start_datedate | period_end_datedate | opening_inventory_quantityinteger | closing_inventory_quantityinteger | units_receivedinteger | units_soldinteger | inventory_turnover_ratefloat | days_on_handfloat | last_movement_datedate | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| INV-0001 | Electronics | 100 | false | WH-01 | SKU-1001 | Wireless Mouse | Central Distribution | 2023-01-01 | 2023-01-31 | 120 | 80 | 60 | 100 | 1 | 31 | 2023-01-30 | Steady month |
| INV-0002 | Electronics | 185 | true | WH-02 | SKU-1002 | Bluetooth Keyboard | East Hub | 2023-01-01 | 2023-01-31 | 200 | 170 | 50 | 80 | 0.43 | 72.1 | 2023-01-28 | Low turnover |
| INV-0003 | Accessories | 72.5 | true | WH-01 | SKU-1003 | USB-C Hub | Central Distribution | 2023-02-01 | 2023-02-28 | 80 | 65 | 30 | 45 | 0.62 | 45.5 | 2023-02-27 | Below average sales |
| INV-0004 | Furniture | 22.5 | false | WH-03 | SKU-1004 | Ergonomic Chair | West Distribution Center | 2023-02-01 | 2023-02-28 | 30 | 15 | 10 | 25 | 1.11 | 25.2 | 2023-02-25 | Strong demand |
| INV-0005 | Accessories | 67.5 | true | WH-04 | SKU-1005 | Laptop Stand | Southern Depot | 2023-01-01 | 2023-01-31 | 75 | 60 | 20 | 35 | 0.52 | 59.6 | 2023-01-29 | Slow-moving, plan promotion |
| INV-0006 | Furniture | 19 | true | WH-03 | SKU-1006 | Standing Desk | West Distribution Center | 2023-03-01 | 2023-03-31 | 20 | 18 | 5 | 7 | 0.37 | 83.8 | 2023-03-30 | Low sales, expensive item |
| INV-0007 | Accessories | 39 | false | WH-02 | SKU-1007 | Monitor Arm | East Hub | 2023-02-01 | 2023-02-28 | 50 | 28 | 15 | 37 | 0.95 | 29.5 | 2023-02-27 | blank |
| INV-0008 | Electronics | 275 | true | WH-01 | SKU-1008 | USB Flash Drive 32GB | Central Distribution | 2023-03-01 | 2023-03-31 | 300 | 250 | 100 | 150 | 0.55 | 56.4 | 2023-03-30 | Bulk order in transit |
| INV-0009 | Electronics | 52.5 | false | WH-04 | SKU-1009 | Wireless Headphones | Southern Depot | 2023-02-01 | 2023-02-28 | 60 | 45 | 20 | 35 | 0.67 | 41.8 | 2023-02-26 | blank |
| INV-0010 | Lighting | 37 | true | WH-02 | SKU-1010 | Desk Lamp | East Hub | 2023-03-01 | 2023-03-31 | 40 | 34 | 10 | 16 | 0.43 | 72.1 | 2023-03-29 | Needs marketing |
| INV-0011 | Furniture | 14 | false | WH-03 | SKU-1011 | Office Chair Mat | West Distribution Center | 2023-04-01 | 2023-04-30 | 18 | 10 | 6 | 14 | 1 | 30 | 2023-04-28 | blank |
| INV-0012 | Electronics | 130 | true | WH-01 | SKU-1012 | Ethernet Cable 5m | Central Distribution | 2023-02-01 | 2023-02-28 | 150 | 110 | 25 | 65 | 0.5 | 56 | 2023-02-27 | Slow-moving cable |
| INV-0013 | Accessories | 59 | true | WH-02 | SKU-1013 | Notebook Cooler | East Hub | 2023-04-01 | 2023-04-30 | 60 | 58 | 10 | 12 | 0.2 | 150 | 2023-04-27 | Very slow-moving |
| INV-0014 | Electronics | 80 | true | WH-03 | SKU-1014 | Webcam HD | West Distribution Center | 2023-01-01 | 2023-01-31 | 90 | 70 | 25 | 45 | 0.56 | 55.4 | 2023-01-29 | blank |
| INV-0015 | Electronics | 37.5 | true | WH-04 | SKU-1015 | Surge Protector | Southern Depot | 2023-03-01 | 2023-03-31 | 40 | 35 | 8 | 13 | 0.35 | 88.6 | 2023-03-30 | Low demand |
| INV-0016 | Accessories | 32.5 | false | WH-01 | SKU-1016 | Desk Organizer | Central Distribution | 2023-04-01 | 2023-04-30 | 45 | 20 | 15 | 40 | 1.23 | 24.4 | 2023-04-29 | blank |
| INV-0017 | Furniture | 6.5 | false | WH-02 | SKU-1017 | Filing Cabinet | East Hub | 2023-03-01 | 2023-03-31 | 8 | 5 | 2 | 5 | 0.77 | 40.3 | 2023-03-28 | Steady, small volume |
| INV-0018 | Electronics | 24.5 | true | WH-03 | SKU-1018 | Conference Speaker | West Distribution Center | 2023-03-01 | 2023-03-31 | 25 | 24 | 4 | 5 | 0.2 | 155 | 2023-03-27 | Slow-moving, consider bundle |
| INV-0019 | Accessories | 21 | false | WH-04 | SKU-1019 | Adjustable Footrest | Southern Depot | 2023-04-01 | 2023-04-30 | 30 | 12 | 10 | 28 | 1.33 | 22.6 | 2023-04-28 | Popular product |
| INV-0020 | Electronics | 11.5 | false | WH-01 | SKU-1020 | Laser Printer | Central Distribution | 2023-03-01 | 2023-03-31 | 15 | 8 | 5 | 12 | 1.04 | 29.8 | 2023-03-30 | blank |
What the 65 rows show
from the 65-row sample- 62%is_
slow_ moving = true - 44.0median average_
inventory_ quantity - 10warehouse names
- 49median opening_
inventory_ quantity - 38median closing_
inventory_ quantity - 10median units_
received
Median 44.0, from 6.5 to 580.0.
- string 7
- integer 4
- float 3
- date 3
- boolean 1
Columns
18 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 7 columns | |||
record_id | string | Unique identifier for each inventory turnover recordunique | INV-0001 |
sku | string | Stock Keeping Unit code uniquely identifying each product | SKU-1001 |
product_name | string | Descriptive name of the product | Wireless Mouse |
category | string | Product category or classification7 categories · optional | Electronics |
warehouse_id | string | Unique identifier for the warehouse location10 warehouses | WH-01 |
warehouse_name | string | Name or description of the warehouse10 names · optional | Central Distribution |
notes | string | Additional comments or notes regarding the SKU's inventory statusoptional | Steady month |
| Numbers 7 columns | |||
opening_inventory_quantity | integer | Quantity of inventory on hand at the start of the period0 or more | 120 |
closing_inventory_quantity | integer | Quantity of inventory on hand at the end of the period0 or more | 80 |
units_received | integer | Total number of units received into inventory during the period0 or more | 60 |
units_sold | integer | Total number of units sold or shipped out during the period0 or more | 100 |
average_inventory_quantity | float | Average inventory quantity during the period, typically calculated as (opening + closing) / 20 or more | 100 |
inventory_turnover_rate | float | Inventory turnover rate for the period (units_sold / average_inventory_quantity)0 or more | 1 |
days_on_hand | float | Average number of days inventory remains in stock (calculated as period length / inventory_turnover_rate)0 or more · optional | 31 |
| Dates and times 3 columns | |||
period_start_date | date | Start date of the reporting period for turnover calculation | 2023-01-01 |
period_end_date | date | End date of the reporting period for turnover calculation | 2023-01-31 |
last_movement_date | date | Date of the last recorded inventory movement (inbound or outbound) for this SKU in this warehouseoptional | 2023-01-30 |
| True or false 1 column | |||
is_slow_moving | boolean | Indicates if the SKU is considered slow-moving based on business-defined thresholdsoptional | false |
Use it for
A logistics dashboard
The is_
slow_ moving rate, average_ inventory_ quantity by category and a breakdown of warehouse_ id. Excel, Power BI or Tableau. Why do 40 of 65 rows have is_
slow_ moving = true? A class exercise
Hand out the rows and one question. Everyone works from the same 65 rows.
- Records65INV-0001100Electron…INV-0002185Electron…INV-000372.5Accessor…
A software demo
Believable records with sku, product_
name and category to fill a screen in front of a buyer.
This dataset65 rows18 columns
Yours1,000 rows18 columns
blueprint · warehouse-inventory-turnover-records
Behind this dataset
Same schema. As many rows as you need.
These 65 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
- Log item receipts and shipments
- Track quantity on hand daily
- Highlight items with <2 turnovers/year
- Link each record to supplier
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-turnover-records