Reports
The reports show how many returns your store gets, why products come back, what the returns end with, and how fast your team handles them. To open them, go to Sales -> RMA -> Reports.
Since version 2.6.0 the reports are part of the extension itself, in the Mirasvit_RmaReport module. They no longer need the mirasvit/module-report package. The earlier reports (Report by Status, by Reasons, by Product, by Offline Product and by Attribute) were replaced with the reports described below.
Access to the reports is controlled by the RMA > Reports ACL resource of the admin user role.
Report filters
Every report page has the same toolbar at the top:
- Period: Last 7 days, Last 30 days (the default), Last 90 days, This month, Last month, Last 12 months, or Custom range with your own From and To dates.
- Store view: all store views, or one store view.
- Compare to previous period (dashboard only): shows each figure next to its value for the previous period of the same length. For Last month and This month the previous period is the previous calendar month.
Above the toolbar, the report navigation links the Dashboard and all detailed reports, grouped into Returns, Customers and Operations.
Dashboard
The dashboard is the first page of the reports. It gives a summary of the selected period, and every number, bar and row on it opens the detailed report behind it.
- Needs Attention: short notes about things that need a look, for example:
- open RMAs that have waited longer than the First Response Target for a staff reply;
- more RMAs opened than resolved in the period, so the queue is growing;
- a return reason that grew a lot against the previous period, or a new reason;
- a product that comes back at least twice as often as the store average;
- customers who returned at least half of their orders.
- Key figures:
- RMAs - RMAs opened in the period.
- Return rate - the share of orders placed in the period that got an RMA.
- Refunded - credit memos of RMAs opened in the period, in the base currency.
- Exchanges - RMAs opened in the period that got an exchange or replacement order.
- Rejected - the share of the period's RMAs that are now in a status with the code
rejected. - First response - the median time from RMA creation to the first staff reply.
- Replied within N h - the share of first replies sent within the First Response Target. RMAs still unanswered past the target count as missed.
- Resolution time - the median time from creation to resolution for RMAs resolved in the period.
- Open now - unresolved RMAs at this moment, regardless of the period.
- Open over N days - unresolved RMAs older than the Overdue After setting.
- RMAs Over Time: a chart of created and resolved RMAs in the period. With Compare to previous period on, it also shows the RMAs created in the previous period.
- Most Returned Products: products of orders placed in the period, ranked by the reliable return rate (see Return Rate by Product).
- Why Products Come Back and Products by Reason: returned qty by reason, and a product by reason table. Click a bar or a cell to see the details.
- Asked For vs Got: what each requested resolution ended with.
- Customers Who Return and Time to Return: the customers with the most returned orders, and how many days after the order the RMAs arrive.
- Open RMAs by Age and Time in Status: the current queue split into the age groups from the Open RMA Age Groups setting, and the median time RMAs spend in each status.
- Team: RMAs, resolved RMAs, first response and resolution time per owner.
Detailed reports
Each detailed report is a table that you can sort by any column. Filters applied from the dashboard (for example a product, a reason, a status or an owner) are listed above the table under Active filters, and you can remove them one by one or with Clear all. Click Export CSV to download the report with the same filters and sorting, without paging.
Returns
Return Rate by Product
Products of orders placed in the period and how much of them came back: SKU, Product, Qty sold, Qty returned, Return rate, Reliable rate, RMAs, Top reason and Returned value.
Reliable rate is the lowest return rate that the sales volume supports with 95% confidence. Because of it, a product with one return out of one sale does not top the list over a product that sells a lot and comes back often. The report is sorted by this column.
Products by Reason
Returned qty of the period's orders per product and reason, with the reason's share of all returns of that product.
Return Reasons
Returned items of RMAs opened in the period, by Reason, requested Resolution and item Condition, with the number of items, qty, RMAs and the share of the returned qty.
Requested vs Actual Outcome
RMAs opened in the period by the resolution the customer asked for and what the RMA ended with, for example a refund, an exchange or a rejection.
Offline Products
Returned items of offline orders in RMAs opened in the period, by item name.
Customers
Customers Who Return
Customers with returned orders among the orders they placed in the period: Orders, Returned orders, the share of Orders returned, Qty returned, Returned value and RMAs. Guests are grouped by email.
Time to Return
How many days after the order the RMAs were opened, for RMAs on store orders opened in the period. Use the Cumulative share column to choose the return period you offer: for example, if 95% of RMAs arrive within 20 days, a 30-day return period covers almost all of them.
Operations
Open RMAs
All unresolved RMAs at this moment, oldest first. The period filter does not apply here. For each RMA the report shows its Status, Age, how long the customer is Waiting for reply, the last reply and the Owner.
Time in Status
How long RMAs stay in each status they entered in the period: how many RMAs Entered the status, how many Moved on, the Median time, the time 90% within, and how many RMAs are In it now.
Team Performance
RMAs opened in the period by owner: RMAs, Resolved, Still open, Replies, the median and 90% first response time, the share of first replies Within SLA and the median resolution time.
The extension records status changes and the resolution date of an RMA starting from version 2.6.0. So Time in Status, Resolution time and the resolution columns of Team Performance include only data collected after the upgrade.
Returns on the product and customer pages
The reports also add a short return summary for the last 12 months to two admin pages:
- Product edit page - the Returns section shows Qty sold, Qty returned, the Return rate with its reliable rate, the Store average rate, the number of RMAs and the top reasons of the product.
- Customer edit page - the RMA tab shows the customer's Orders, Returned orders, the share of Orders returned, Qty returned and RMAs.
Report settings
The targets that the reports use, such as the first response target and the overdue limit, are set in the Reports section of the extension configuration.
To hide the reports, disable the Mirasvit_RmaReport module (see How to disable the extension). The Reports item then disappears from the RMA menu.