The “Refunds“ tab displays statistics of all refunded products, reported directly from Amazon. Refunds are grouped on the tab by reason and filtered by the selected period of time. For each refund, you can see a comment if the Amazon customer left it while submitting a refund.
The “Refunds” tab can be accessed via:
- SELLERLOGIC Homepage > Business Analytics > Dashboard > Refunds
- Business Analytics navigation bar > Dashboard > Profit dashboard > Refunds
Data filtering
The displayed data is determined by the applied filters and can be configured through the following methods:
- Sidebar menu – provides full filtering functionality. For more information, see Business Analytics | Profit dashboard | Sidebar menu. Note: The sidebar menu is not available when the “Product refunds” drawer is opened.
- Page settings panel – allows filtering by Amazon seller account, marketplace, date range, SKU/ASIN/product name, and currency. For more information, see Business Analytics | Page settings.
Change view
The data displayed by the table depends on the chosen view type:
- Order view: Shows data related to actual and estimated transactions, based on the order creation date.
- Transaction view: Recalculates data according to the actual transaction dates. Note: Estimated transactions remain tied to the order creation date.
You can switch views via the “Change view“ button in the page settings panel or the "Filters” in the sidebar menu.
Refunds dashboard
The “Refunds” dashboard consists of two main sections:
- The chart section with the total number of the refunded products, a pie chart that illustrates the proportion of refund reasons, and the list of refund reasons marked with a unique color.
- The table with refunded products and additional details.
Chart
The chart graphically displays the total number of refunds and the proportional distribution of refund reasons occured during the chosen period of time. Every refund reason is marked by a unique color. Right to the chart, all refund reasons are represented as a chart legend in the form of a list, sorted from the most to the least common reason.
Clicking on the refund reason will highlight the corresponding section on the pie chart and sort the table accordingly. Clicking on the “Reset“ button located up to the total count will reset the pie chart selection and the table to display all products with refunds.
Download chart and export data
To download the chart with the list of refund reasons, click on the “Download chart” button. The chart can be downloaded in PNG or PDF formats.
To download filtered results of the "Refunds” table to your PC, click the up-arrow icon in the upper right of the page and select “Export data” from the dropdown menu. By clicking the “Export data” button, you can export up to 100 products with refunds in XLSX, XSL, or CSV file formats.
Table columns
The “Refunds” table features interactive column headers that support sorting and filtering, allowing you to customize the displayed data to your preferences. This ensures that you can view and manage product information or export all products from the table.
- Sorting options: Each column header, except “Image“, “Refund reason”, and “Comments“ provides “Ascending” and “Descending” sorting options to quickly reorganize data in a meaningful order. Note: Sorting can be applied to only one column at a time. Applying sorting to a different column will override any previously applied sort order.
- Filtering options: Each column header, except "Image“, “Refund reason”, and “Comments“, includes an inline filter, presented as text input field for a live search, depending on the data type. Filtering allows you to narrow down the data displayed in a table by providing specific values within column headers. Multiple column filters can be applied simultaneously.
For more information, see General | Common service features.
Below is a table listing all columns available in the "Refunds" table and their respective descriptions.
| Column header | Description | Column header filter |
|---|---|---|
| Image | Shows the product image as provided by Amazon. | |
| Title | Displays the product's name or a short description. | Live search |
| ASIN | The Amazon Standard Identification Number (ASIN) is a 10-digit alphanumeric product identification number with a link to the product page on Amazon. One ASIN may cover multiple SKUs. | Live search |
| SKU |
The Stock Keeping Unit (SKU) is the unique alphanumeric code used by Amazon to identify a product for inventory and sales purposes. On rare occasions, two different marketplaces may have the same SKU. The value in this column is clickable and opens the “Product costs” page in a new browser tab, prefiltered by the selected SKU and its marketplace. At the same time, the “Product details” drawer is displayed to highlight cost settings related to this product. |
Live search |
| Marketplace | Identifies the Amazon marketplace where the product is listed. | Dropdown list |
| Brand | Displays the name of the brand associated with the product. | Live search |
| Refund reason |
The number of refund reasons per product. The value is clickable and opens the “Product refunds“ drawer with the refund details, reasons, and comments. |
|
| Comments |
The number of comments attached to the refund. The value is clickable and opens the “Product refunds“ drawer with the refund details, reasons, and comments. |
|
| Revenue |
Revenue includes product sales and other income-related transactions. The value is clickable and opens the “Transactions“ page in a new browser tab, prefiltered by the selected Amazon account, SKU, selected date range, marketplace, and KPI type. |
Live search |
| Total expenses |
The total sum of all negative transactions. The value is clickable and opens the “Transactions“ page in a new browser tab, prefiltered by the selected Amazon account name, SKU, selected date range, order purchase date, marketplace, and KPI type. |
Live search |
| Estimated margin | The estimated net margin, calculated as total income minus total expenses. | Live search |
| Order items |
The total number of items across all orders. The value is clickable and opens the “Orders“ page in a new browser tab, prefiltered by all orders statuses without “Cancelled“, Amazon account name, marketplace, and SKU. |
Live search |
| Units |
The number of ordered units. The value is clickable and opens the “Orders“ page in a new browser tab, prefiltered by all orders statuses without “Cancelled“, Amazon account name, marketplace, and SKU. |
Live search |
Promotion |
The number of orders with promotions applied. The value is clickable and opens the “Transactions” page in a new browser tab, prefiltered by order number, Amazon account name, SKU, marketplace, and transaction category. |
Live search |
| Refunded units |
The number of refunded units. The value is clickable and opens the “Orders“ page in a new browser tab, prefiltered by all orders statuses except “Canceled“, Amazon account name, marketplace, SKU, refunded units > 0, and refund date. |
Live search |
| Estimated margin % |
The percentage of the estimated margin in the revenue. Ranged form -100% to 100% If the revenue = 0, it is impossible to calculate the margin. In this case, the “Margin“ will be displayed as “N/A“. |
Live search |
| ROI | Return on Investment (ROI) is calculated as the ratio of net margin to total expenses. | Live search |
Pagination and table controls
The lower section of the page facilitates navigation through large datasets and offers tools to customize the table view.
-
Table controls: Located in the bottom-right corner, table controls provide options to adjust the display and content of the table according to your preferences:
- Table settings: Opens an edit mode that allows manual adjustment of column widths.
- Table content: Opens a configuration modal that allows users to define the order and visibility of columns. Columns can be toggled using checkboxes and reordered via drag-and-drop.
- Pagination and display count: In the bottom-left corner, the display count control allows selecting the number of entries per page (10, 25, 50, 75, or 100), shows the current range of visible results, the total number of entries, and provides navigation through pages using arrow buttons or direct page number input.
Product refunds
Clicking on the value in the “Refund reason“ or “Comments“ columns, you will see the “Product refunds“ drawer with detailed information for each refunded product.
The “Product refunds“ consists of 4 sections:
- Product details panel with image, title, ASIN, SKU, marketplace, and brand. To filter the refund details, use a dropdown with refund reasons and a datepicker. ASIN value is clickable and opens the product page on Amazon.
- Refund progress and regress represented in the form of a chart within a chosen timespan.
- A total number of refunds represented graphically in the form of a pie chart, with available reasons marked in a unique color. The list of reasons right to the pie chart is clickable, and clicking on the reason will highlight the corresponding section on the pie chart.
- The list of refund details includes the refund reason, comment, clickable order number, order purchase date, and the number of refunded units. The order number is clickable, and click upon it opens a Seller Central page with the order details. The number of refunded units is clickable and clicking upon it opens a “Transactions” page prefiltered with order number, Amazon account name, SKU, makretplace and transaction category. Each refund is displayed in its separate block. The refund details list includes pagination, with up to 10 items per page.
Comments are displayed in the language they were written in by Amazon customers. Refunds without comment are displayed with the phrase: “No comment provided“.