E-commerce Reverse Logistics Tracking

This dataset provides detailed tracking of e-commerce product returns, capturing every stage from customer initiation to warehouse processing and final disposition. It includes return reasons, statuses, financial details, and logistics data, enabling retailers to analyze and optimize reverse logistics operations for improved efficiency and customer satisfaction.

  • last updated 26 Jan 2026
  • by GoMask
The brief that made it

Monitor and optimize reverse logistics workflows for e-commerce businesses

Sample rows

preview · 8 of 120 rows · all 27 columns
return_idstringreturn_shipping_carrierstringreturn_shipping_costfloatwarehouse_statestringorder_idstringcustomer_idstringproduct_idstringproduct_namestringskustringreturn_request_datedatetimereturn_approval_datedatetimereturn_received_datedatetimereturn_statusstringreturn_reasonstringreturn_reason_categorystringquantity_returnedintegerunit_pricefloatrefund_amountfloatrefund_issued_datedatetimedisposition_outcomestringreturn_tracking_numberstringwarehouse_idstringwarehouse_citystringwarehouse_countrystringinspected_bystringinspection_datedatetimeinspection_notesstring
RET20240001UPS11.75CAORD20240001CUST0001PROD0001Wireless Bluetooth Headphones BlackHEAD-BLK-WRLS2024-05-01T09:33:00Z2024-05-01T14:55:00Z2024-05-04T11:22:00ZInspectedHeadphones do not charge properlyDefective168.9968.992024-05-06T10:15:00ZReturned to Vendor1Z999AA10123456784WH001Los AngelesUSAemp10242024-05-05T13:40:00ZConfirmed battery defect, no visible damage.
RET20240002USPS7.25ILORD20240002CUST0002PROD0002Women's Running Shoes Size 8SHOE-WRN-82024-04-20T16:10:00Z2024-04-20T18:30:00Z2024-04-23T12:02:00ZCompletedShoes were too small despite correct sizeSize Issue189.589.52024-04-24T09:20:00ZRestocked940011189922384723WH002ChicagoUSAemp11022024-04-23T16:45:00ZProduct unworn, all tags present.
RET20240003FedEx13.25TXORD20240003CUST0003PROD0003Ceramic Cooking Pot 4L GrayPOT-GRY-4L2024-05-09T13:11:00Z2024-05-09T15:00:00Z2024-05-13T10:28:00ZCompletedChanged mind, ordered another color insteadChanged Mind136.9936.992024-05-14T08:40:00ZRestocked7778854321998765WH003DallasUSAemp10472024-05-13T13:10:00ZPot unused, packaging intact.
RET20240004USPSblankblankORD20240004CUST0004PROD0004Yoga Mat Non-Slip Blueblank2024-05-05T07:50:00Z2024-05-05T11:12:00ZblankApprovedMat arrived too late for scheduled classLate Delivery129.99blankblankOtherblankblankblankblankblankblankblank
RET20240005FedEx7.8GAORD20240005CUST0005PROD0005Digital Kitchen Scale Stainless SteelDGS-STL-SS2024-04-14T10:04:00Z2024-04-14T14:32:00Z2024-04-17T09:50:00ZInspectedScale shows inaccurate readingsDefective125.925.92024-04-19T12:20:00ZDisposed12345678880123456789WH004AtlantaUSAemp10982024-04-17T14:00:00ZConfirmed display malfunction, not salvageable.
RET20240006USPS5.25WAORD20240006CUST0006PROD0006Smartphone Case Silicone GreenCASE-GRN-SIL2024-05-12T18:20:00Z2024-05-12T20:10:00Z2024-05-15T13:55:00ZReceivedOrdered wrong phone model caseWrong Item114.5blankblankOther940011189922384724WH005SeattleUSAblankblankblank
RET20240007FedEx6.4COORD20240007CUST0007PROD0007Classic White Puzzle 1000 PiecesPUZ-WHT-10002024-04-28T14:30:00Z2024-04-28T15:12:00Z2024-05-01T10:12:00ZInspectedPuzzle missing several piecesDefective117.9517.952024-05-02T09:36:00ZDisposed7778854321998766WH006DenverUSAemp11112024-05-01T13:10:00ZConfirmed missing pieces, not restockable.
RET20240008UPS8.5CAORD20240008CUST0008PROD0008Men's Slim Fit Jeans Size 32JEANS-M32-SLIM2024-04-13T12:21:00Z2024-04-13T15:45:00Z2024-04-17T11:10:00ZCompletedColor does not match website photosOther148482024-04-18T12:00:00ZRestocked1Z999AA10123456785WH007San FranciscoUSAemp11512024-04-17T14:44:00ZProduct unworn, restocked.

What the 120 rows show

from the 120-row sample

