Negative margin products

The "Negative margin products" tab on the Business Analytics Dashboard highlights the most underperforming products by identifying those where the estimated margin is less than or equal to the associated expenses. 

Note: The data in the table is blurred in the Freemium mode.

Table fields

The “Negative margin products“ table features interactive column headers that support sorting and filtering to help you customize the displayed data to your preferences. This ensures that you can view and manage the needed product information or export all products from the table.

  • Sorting options: Each column header provides “Ascending” and “Descending” sorting options to quickly reorganize product data in a meaningful order. 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 "Negative margin products" table, along with their respective descriptions.

Column header Description Column header filter
Title Displays the product's name or a short description. Live search
Image Shows the product image as provided by Amazon.
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
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 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 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. This column is automatically sorted by ascending. 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. Live search
Refunds The number of refunded 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, SKU, and refunded units >0. Live search
BSR

Best Seller Rank (BSR) represents the product's performance relative to others in the same category.

When hovering over the BSR value, a tooltip appears, showing the percentage change compared to the previous similar period.

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
Markup The percentage increase of the net margin over the net purchase price. Live search
Amazon account name

The name of the Amazon sellert account associated with the product.

It is hidden if only one account is connected to Business Analytics.

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 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.

Was this article helpful?

Can’t find what you’re looking for?

Do you have any more questions? We are happy to answer them.

Contact Support