Online Retail Product Return Analytics
This dataset provides detailed, flat records of e-commerce product returns, including transaction details, customer demographics, product information, and reasons for return. It is designed for supply chain optimization, quality improvement, and customer experience analysis, enabling granular insights into return patterns and drivers across products and customer segments.
Sample rows
preview · 8 of 200 rows · all 22 columns| return_idstring | product_categorystring | customer_ageinteger | is_first_returnboolean | customer_countrystring | order_idstring | product_idstring | customer_idstring | return_datedate | purchase_datedate | time_to_return_daysinteger | return_reasonstring | return_statusstring | refund_amountfloat | product_namestring | customer_emailstring | customer_genderstring | customer_citystring | customer_statestring | customer_postal_codestring | return_methodstring | product_pricefloat |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RET100001 | electronics | 34 | true | USA | ORD2000011 | PROD-ELEC0011 | CUS3000111 | 2023-04-19 | 2023-03-29 | 21 | defective | completed | 449.99 | UltraHD Smart TV 55in | eric.smith@ | male | San Francisco | CA | 94105 | 449.99 | |
| RET100002 | apparel | 28 | true | UK | ORD2000012 | PROD-APP0021 | CUS3000122 | 2024-01-22 | 2024-01-15 | 7 | size issue | approved | 39.99 | Womens Summer Dress L | emma.jones@ | female | London | London | SW1A1AA | in-store | 39.99 |
| RET100003 | home | 53 | false | Germany | ORD2000013 | PROD-HOME0041 | CUS3000133 | 2022-11-12 | 2022-10-25 | 18 | not as described | completed | 125 | Modern Floor Lamp Black | lucas.meyer@ | male | Berlin | Berlin | 10115 | 125 | |
| RET100004 | apparel | 24 | true | Australia | ORD2000014 | PROD-APP0022 | CUS3000144 | 2023-09-14 | 2023-09-03 | 11 | wrong item | approved | 25.99 | Mens Cotton T-Shirt M | liam.turner@ | male | Sydney | NSW | 2000 | 25.99 | |
| RET100005 | electronics | 38 | false | China | ORD2000015 | PROD-ELEC0012 | CUS3000155 | 2023-07-21 | 2023-06-01 | 50 | buyer remorse | completed | 299 | Bluetooth Speaker X2 | olivia.chen@ | female | Shanghai | Shanghai | 200120 | pickup | 299 |
| RET100006 | apparel | 19 | true | USA | ORD2000016 | PROD-APP0023 | CUS3000166 | 2024-02-01 | 2024-01-29 | 3 | size issue | pending | blank | Kids Hoodie Red XS | mia.harris@ | female | Miami | FL | 33101 | 19.99 | |
| RET100007 | electronics | 41 | false | USA | ORD2000017 | PROD-ELEC0013 | CUS3000177 | 2023-12-15 | 2023-12-10 | 5 | defective | completed | 1299.99 | Gaming Laptop 16GB RAM | benjamin.davis@ | male | Chicago | IL | 60601 | 1299.99 | |
| RET100008 | home | 66 | false | France | ORD2000018 | PROD-HOME0042 | CUS3000188 | 2022-09-02 | 2022-08-22 | 11 | late delivery | rejected | 0 | Ceramic Vase Blue Large | marie.dubois@ | female | Paris | Ile-de-France | 75001 | 54.99 | |
| RET100009 | electronics | 22 | true | UK | ORD2000019 | PROD-ELEC0014 | CUS3000199 | 2023-06-10 | 2023-06-09 | 1 | not as described | completed | 89 | Wireless Earbuds S6 | daniel.brown@ | male | Leeds | West Yorkshire | LS13JE | in-store | 89 |
| RET100010 | apparel | 35 | true | USA | ORD2000020 | PROD-APP0024 | CUS3000200 | 2023-05-12 | 2023-05-02 | 10 | wrong item | completed | 59.99 | Mens Slim Jeans 32 | jake.wood@ | male | San Francisco | CA | 94107 | 59.99 | |
| RET100011 | home | 45 | false | Canada | ORD2000021 | PROD-HOME0043 | CUS3000211 | 2023-08-20 | 2023-08-09 | 11 | buyer remorse | completed | 349.99 | Espresso Coffee Maker | sophia.miller@ | female | Toronto | Ontario | M5H2N2 | pickup | 349.99 |
| RET100012 | electronics | 36 | false | USA | ORD2000022 | PROD-ELEC0015 | CUS3000222 | 2023-10-03 | 2023-09-28 | 5 | defective | approved | 149.99 | Portable Projector Mini | jack.wilson@ | male | Miami | FL | 33131 | 149.99 | |
| RET100013 | apparel | 27 | true | UK | ORD2000023 | PROD-APP0025 | CUS3000233 | 2023-02-16 | 2023-02-13 | 3 | not as described | completed | 49.99 | Womens Cardigan S | chloe.evans@ | female | Bristol | Bristol | BS12BT | 49.99 | |
| RET100014 | home | 52 | false | Spain | ORD2000024 | PROD-HOME0044 | CUS3000244 | 2023-03-25 | 2023-03-13 | 12 | defective | completed | 199.99 | Robot Vacuum Cleaner | monica.rodriguez@ | female | Madrid | Madrid | 28013 | 199.99 | |
| RET100015 | electronics | 40 | true | USA | ORD2000025 | PROD-ELEC0016 | CUS3000255 | 2023-12-28 | 2023-12-25 | 3 | wrong item | approved | 69.99 | Smartwatch Pro 2023 | oliver.moore@ | male | New York | NY | 10001 | in-store | 69.99 |
| RET100016 | apparel | 17 | true | Ireland | ORD2000026 | PROD-APP0026 | CUS3000266 | 2023-07-10 | 2023-06-29 | 11 | size issue | completed | 19.99 | Kids Sneakers 3Y | lucy.clark@ | female | Dublin | Leinster | D02X285 | 19.99 | |
| RET100017 | home | 82 | false | Germany | ORD2000027 | PROD-HOME0045 | CUS3000277 | 2023-01-15 | 2022-01-15 | 365 | other | rejected | 0 | Vintage Wall Clock | martin.schmidt@ | male | Berlin | Berlin | 10557 | 75 | |
| RET100018 | electronics | 29 | true | USA | ORD2000028 | PROD-ELEC0017 | CUS3000288 | 2023-08-05 | 2023-07-25 | 11 | defective | completed | 89.99 | Fitness Tracker S9 | julia.kim@ | female | San Francisco | CA | 94114 | 89.99 | |
| RET100019 | apparel | 23 | true | UK | ORD2000029 | PROD-APP0027 | CUS3000299 | 2023-11-21 | 2023-11-19 | 2 | not as described | approved | 45.99 | Womens Blouse M | sarah.walker@ | female | Bristol | Bristol | BS13DA | in-store | 45.99 |
| RET100020 | home | 56 | false | USA | ORD2000030 | PROD-HOME0046 | CUS3000300 | 2022-10-08 | 2022-09-20 | 18 | defective | completed | 129.99 | Ionic Air Purifier | thomas.brown@ | male | Chicago | IL | 60616 | pickup | 129.99 |
What the 200 rows show
from the 200-row sampleHome (product category) stands out: mean customer_
- 54%is_
first_ return = true - 33median customer_
age - 2customer genders
- 3return methods
- 4return statuses
- 7return reasons
Median 33, from 16 to 99.
- string 15
- integer 2
- float 2
- date 2
- boolean 1
Columns
22 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 15 columns | |||
return_id | string | Unique identifier for each product return transactionunique | RET100001 |
order_id | string | Unique identifier for the original purchase order associated with the return | ORD2000011 |
product_id | string | Unique identifier for the returned product | PROD-ELEC0011 |
customer_id | string | Unique identifier for the customer initiating the return | CUS3000111 |
return_reason | string | Reason for the product return (e.g., defective, not as described, wrong item, buyer remorse)7 values | defective |
return_status | string | Current status of the return process (e.g., pending, approved, rejected, completed)pending · approved · rejected · completed | completed |
product_category | string | Category of the returned product (e.g., electronics, apparel, home)3 categories | electronics |
product_name | string | Name or description of the returned product | UltraHD Smart TV 55in |
customer_email | string | Email address of the customer | eric.smith@ |
customer_gender | string | Gender of the customermale · female · other · prefer not to say · optional | male |
customer_city | string | City of the customer's shipping addressoptional | San Francisco |
customer_state | string | State of the customer's shipping addressoptional | CA |
customer_postal_code | string | Postal code of the customer's shipping addressoptional | 94105 |
customer_country | string | Country of the customer's shipping address12 countries · optional | USA |
return_method | string | Method used for returning the product (e.g., mail, in-store, pickup)mail · in-store · pickup · other · optional | |
| Numbers 4 columns | |||
time_to_return_days | integer | Number of days between purchase and return0 or more | 21 |
refund_amount | float | Amount refunded to the customer for the returned product0 or more · optional | 449.99 |
customer_age | integer | Age of the customer at the time of return0 to 120 · optional | 34 |
product_price | float | Original price of the returned product0 or more · optional | 449.99 |
| Dates and times 2 columns | |||
return_date | date | Date when the product return was initiated | 2023-04-19 |
purchase_date | date | Date when the product was originally purchased | 2023-03-29 |
| True or false 1 column | |||
is_first_return | boolean | Indicates if this is the customer's first returnoptional | true |
15 SQL practice questions for the Online Retail Product Return Analytics
Written for this data and checked against it: 12 SQL and 3 Power BI exercises from beginner to advanced. Try the first three free; the practice kit has all 15, a starter .sql file and an answer key with every expected result.
Distinct return methods
List each distinct return method used. Return a single column named return_method, ordered alphabetically.
Tables: online_retail_product_return_analytics · your result: 1 columns, 3 rowsReturns per reason
Count the returns for each return_reason. Return the columns return_reason and return_count, ordered by return_count descending and then by return_reason ascending.
Tables: online_retail_product_return_analytics · your result: 2 columns, 7 rowsAverage refund by category
For each product_category, return product_category and avg_refund, the average refund_amount rounded to 2 decimals. Order the results by product_category.
Tables: online_retail_product_return_analytics · your result: 2 columns, 3 rows
- 04Completed electronics returnsBeginner
- 05Total refunds by countryPower BI
- 06Reasons with many returnsIntermediate
- 07Speed of return bucketsIntermediate
- 08Returns by yearIntermediate
- 09Countries above average refundIntermediate
- 10Defective rate by categoryPower BI
- 11Top two refunds per categoryAdvanced
- 12Monthly change in returnsAdvanced
- 13Running refund total by yearAdvanced
- 14Reason share of all returnsAdvanced
- 15Refund anomalies by categoryPower BI
Get the practice kit: the full dataset, all 15 exercises, a starter .sql and the answer key. One-time $3.99.
Get the practice kit · $3.99Use it for
An e-commerce dashboard
The is_
first_ return rate, customer_ age by product_ category and a breakdown of customer_ country. Excel, Power BI or Tableau. Why do the 66 home rows have a mean customer_
age of 62.2? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Returns200RET10000134electron…RET10000228apparelRET10000353home
A software demo
Believable returns with order_
id, product_ id and customer_ id to fill a screen in front of a buyer.
blueprint · online-retail-product-return-analytics
Behind this dataset
Same schema. As many rows as you need.
These 200 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.
- Link returns to product and customer segments
- Capture reason, return method, and time lag
- Flag frequent returners
- Synthetic customer anonymization
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
- online-retail-product-return-analytics