Warehouse Picking Error Dataset

This dataset provides granular records of warehouse picking events, including error flags, types, and resolutions, along with picker and supervisor identifiers, item details, and timing metrics. It enables comprehensive analysis of operational efficiency, error patterns, and process improvements in warehouse management. Ideal for logistics optimization, workforce training evaluation, and root cause analysis.

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

Warehouse efficiency and error rate analysis

Sample rows

preview · 8 of 200 rows · all 16 columns
pick_event_idstringerror_typestringpick_duration_secondsfloatpick_error_flagbooleanwarehouse_idstringpicker_idstringpick_datetimedatetimeorder_idstringitem_skustringquantity_pickedintegerlocation_codestringsupervisor_idstringis_training_pickbooleanitem_descriptionstringerror_descriptionstringcorrective_action_takenstring
PEV0001blank25.7falseWH001EMP10012023-12-31T23:59:59ZORD1000001SKU-A1231WH001_B12-07blankfalsePremium wireless mouse, ergonomic designblankblank
PEV0002blank41.4falseWH002EMP10022024-02-29T06:13:17ZORD1000002SKU-B2312WH002_C03-15blankfalseblankblankblank
PEV0003blank22falseWH003EMP10032024-03-05T09:14:51ZORD1000003SKU-C0021WH003_D09-08blanktrueUSB-C charging cable for smartphonesblankblank
PEV0004blank33.8falseWH004EMP10042024-04-14T08:45:20ZORD1000004SKU-D3443WH004_A16-02blanktrueblankblankblank
PEV0005blank18.5falseWH005EMP10052024-03-10T17:32:08ZORD1000005SKU-E5551WH005_B05-12blankfalseAdjustable laptop stand, silver finishblankblank
PEV0006blank135.3falseWH001EMP10062024-01-21T14:06:44ZORD1000006SKU-F77615WH001_C08-19blankfalseBluetooth speaker, waterproof, portableblankblank
PEV0007blank350.9falseWH002EMP10072024-01-29T07:58:36ZORD1000007SKU-G10250WH002_E17-03blankfalseWireless gaming headset, noise-cancellingblankblank
PEV0008blank21.3falseWH003EMP10082024-03-19T12:19:02ZORD1000008SKU-H0531WH003_A11-10blankfalseDesk lamp with USB port, LED lightingblankblank

What the 200 rows show

from the 200-row sample
  • 7%pick_error_flag = true
  • 31.4median pick_duration_seconds
  • 1median quantity_picked
error_type13 rows by value
0243wrong_…2%3wrong_…2%2wrong_…1%3damage…2%2other1%
pick_duration_seconds200 rows, in bands of 100
010020019170100000105001,000pick_duration_seconds →

Median 31.4, from 10.3 to 910.6.

warehouse_id200 rows · 10 values
  1. WH00532
  2. WH00231
  3. WH00330
  4. WH00129
  5. WH00428
  6. WHSEA0211
  7. WHDAL0510
  8. WHLAX0110
  9. WHNYC0310
  10. WHMIA049
16 columns by typefrom the column list below
  • string 11
  • integer 1
  • float 1
  • datetime 1
  • boolean 2

Columns

16 columns in four groups
blueprint · 16 columns
columntypedescriptionexample
Text 11 columns
pick_event_idstringUnique identifier for each pick eventuniquePEV0001
warehouse_idstringIdentifier for the warehouse where the pick event occurred10 warehousesWH001
picker_idstringUnique identifier for the employee who performed the pickEMP1001
order_idstringIdentifier for the customer order associated with the pick eventORD1000001
item_skustringStock Keeping Unit (SKU) of the item pickedSKU-A123
item_descriptionstringShort description of the item pickedoptionalPortable SSD, 1TB, USB-C
location_codestringCode representing the storage location from which the item was pickedWH001_B12-07
error_typestringType of error encountered (e.g., wrong item, wrong quantity, wrong location, damaged item)5 values · optionalwrong_item
error_descriptionstringDetailed description of the error, if anyoptionalPicked incorrect item, SK…
corrective_action_takenstringDescription of any corrective action taken to resolve the erroroptionalReturned item to location…
supervisor_idstringIdentifier for the supervisor who reviewed or approved the corrective actionoptionalEMP2001
Numbers 2 columns
quantity_pickedintegerNumber of units picked during the event1 or more1
pick_duration_secondsfloatTime taken to complete the pick event, in seconds0 or more · optional25.7
Dates and times 1 column
pick_datetimedatetimeDate and time when the pick event occurred2023-12-31T23:59:59Z
True or false 2 columns
pick_error_flagbooleanIndicates if an error occurred during picking (true if error, false otherwise)false
is_training_pickbooleanIndicates if the pick event was performed during trainingoptionalfalse

Use it for

  • pick error flag7%13 of 200 rowsmean pick duration se…54.3wron…64.5wron…53.1wron…60.5dama…

    A logistics dashboard

    The pick_error_flag rate, pick_duration_seconds by error_type and a breakdown of warehouse_id. Excel, Power BI or Tableau.

  • Why do 13 of 200 rows have pick_error_flag = true?

    A class exercise

    Hand out the rows and one question. Everyone works from the same 200 rows.

  • A software demo

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

Not quite right?

Make it yours.

Same 16 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 rows16 columns
Yours1,000 rows16 columnslocation_code: UK only

blueprint · warehouse-picking-error-dataset

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 16 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
  • Picker ID and shift recorded
  • Product location accuracy validated
  • Error type classified
  • Correction actions logged
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-picking-error-dataset

What should your data show?

Preview 20 rows free
No signup. No card.