Order Fulfillment Bottleneck Dataset

This dataset provides granular logs of order lifecycles and bottleneck events within fulfillment processes, including timestamps, process steps, responsible teams, and resolution actions. It enables detailed analysis of throughput, delay sources, and process optimization opportunities for logistics and supply chain operations.

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

Identifying and analyzing bottlenecks in order fulfillment processes

Sample rows

preview · 8 of 200 rows · all 25 columns
order_idstringorder_prioritystringorder_total_amountfloatbottleneck_event_typestringcustomer_idstringorder_created_datetimedatetimeorder_statusstringfulfillment_center_idstringexpected_ship_datedateactual_ship_datedateexpected_delivery_datedateactual_delivery_datedatebottleneck_event_idstringbottleneck_event_start_datetimedatetimebottleneck_event_end_datetimedatetimebottleneck_event_duration_minutesfloatprocess_stepstringresponsible_teamstringaddress_streetstringaddress_citystringaddress_statestringaddress_postal_codestringaddress_countrystringbottleneck_event_descriptionstringresolution_actionstring
ORD1001standard78.25blankCUS70012024-05-08T10:23:15ZdeliveredFC-NY12024-05-092024-05-092024-05-122024-05-13blankblankblankblankblankblank314 Oakridge BlvdBrooklynNY11215USAblankblank
ORD1002standard22.5blankCUS70022024-05-09T14:05:41ZplacedFC-TX22024-05-11blank2024-05-14blankblankblankblankblankblankblank1207 Lake View DrAustinTX78704USAblankblank
ORD1003expedited504.99system_delayCUS70032024-05-10T09:14:28ZprocessingFC-CA32024-05-11blank2024-05-15blankBNEVT1012024-05-10T12:30:00Z2024-05-10T16:30:00Z240pickingIT Support701 Mission StSan FranciscoCA94103USAA system outage delayed picking for several hours.Restarted fulfillment system and ran backlog.
ORD1004standard38inventory_shortageCUS70042024-05-11T16:05:18Zcancelledblank2024-05-13blank2024-05-18blankBNEVT1022024-05-12T08:30:00Z2024-05-13T11:00:00Z1530pickingInventory215 Magnolia AveMiamiFL33133USAProduct unavailable due to unexpected demand spike.Order cancelled, customer notified, restock planned.
ORD1005standard120.75blankCUS70012024-05-12T08:11:52ZshippedFC-NY12024-05-132024-05-132024-05-16blankblankblankblankblankblankblank314 Oakridge BlvdBrooklynNY11215USAblankblank
ORD1006standard56.9blankCUS70052024-05-13T13:32:17ZdeliveredFC-IL12024-05-142024-05-152024-05-172024-05-18blankblankblankblankblankblank4900 S Lake Park AveChicagoIL60615USAblankblank
ORD1007standard41.5blankCUS70062024-05-14T18:44:02ZplacedFC-GA22024-05-16blank2024-05-19blankblankblankblankblankblankblank890 Peachtree StAtlantaGA30309USAblankblank
ORD1008high1589.99labor_shortageCUS70072024-05-15T11:20:03ZprocessingFC-WA12024-05-16blank2024-05-21blankBNEVT1032024-05-15T13:30:00Z2024-05-15T16:45:00Z195packingHR1012 Pine StSeattleWA98101USAInsufficient staff available for packing shift.Called in backup staff to resume operations.

What the 200 rows show

from the 200-row sample

High (order priority) stands out: mean order_total_amount is 1,545, against 112.7 for the rest.

  • 68.0median order_total_amount
  • 3process steps
  • 6order statuses
  • 30address states
  • 44fulfillment centers
  • 50address cities
Mean order_total_amount by order_priority175 rows
01,0002,00058.7standard108 rows231.7expedited49 rows1,545high18 rows
order_total_amount200 rows, in bands of 1,000
0951901896301103,0006,000order_total_amount →

Median 68.0, from 0.0 to 5,100.

bottleneck_event_type33 rows with a value · 167 left blank
  1. inventory_shortage9
  2. labor_shortage9
  3. system_delay8
  4. shipping_delay7
25 columns by typefrom the column list below
  • string 16
  • float 2
  • date 4
  • datetime 3

Columns

25 columns in three groups
blueprint · 25 columns
columntypedescriptionexample
Text 16 columns
order_idstringUnique identifier for each order in the system.uniqueORD1001
customer_idstringUnique identifier for the customer placing the order.CUS7001
order_statusstringCurrent status of the order (e.g., placed, processing, shipped, delivered, cancelled).6 valuesdelivered
fulfillment_center_idstringIdentifier for the fulfillment center handling the order.optionalFC-NY1
order_prioritystringPriority level assigned to the order (e.g., standard, expedited, high).standard · expedited · high · optionalstandard
bottleneck_event_idstringUnique identifier for the bottleneck event associated with the order (if any).unique · optionalBNEVT101
bottleneck_event_typestringType of bottleneck event encountered (e.g., inventory shortage, system delay, labor shortage, shipping delay).5 values · optionalsystem_delay
bottleneck_event_descriptionstringDetailed description of the bottleneck event.optionalA system outage delayed p…
process_stepstringOrder fulfillment process step where the bottleneck occurred (e.g., picking, packing, shipping, delivery).picking · packing · shipping · delivery · other · optionalpicking
responsible_teamstringTeam or department responsible for resolving the bottleneck.10 teams · optionalIT Support
resolution_actionstringSummary of the action taken to resolve the bottleneck.optionalRestarted fulfillment sys…
address_streetstringStreet address for order delivery.314 Oakridge Blvd
address_citystringCity for order delivery.Brooklyn
address_statestringState or region for order delivery.NY
address_postal_codestringPostal code for order delivery.11215
address_countrystringCountry for order delivery.USA
Numbers 2 columns
order_total_amountfloatTotal monetary value of the order.0 or more78.25
bottleneck_event_duration_minutesfloatDuration of the bottleneck event in minutes.0 or more · optional240
Dates and times 7 columns
order_created_datetimedatetimeTimestamp when the order was created.2024-05-08T10:23:15Z
expected_ship_datedateDate when the order is expected to be shipped.optional2024-05-09
actual_ship_datedateDate when the order was actually shipped.optional2024-05-09
expected_delivery_datedateDate when the order is expected to be delivered.optional2024-05-12
actual_delivery_datedateDate when the order was actually delivered.optional2024-05-13
bottleneck_event_start_datetimedatetimeTimestamp when the bottleneck event started.optional2024-05-10T12:30:00Z
bottleneck_event_end_datetimedatetimeTimestamp when the bottleneck event ended.optional2024-05-10T16:30:00Z

Use it for

  • median order t…68.0200 rowsmean order total amou…58.7standa…231.7expedi…1.5khigh

    A logistics dashboard

    Order_total_amount by order_priority and a breakdown of bottleneck_event_type. Excel, Power BI or Tableau.

  • Why do the 18 high rows have a mean order_total_amount of 1,545?

    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 orders with customer_id, order_created_datetime and order_status to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 25 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 rows25 columns
Yours1,000 rows25 columnsaddress_street: UK only

blueprint · order-fulfillment-bottleneck-dataset

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 25 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
  • Fulfillment stages clearly delineated
  • Order delays timestamped
  • Product SKUs tracked
  • Resolution times calculated
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
order-fulfillment-bottleneck-dataset

More in Logistics

Browse all
Also in LogisticsE-Commerce-Logistics Inventory IntegrationSupply Chain Inventory MovementsCold Chain Logistics Temperature DataAll 1,958 datasets

What should your data show?

Preview 20 rows free
No signup. No card.