E-commerce Reverse Logistics Bottleneck Data
This dataset provides detailed, event-level tracking of e-commerce product returns and exchanges, capturing key timestamps, process stages, bottlenecks, and resource constraints. It enables supply chain managers to identify inefficiencies, analyze delays, and optimize reverse logistics workflows for improved customer satisfaction and cost control.
Sample rows
preview · 8 of 68 rows · all 22 columns| return_idstring | return_shipping_methodstring | return_shipping_costfloat | process_inefficiency_flagboolean | resource_constraintstring | order_idstring | customer_idstring | product_idstring | return_request_datedatetime | return_approval_datedatetime | product_pickup_datedatetime | warehouse_received_datedatetime | inspection_completed_datedatetime | refund_processed_datedatetime | return_statusstring | return_reasonstring | bottleneck_stagestring | bottleneck_duration_hoursfloat | customer_satisfaction_ratinginteger | return_typestring | warehouse_idstring | bottleneck_descriptionstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RET20240601-001 | courier pickup | 5.99 | true | vehicle unavailability | ORD123456 | CUST3321 | PROD-A1001 | 2024-06-01T09:15:00 | 2024-06-01T13:45:00 | 2024-06-02T10:30:00 | 2024-06-03T15:10:00 | 2024-06-03T16:30:00 | 2024-06-03T17:20:00 | refund_processed | Received wrong size | pickup | 8.5 | 3 | return | WH-ATL-01 | Courier delayed pickup due to route issues |
| RET20240601-002 | drop-off at store | 0 | false | blank | ORD123457 | CUST7722 | PROD-B2040 | 2024-06-01T11:07:00 | 2024-06-01T14:06:00 | 2024-06-02T09:00:00 | 2024-06-03T13:50:00 | 2024-06-03T14:30:00 | 2024-06-03T16:10:00 | refund_processed | Product defective | none | blank | 5 | return | WH-NYC-02 | blank |
| RET20240601-003 | courier pickup | 6.5 | true | staff shortage | ORD123458 | CUST1824 | PROD-C3302 | 2024-06-01T12:50:00 | blank | blank | blank | blank | blank | requested | Changed mind | approval | 26 | 2 | return | WH-CHI-01 | Approval delayed due to high volume |
| RET20240601-004 | courier pickup | 5.49 | true | staff shortage | ORD123459 | CUST5503 | PROD-B2040 | 2024-06-01T13:20:00 | 2024-06-01T16:00:00 | 2024-06-02T08:30:00 | 2024-06-03T10:40:00 | 2024-06-03T17:00:00 | blank | inspected | Product not as described | inspection | 7.5 | 4 | return | WH-DAL-03 | Inspection backlog due to limited staff |
| RET20240601-005 | drop-off at store | 0 | false | blank | ORD123460 | CUST8821 | PROD-D4501 | 2024-06-02T09:45:00 | 2024-06-02T10:30:00 | blank | blank | blank | blank | approved | Received damaged item | none | blank | 4 | exchange | WH-ATL-01 | blank |
| RET20240601-006 | courier pickup | 6.99 | true | system outage | ORD123461 | CUST3321 | PROD-E5010 | 2024-06-02T12:23:00 | 2024-06-02T13:45:00 | 2024-06-03T09:40:00 | 2024-06-03T16:30:00 | blank | blank | received_at_warehouse | Item too small | warehouse_receipt | 4.2 | 3 | return | WH-NYC-02 | Warehouse receiving delayed due to system outage |
| RET20240601-007 | courier pickup | 5.75 | true | vehicle unavailability | ORD123462 | CUST1824 | PROD-F6022 | 2024-06-02T14:05:00 | 2024-06-02T15:00:00 | 2024-06-03T10:10:00 | 2024-06-04T13:20:00 | blank | blank | received_at_warehouse | Product defective | pickup | 10 | 2 | return | WH-CHI-01 | Pickup rescheduled due to vehicle breakdown |
| RET20240601-008 | drop-off at store | 0 | false | blank | ORD123463 | CUST5503 | PROD-G7014 | 2024-06-03T08:55:00 | 2024-06-03T09:30:00 | 2024-06-03T13:00:00 | 2024-06-04T09:10:00 | 2024-06-04T11:30:00 | blank | inspected | Wrong item delivered | none | blank | 5 | exchange | WH-DAL-03 | blank |
| RET20240601-009 | courier pickup | 5.99 | true | system outage | ORD123464 | CUST8821 | PROD-H8200 | 2024-06-03T10:40:00 | 2024-06-03T14:25:00 | 2024-06-04T09:30:00 | 2024-06-05T12:10:00 | 2024-06-05T13:05:00 | 2024-06-05T14:50:00 | refund_processed | Product defective | refund_processing | 3.6 | 2 | return | WH-ATL-01 | Refund processing delayed due to banking error |
| RET20240601-010 | drop-off at store | 0 | false | blank | ORD123465 | CUST3321 | PROD-I9208 | 2024-06-03T12:15:00 | 2024-06-03T13:50:00 | 2024-06-04T08:50:00 | 2024-06-04T14:10:00 | 2024-06-04T15:45:00 | 2024-06-04T16:50:00 | refund_processed | Not as pictured | none | blank | 4 | return | WH-NYC-02 | blank |
| RET20240601-011 | courier pickup | 5.25 | true | staff shortage | ORD123466 | CUST7722 | PROD-J1011 | 2024-06-03T13:34:00 | blank | blank | blank | blank | blank | requested | Product not needed | approval | 15.5 | 3 | exchange | WH-CHI-01 | Approval process slow due to missing documentation |
| RET20240601-012 | drop-off at store | 0 | false | blank | ORD123467 | CUST1824 | PROD-K2022 | 2024-06-04T09:00:00 | 2024-06-04T11:35:00 | 2024-06-04T16:00:00 | 2024-06-05T12:45:00 | 2024-06-05T13:30:00 | 2024-06-05T15:55:00 | refund_processed | Received wrong color | none | blank | 5 | return | WH-DAL-03 | blank |
| RET20240601-013 | courier pickup | 6.45 | true | staff shortage | ORD123468 | CUST5503 | PROD-L3333 | 2024-06-04T10:40:00 | 2024-06-04T12:10:00 | 2024-06-05T09:30:00 | 2024-06-05T13:50:00 | 2024-06-05T14:40:00 | blank | inspected | Product not as described | inspection | 6.3 | 3 | exchange | WH-ATL-01 | Inspection delayed due to limited staff |
| RET20240601-014 | drop-off at store | 0 | false | blank | ORD123469 | CUST8821 | PROD-M4044 | 2024-06-04T12:20:00 | 2024-06-04T13:10:00 | blank | blank | blank | blank | approved | Wrong item shipped | none | blank | 4 | return | WH-NYC-02 | blank |
| RET20240601-015 | courier pickup | 5.8 | true | staff shortage | ORD123470 | CUST3321 | PROD-N5055 | 2024-06-04T14:02:00 | 2024-06-04T16:40:00 | 2024-06-05T10:35:00 | 2024-06-05T15:15:00 | blank | blank | received_at_warehouse | Item too large | warehouse_receipt | 5.7 | 2 | return | WH-CHI-01 | Warehouse receiving delayed due to staff shortage |
| RET20240601-016 | courier pickup | 6.29 | true | vehicle unavailability | ORD123471 | CUST7722 | PROD-O6066 | 2024-06-05T08:30:00 | 2024-06-05T10:00:00 | 2024-06-05T13:40:00 | 2024-06-06T09:00:00 | blank | blank | received_at_warehouse | Product not as pictured | pickup | 9.1 | 3 | exchange | WH-DAL-03 | Pickup delayed due to vehicle breakdown |
| RET20240601-017 | courier pickup | 5.99 | true | staff shortage | ORD123472 | CUST1824 | PROD-P7077 | 2024-06-05T10:15:00 | blank | blank | blank | blank | blank | requested | Changed mind | approval | 12.7 | 2 | return | WH-ATL-01 | Approval delayed due to backlog |
| RET20240601-018 | drop-off at store | 0 | false | blank | ORD123473 | CUST5503 | PROD-Q8088 | 2024-06-05T11:30:00 | 2024-06-05T12:20:00 | 2024-06-05T16:40:00 | 2024-06-06T10:20:00 | 2024-06-06T12:30:00 | blank | inspected | Received damaged item | none | blank | 5 | return | WH-NYC-02 | blank |
| RET20240601-019 | courier pickup | 5.35 | true | system outage | ORD123474 | CUST8821 | PROD-R9099 | 2024-06-05T13:05:00 | 2024-06-05T14:30:00 | 2024-06-06T09:55:00 | 2024-06-06T14:30:00 | blank | blank | received_at_warehouse | Product defective | warehouse_receipt | 3.8 | 2 | exchange | WH-CHI-01 | Warehouse receiving delayed due to system outage |
| RET20240601-020 | drop-off at store | 0 | false | blank | ORD123475 | CUST3321 | PROD-S1112 | 2024-06-06T09:40:00 | 2024-06-06T10:10:00 | 2024-06-06T12:30:00 | 2024-06-07T09:20:00 | 2024-06-07T10:30:00 | 2024-06-07T11:45:00 | refund_processed | Item too small | none | blank | 4 | return | WH-DAL-03 | blank |
What the 68 rows show
from the 68-row sampleCourier pickup (return shipping method) stands out: mean return_
- 62%process_
inefficiency_ flag = true - 6.0median return_
shipping_ cost - 2return types
- 5return statuses
- 6bottleneck stages
- 7warehouses
Median 6.0, from 0.0 to 10.8.
- string 12
- integer 1
- float 2
- datetime 6
- boolean 1
Columns
22 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 12 columns | |||
return_id | string | Unique identifier for each product return or exchange eventunique | RET20240601-001 |
order_id | string | Identifier for the original customer order associated with the return | ORD123456 |
customer_id | string | Unique identifier for the customer initiating the return | CUST3321 |
product_id | string | Unique identifier for the product being returned or exchanged | PROD-A1001 |
return_status | string | Current status of the return process8 values | refund_processed |
return_reason | string | Reason provided by the customer for returning or exchanging the productoptional | Received wrong size |
bottleneck_stage | string | Stage in the reverse logistics process where a bottleneck or delay occurred6 values · optional | pickup |
bottleneck_description | string | Detailed description of the bottleneck, delay, or process inefficiency encounteredoptional | Payment gateway delay |
resource_constraint | string | Type of resource constraint encountered (e.g., staff shortage, vehicle unavailability)5 constraints · optional | vehicle unavailability |
return_type | string | Indicates if the process was a return or an exchangereturn · exchange | return |
return_shipping_method | string | Method by which the product was returned (e.g., courier pickup, drop-off at store)2 methods · optional | courier pickup |
warehouse_id | string | Identifier for the warehouse or returns center handling the product7 warehouses · optional | WH-ATL-01 |
| Numbers 3 columns | |||
bottleneck_duration_hours | float | Duration of the bottleneck or delay at the specified stage, in hours0 or more · optional | 8.5 |
customer_satisfaction_rating | integer | Customer satisfaction rating for the return process (1-5 scale)1 to 5 · optional | 3 |
return_shipping_cost | float | Cost incurred for shipping the returned product0 or more · optional | 5.99 |
| Dates and times 6 columns | |||
return_request_date | datetime | Timestamp when the customer initiated the return or exchange request | 2024-06-01T09:15:00 |
return_approval_date | datetime | Timestamp when the return request was approved by the e-commerce teamoptional | 2024-06-01T13:45:00 |
product_pickup_date | datetime | Timestamp when the product was picked up from the customer or drop-off was confirmedoptional | 2024-06-02T10:30:00 |
warehouse_received_date | datetime | Timestamp when the returned product was received at the warehouse or returns centeroptional | 2024-06-03T15:10:00 |
inspection_completed_date | datetime | Timestamp when the returned product was inspected for quality and eligibilityoptional | 2024-06-03T16:30:00 |
refund_processed_date | datetime | Timestamp when the refund or exchange was processed for the customeroptional | 2024-06-03T17:20:00 |
| True or false 1 column | |||
process_inefficiency_flag | boolean | Indicates if a process inefficiency was identified during the return workflowoptional | true |
Use it for
A logistics dashboard
The process_
inefficiency_ flag rate, return_ shipping_ cost by return_ shipping_ method and a breakdown of resource_ constraint. Excel, Power BI or Tableau. Why do the 45 courier pickup rows have a mean return_
shipping_ cost of 7.6? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Returns68RET20240601-0015.99courier …RET20240601-0020drop-off…RET20240601-0036.5courier …
A software demo
Believable returns with order_
id, customer_ id and product_ id to fill a screen in front of a buyer.
This dataset68 rows22 columns
Yours1,000 rows22 columns
blueprint · e-commerce-reverse-logistics-bottleneck-data
Behind this dataset
Same schema. As many rows as you need.
These 68 rows came out of a blueprint — 22 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
- Include timestamps for each logistics stage (initiation, transit, receipt, resolution)
- Flag returns delayed beyond SLA thresholds
- Track reason codes for each return event
- Record staff assignment and resolution actions per case
- Capture item condition upon return
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
- e-commerce-reverse-logistics-bottleneck-data