Warehouse Pick Path Optimization

This dataset provides detailed event logs of warehouse picker movements, including spatial coordinates, speed, route adherence, and environmental factors. It is ideal for developing AI-powered routing models, analyzing operational efficiency, and identifying bottlenecks or deviations in warehouse picking processes.

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

AI-powered warehouse pick path optimization

Sample rows

preview · 8 of 200 rows · all 19 columns
event_idstringwarehouse_idstringspeedfloatroute_deviationbooleanzone_idstringpicker_idstringtimestampdatetimeaislestringlocation_xfloatlocation_yfloatroute_idstringroute_sequence_numberintegerdeviation_reasonstringpick_task_idstringitem_idstringis_pick_eventbooleanenvironment_temperaturefloatcongestion_levelintegernotesstring
EVT00001WH_A1.5falseZ1PCK0012024-06-10T08:01:00ZA212.37.8RTE_A11blankblankblankfalse18.22blank
EVT00002WH_A1.7falseZ1PCK0022024-06-10T08:02:45ZA41514.2RTE_A12blankPTK10001ITM0001true18.73Normal pick event
EVT00003WH_B2falseZ3PCK0032024-06-10T08:04:30ZA623.59.2RTE_B31blankblankblankfalse204blank
EVT00004WH_B1.4trueZ3PCK0042024-06-10T08:06:20ZA830.212.8RTE_B32Obstacleblankblankfalse20.28Picker stopped due to obstacle blocking aisle A8.
EVT00005WH_C1.8falseZ5PCK0052024-06-10T08:08:05ZA1140.118RTE_C51blankPTK10002ITM0002true21.52Normal pick event
EVT00006WH_C2.2falseZ6PCK0062024-06-10T08:09:40ZA1445.723.3RTE_C61blankblankblankfalse231blank
EVT00007WH_A1.3falseZ2PCK0012024-06-10T08:11:25ZA318.89RTE_A21blankPTK10003ITM0003true19.55Normal pick event
EVT00008WH_D0.3trueZ8PCK0072024-06-10T08:13:10ZA2095.2102.4RTE_D81Congestionblankblankfalse359Heavy congestion caused picker to reroute around zone Z8.

What the 200 rows show

from the 200-row sample

WH_D (warehouse id) stands out: mean speed is 0.76, against 1.4 for the rest.

  • 25%route_deviation = true
  • 1.5median speed
  • 5deviation reasons
  • 22aisles
  • 28routes
  • 47pickers
Mean speed by warehouse_id200 rows
0121.4WH_B58 rows1.6WH_A52 rows1.3WH_C49 rows0.76WH_D41 rows
speed200 rows, in bands of 0.25
020402318733118402329801.252.5speed →

Median 1.5, from 0.0 to 2.5.

zone_id182 rows with a value · 18 left blank
  1. Z725
  2. Z824
  3. Z423
  4. Z322
  5. Z521
  6. Z221
  7. Z617
  8. Z116
  9. Z109
  10. Z94
19 columns by typefrom the column list below
  • string 10
  • integer 2
  • float 4
  • datetime 1
  • boolean 2

Columns

19 columns in four groups
blueprint · 19 columns
columntypedescriptionexample
Text 10 columns
event_idstringUnique identifier for each picker movement event log entryuniqueEVT00001
picker_idstringUnique identifier for the warehouse pickerPCK001
warehouse_idstringUnique identifier for the warehouse location4 warehousesWH_A
zone_idstringIdentifier for the specific zone or area within the warehouse10 zones · optionalZ1
aislestringAisle identifier where the picker is located during the eventoptionalA2
route_idstringIdentifier for the planned pick route assigned to the pickerRTE_A1
deviation_reasonstringReason for route deviation (if any), e.g., obstacle, congestion, manual override5 reasons · optionalObstacle
pick_task_idstringIdentifier for the pick task associated with this event (if applicable)optionalPTK10001
item_idstringIdentifier for the item being picked (if applicable)optionalITM0001
notesstringAdditional notes or comments about the eventoptionalNormal pick event
Numbers 6 columns
location_xfloatX coordinate of the picker’s position in the warehouse (meters)12.3
location_yfloatY coordinate of the picker’s position in the warehouse (meters)7.8
speedfloatPicker’s movement speed at the event timestamp (meters per second)0 or more1.5
route_sequence_numberintegerSequence number indicating the step/order of the picker on the route1 or more1
environment_temperaturefloatTemperature in the warehouse zone at the time of the event (Celsius)optional18.2
congestion_levelintegerLevel of congestion in the picker’s area (scale 0-10)0 to 10 · optional2
Dates and times 1 column
timestampdatetimeDate and time when the event was recorded2024-06-10T08:01:00Z
True or false 2 columns
route_deviationbooleanIndicates if the picker deviated from the planned route at this eventfalse
is_pick_eventbooleanIndicates whether this event corresponds to an actual item pickfalse

Use it for

  • route deviation25%49 of 200 rowsmean speed by warehou…1.4WH_B1.6WH_A1.3WH_C0.76WH_D

    A logistics dashboard

    The route_deviation rate, speed by warehouse_id and a breakdown of zone_id. Excel, Power BI or Tableau.

  • Why do the 41 WH_D rows have a mean speed of 0.76?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable events with picker_id, timestamp and warehouse_id to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 19 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 rows19 columns
Yours1,000 rows19 columnslocation_x: UK only

blueprint · warehouse-pick-path-optimization

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 19 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
  • Event: pick, drop, move, idle time
  • Route deviation and speed flags
  • Time-stamped per picker/shift
  • 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
warehouse-pick-path-optimization

More in Logistics

Browse all
Also in LogisticsWarehouse Inventory Movement LogCold Chain Logistics Temperature DataWarehouse Inventory Flow DatasetAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.