Monthly Return Rate Report

Sample Monthly Return Rate Report

Return requests are placed for a number of reasons, such as customer dissatisfaction, improper fit, or it otherwise does not meet the customer’s expectations. The merchant’s goal is always to reduce the number of returns to avoid incurring additional, sometimes unnecessary costs. Monthly return rate can help provide some insight into this customer data and help inform merchant decisions.


In this report, each product is quantified by a return rate. In this view, merchants are then able to compare return rates across product styles to determine which values are the highest and lowest. The Monthly Return Rate Report provides a detailed breakdown of returned sales against shipped sales of the category and style of products. After reviewing this data, merchants can determine the reason for the high returns, diagnose the issue, and take the necessary steps to remediate it.

 

What the report shows

The report compares returns with shipped sales for each product style.

  • Product grouping: the division (the collection a style belongs to) and the style.
  • Sales and returns: shipped sales, returns, and net sales.
  • Return rate: returns divided by shipped sales, as a percentage.

 

How teams use it

Retail and sales leaders sort by return rate to find the styles that come back most often, then compare styles within the same division to separate a style problem from a collection-wide trend.

A high return rate on one style can point to a fit, sizing, or description issue that the merchandising team can correct.

Watching the return rate for the same styles month after month also shows whether a change, such as an updated size chart or better product photos, reduced returns.

The Monthly Return Rate Report is one of the pre-configured reports in the HotWax Commerce BI report library, which covers demand and sales, fulfillment, pre-orders, returns, and more.

 

User

Vice President of Retail, Vice President of Sales

 

Glossary

ItemItem Details
DivisionThe collection of the style
StyleThe category of the product
Shipped SalesThe shipped sales for the product
ReturnsThe returns received for the product
Net SalesShipped sales for the product - Return received for the product
Return RateReturns received for the product/Shipped Sales for the product x 100