USPS (return shipping carrier) stands out: mean return_shipping_cost is 5.8, against 9.3 for the rest.

  • 7.5median return_shipping_cost
  • 6return reason categories
  • 6disposition outcomes
  • 7return statuses
  • 1median quantity_returned
  • 33.0median unit_price
Mean return_shipping_cost by return_shipping_carrier97 rows
05105.8USPS27 rows9.3FedEx31 rows9.2UPS27 rows9.4DHL12 rows
return_shipping_cost97 rows, in bands of 5
03570116815200102035return_shipping_cost →

Median 7.5, from 3.9 to 34.8.

warehouse_state90 rows with a value · 30 left blank
  1. CA12
  2. TX10
  3. IL6
  4. WA5
  5. FL5
  6. NY5
  7. GA4
  8. OH4
  9. MO4
  10. MA3
27 columns by typefrom the column list below
  • string 18
  • integer 1
  • float 3
  • datetime 5

Columns

27 columns in three groups
blueprint · 27 columns
columntypedescriptionexample
Text 18 columns
return_idstringUnique identifier for each return transactionuniqueRET20240001
order_idstringIdentifier for the original order associated with the returnORD20240001
customer_idstringUnique identifier for the customer initiating the returnCUST0001
product_idstringUnique identifier for the returned productPROD0001
product_namestringName or description of the returned productYoga Mat Non-Slip Blue
skustringStock Keeping Unit for the returned productoptionalHEAD-BLK-WRLS
return_statusstringCurrent status of the return process8 valuesInspected
return_reasonstringReason provided by the customer for returning the productOrdered wrong size
return_reason_categorystringCategorized reason for return (e.g., Defective, Wrong Item, Changed Mind, Size Issue, Other)6 valuesDefective
disposition_outcomestringFinal outcome for the returned product (e.g., Restocked, Refurbished, Disposed, Donated, Returned to Vendor)6 valuesReturned to Vendor
return_shipping_carrierstringName of the carrier used for return shipping4 carriers · optionalUPS
return_tracking_numberstringTracking number for the return shipmentoptional1Z999AA10123456784
warehouse_idstringIdentifier for the warehouse or return center receiving the returned productoptionalWH001
warehouse_citystringCity where the warehouse or return center is locatedoptionalLos Angeles
warehouse_statestringState or province of the warehouse or return centeroptionalCA
warehouse_countrystringCountry of the warehouse or return centeroptionalUSA
inspected_bystringIdentifier or name of the staff member who inspected the returned productoptionalemp1024
inspection_notesstringAdditional notes or comments from the inspection processoptionalUnworn, restocked.
Numbers 4 columns
quantity_returnedintegerNumber of units of the product being returned1 or more1
unit_pricefloatUnit price of the returned product at the time of purchase0 or more68.99
refund_amountfloatAmount refunded to the customer for the return0 or more · optional68.99
return_shipping_costfloatCost incurred for shipping the returned product0 or more · optional11.75
Dates and times 5 columns
return_request_datedatetimeDate and time when the return was requested by the customer2024-05-01T09:33:00Z
return_approval_datedatetimeDate and time when the return was approved by the retaileroptional2024-05-01T14:55:00Z
return_received_datedatetimeDate and time when the returned product was received at the warehouse or return centeroptional2024-05-04T11:22:00Z
refund_issued_datedatetimeDate and time when the refund was issued to the customeroptional2024-05-06T10:15:00Z
inspection_datedatetimeDate and time when the returned product was inspectedoptional2024-05-05T13:40:00Z

Use it for

  • median return …7.597 rowsmean return shipping …5.8USPS9.3FedEx9.2UPS9.4DHL

    A logistics dashboard

    Return_shipping_cost by return_shipping_carrier and a breakdown of warehouse_state. Excel, Power BI or Tableau.

  • Why do the 27 USPS rows have a mean return_shipping_cost of 5.8?

    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 returns with order_id, customer_id and product_id to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 27 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 dataset120 rows27 columns
Yours1,000 rows27 columnswarehouse_city: UK only

blueprint · e-commerce-reverse-logistics-tracking

Behind this dataset

Same schema. As many rows as you need.

These 120 rows came out of a blueprint — 27 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
  • Every returned item must have a unique return ID.
  • Returns are classified by reason: defect, buyer remorse, wrong item, or warranty.
  • Return disposition must be marked as restocked, recycled, or disposed.
  • Each entry includes timestamps for initiation, receipt, and resolution.
  • Return shipping cost is documented for each transaction.
Rows
Open the blueprint in Data Factory

1 credit per row. New accounts start with 25 free credits.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
e-commerce-reverse-logistics-tracking

More in Logistics

Browse all
Also in LogisticsE-Commerce Delivery Exceptions DatasetLogistics Shipment Delay PredictionCold Chain Logistics Temperature LogsAll 1,954 datasets

What should your data show?

Preview 20 rows free
No signup. No card.