Smart Retail Shelf Stock Analytics

This dataset provides detailed, event-level logs from IoT sensors and cameras monitoring shelf stock levels, product movements, and replenishment activities in digital retail environments. It enables comprehensive analysis for inventory optimization, loss prevention, and operational efficiency, making it invaluable for smart retail management and real-time analytics.

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

Real-time shelf stock monitoring and inventory optimization

Sample rows

preview · 8 of 200 rows · all 18 columns
log_idstringevent_typestringstock_quantityintegerproduct_categorystringstore_idstringshelf_idstringsensor_idstringproduct_idstringproduct_namestringevent_timestampdatetimereplenished_quantityintegermovement_directionstringmovement_quantityintegersensor_typestringsensor_statusstringoperator_idstringlocation_zonestringimage_urlstring
LOG000001stock_level18snacksSTR001SHF01SNSR-A1PRD2001Crispy Chips2024-06-21T08:15:23blankblankblankweight_sensoractiveblankzone_1blank
LOG000002replenishmentblankbeveragesSTR002SHF14SNSR-B3PRD2002Lemon Soda2024-06-21T08:47:0936blankblankRFIDactiveOPR001zone_2blank
LOG000003movementblankhealth_foodSTR003SHF23SNSR-C2PRD2003Protein Bar2024-06-21T09:03:12blankout2cameraactiveblankzone_3https://images.srshelf.com/move/0003.jpg
LOG000004stock_level9beveragesSTR004SHF35SNSR-D1PRD2004Sparkling Water2024-06-21T09:29:45blankblankblankRFIDerrorblankzone_4blank
LOG000005replenishmentblankconfectionerySTR005SHF41SNSR-E2PRD2005Milk Chocolate2024-06-21T09:46:0712blankblankRFIDactiveOPR002zone_5blank
LOG000006movementblankbeveragesSTR006SHF56SNSR-F1PRD2006Organic Tea2024-06-21T09:58:20blankin1cameraactiveblankpromo_zonehttps://images.srshelf.com/move/0006.jpg
LOG000007stock_level54health_foodSTR007SHF61SNSR-G3PRD2007Nut Mix2024-06-21T10:02:17blankblankblankweight_sensoractiveblankzone_6blank
LOG000008replenishmentblanksnacksSTR001SHF02SNSR-A2PRD2008Salted Pretzels2024-06-21T10:15:293blankblankotheractiveOPR003zone_1blank

What the 200 rows show

from the 200-row sample
  • 11.5median stock_quantity
  • 3sensor statuses
  • 4sensor types
  • 5movement directions
  • 8stores
  • 15location zones
event_type200 rows by value
050100100stock_level50%47replenishment24%53movement27%
stock_quantity100 rows, in bands of 100
045908715002000505001,000stock_quantity →

Median 11.5, from 0 to 1,000.

product_category180 rows with a value · 20 left blank
  1. beverages68
  2. health_food46
  3. snacks37
  4. condiments16
  5. confectionery13
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
log_idstringUnique identifier for each sensor or camera log entryuniqueLOG000001
store_idstringUnique identifier for the retail store8 storesSTR001
shelf_idstringUnique identifier for the shelf within the storeSHF01
sensor_idstringUnique identifier for the IoT sensor or camera deviceSNSR-A1
product_idstringUnique identifier for the product being trackedPRD2001
product_namestringName of the productCrispy Chips
product_categorystringCategory of the product (e.g., snacks, beverages)5 categories · optionalsnacks
event_typestringType of event logged (stock_level, replenishment, movement)stock_level · replenishment · movementstock_level
movement_directionstringDirection of product movement (in, out, left, right, unknown)in · out · left · right · unknown · optionalout
sensor_typestringType of sensor or camera (weight_sensor, camera, RFID, other)weight_sensor · camera · RFID · otherweight_sensor
sensor_statusstringOperational status of the sensor (active, inactive, error)active · inactive · error · optionalactive
operator_idstringIdentifier for the staff member responsible for replenishment (if applicable)optionalOPR001
location_zonestringZone or section of the store where the shelf is locatedoptionalzone_1
image_urlstringURL to the image captured by the camera (if available)optionalhttps://images.srshelf.co…
Numbers 3 columns
stock_quantityintegerNumber of product units currently on the shelf at the time of the event0 or more · optional18
replenished_quantityintegerNumber of product units added to the shelf during a replenishment event0 or more · optional36
movement_quantityintegerNumber of product units moved during a movement event1 or more · optional2
Dates and times 1 column
event_timestampdatetimeDate and time when the event was recorded2024-06-21T08:15:23

Use it for

  • median stock q…11.5100 rowsrows by event type100stock_…47replen…53moveme…

    A logistics dashboard

    Stock_quantity by event_type and a breakdown of product_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 logs with store_id, shelf_id and sensor_id 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_zone: UK only

blueprint · smart-retail-shelf-stock-analytics

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
  • Item ID and shelf location mapping
  • Time-stamped restock events
  • Flag stockouts and overstocks
  • Synthetic anonymization
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
smart-retail-shelf-stock-analytics

What should your data show?

Preview 20 rows free
No signup. No card.