The “No sales products“ widget shows products without sales and at least one transaction according to the chosen filters and page settings on the Profit dashboard.
The “No sales products” widget can be accessed via:
- SELLERLOGIC Homepage > Business Analytics > Dashboard > No sales
- Business Analytics navigation bar > Dashboard > Profit dashboard > No sales
Data filtering
The “No sales products” 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.
- Page settings panel – allows filtering by Amazon seller account, marketplace, date range, and SKU/ASIN/product name. 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.
Table fields
The "No sales products” widget has interactive column headers that support sorting and filtering to help you customize the displayed data to your preferences.
- Sorting options: Each column header, except "Image", provides “Ascending” and “Descending” sorting options to quickly reorganize product data in a meaningful order. “Estimated margin” column sorting is enabled by default. 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", includes an inline filter, presented as either a dropdown list or 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 fields available in the "No sales products" 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. This functionality is not available in Freemium mode. |
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 |
| Product type | A product type refers to a set of products that share similar attributes. | Live search |
| Manufacturer | The name of the manufacturer of the product. | 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 |
| Refunds | The number of refunded units. The value is clickable and opens the “Orders“ page in a new browser tab, prefiltered by Amazon account name, marketplace, SKU, and Refunded units >0. | Live search |
| Revenue | The total income includes product sales and all other income-related metrics. The value is clickable and opens the “Transactions“ page in a new browser tab, prefiltered by the selected Amazon account, SKU, order purchase date, marketplace, and KPI type. | Live search |
| Estimated margin | The estimated net margin, calculated as revenue minus total expenses. This column is automatically sorted in ascending. | Live search |
| Total income | The total sum of all positive 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, marketplace, and KPI type. | Live search |
| Total expenses | The total cost includes 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 percentage of the estimated margin in the revenue. Ranged form -100% to 100%. For products with no sales, this metric will be displayed as “N/A“, because the metric is based on the product’s revenue, which equals zero if the product wasn’t sold in a chosen date range. If the revenue = 0, it is impossible to calculate the margin. | Live search |
| ROI | Return on Investment (ROI) is calculated as the ratio of net margin to total expenses. | Live search |
| Markup | The percentage increase of the net profit over the net purchase price. | Live search |
| Amazon account name |
The name of the Amazon account associated with the product. It is hidden if only one account is connected to Business Analytics. |
Dropdown list |
Pagination and table controls
The lower section of the table 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 where users can 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.
Export data
To download the filtered results of the "No sales products” table to the 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 all products in XLSX or CSV file formats.