The “Product list“ widget shows the list of all your products that had transactions within the selected page filters. By default, the table is sorted by the number of units ordered for each product in a chosen date range. The widget is available on the “Profit” and “Statistics” tabs of the “Profit dashboard”.
Filtering
The number of displayed products and their values depend on the selected filters. To filter the product list, you can use three methods:
- by the sidebar menu, where the whole filtering functionality is available. To learn more, see Business Analytics | Sidebar menu
- by global filters panel on the top of the page the list can be set by choosing account, marketplace, date range and a particular SKU/ASIN/product name
- by clicking on any blank space of the widget tile with the corresponding date range.
The selected date range for the product list is shown above the product list on the left side.
Change view
The content of the table is affected by the chosen type of view:
- “Order view“ - shows the data related to actual and estimated transactions based on the order creation date.
- “Transaction view“ - recalculates the data according to the actual transaction dates.
To switch the view, use the “Change view“ button on the global filters panel, or on the sidebar menu. To learn more, see Business Analytics | Sidebar menu
Table fields
Below is a table listing all fields available in the "Product list" table and their respective descriptions.
| Column | Description |
|---|---|
| Image | Shows the product image as provided by Amazon. |
| Title | Displays the product's name or a short description. |
| 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.
The value in this column is clickable and leads to the product page on Amazon Seller Central. |
| 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. |
| Marketplace | Identifies the Amazon marketplace where the product is listed. |
| Brand | Displays the name of the brand associated with the product. |
| Product Type | A product type refers to a set of products that share similar attributes. |
| Manufacturer | The name of the manufacturer of the product. |
| Units |
The number of ordered units. Note: The product list is sorted as “Descending“ by default. This feature allows to see the most performing products in selected date range.
The value in this column is clickable and clicking upon it opens a new browser tab with predefined parameters on the “Orders“ page. |
| Order items |
The number of orders made for the product.
The value in this column is clickable and clicking upon it opens a new browser tab with predefined parameters on the “Orders“ page. |
| Refunds |
The number of refunded units.
The value in this column is clickable and clicking upon it opens a new browser tab with predefined parameters on the “Orders“ page. |
| Revenue |
The total income that includes product sales and all other income-related metrics.
The value in this column is clickable and clicking upon it opens a new browser tab with predefined parameters on the “Transactions“ page. |
| Estimated margin | The estimated net margin, calculated as revenue minus total expenses. |
| Expenses |
The total expenses and costs associated with the product.
The value in this column is clickable and clicking upon it opens a new browser tab with predefined parameters on the “Transactions“ page. |
| Amazon fees |
All Amazon order and product-related fees including shipping fees for FBA products.
The value in this column is clickable and clicking upon it opens a new browser tab with predefined parameters on the “Transactions“ page. |
| Margin | Percentage of net margin relative to revenue in a chosen period. |
| ROI | Return on Investment (ROI), calculated as the ratio of net margin to total expenses. |
| Markup | The percentage increase of the net margin over the net purchase price. |
| Amazon account name |
The Amazon seller account name associated with the product.
Note: If you have only one Amazon account connected to SELLERLOGIC, this column is disabled by default. To turn it on, use the “Table content“ modal window. |
Business Analytics Freemium mode
If you have no active Business Analytics subscription, the Product list widget will be available in Freemium mode with visible values in the following columns:
- Title
- ASIN
- SKU
- Order items
- Revenue
- Estimated margin
Table options
Each column header provides “Ascending” and “Descending” sorting options as well as live search for certain columns.
The “Table settings” and “Table content” buttons, located at the lower right of the page, enable users to customize the view and content of the page table. The “Table content” modal form allows you to manage the columns of the table, by changing their respective order or visibility status. For more information, see General | Common service features.