The “Product list“ widget shows the list of all your products and orders 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 entire filtering functionality is available. To learn more, see Business Analytics | Sidebar menu
- by page settings panel on the top of the page, the list can be set by choosing an 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. However, estimated transactions are still tied to the order creation date.
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
The page consists of two tabs: “Products” (default) and “Order items”.
Products
Below is a table listing all fields available in the "Products" 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.
The value in this column is clickable and opens the “Product costs“ page in a new tab, prefiltered by the selected SKU and its marketplace. It also opens the “Product details“ drawer displaying the product costs associated with this product. Note: This feature is not available in Freemium mode. |
| 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 you to see the most performing products in the 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. Note: “Transaction amount” is filtered above 0, and the next transaction categories will be predefined in the “Category” filter:
|
| Estimated margin | The estimated net margin, calculated as revenue minus total expenses. |
| Expenses |
Expenses and costs associated with the product, excluding Ads costs and Amazon fees. The value in this column is clickable, and clicking upon it opens a new browser tab with predefined parameters on the “Transactions“ page. Note: “Transaction amount” will be filtered below 0. |
| Ads (PPC) | The costs associated with PPC (Pay-Per-Click) advertising campaigns on Amazon. |
| Amazon fees |
All Amazon orders 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. Note: Next transaction categories will be predefined in the “Category “ filter:
|
| 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. |
Order items
Below is a table listing all fields available in the "Order items" tab and their respective descriptions.
| Column | Description |
|---|---|
| Estimated values | If the order includes estimated values, the exclamation icon is displayed at the beginning of the corresponding table line. |
| Order number | The unique order number assigned by Amazon, with a direct link to the order page on Amazon Seller Central. |
| Order status | The current status of the order as reported by Amazon, which can be one of the following: “Shipped”, “Canceled”, “Invoice unconfirmed”, “Pending”, “Pending availability”, “Unfulfillable”, “Unshipped”, or “Partially shipped”. |
| Order date | The date when the order was created, as reported by Amazon. |
| Marketplace | The Amazon marketplace where the product is listed. |
| 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 several SKUs. |
| 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 tab, prefiltered by the selected SKU and its marketplace. It also opens the “Product details“ drawer displaying the product costs associated with this product. Note: This feature is not available in Freemium mode. |
| Image | The image of the product as received from Amazon. |
| Title | The name or a short description of the product as received from Amazon. |
| Product ID | The unique identifier assigned to each product within Business Analytics for reference purposes. |
| Brand | The name or label under which the product is marketed. |
| Product Type | The category of the product based on its characteristics or intended use. |
| Manufacturer | The entity responsible for producing or assembling the product. It can be different from the brand if the product is made by a third-party manufacturer on behalf of the brand. |
| Condition | The condition of the product as received from Amazon. |
| Fulfillment method |
Indicates which fulfillment method is applied to the product:
|
| Offer type |
Indicates which commerce type is applied to the product offer:
|
| Unit price | The product price per unit. |
| Units | The number of sold product units. The value in this column is clickable, and clicking it opens a new browser tab with predefined parameters on the “Orders“ page. |
| Revenue |
The total income generated by the order. The total income generated by the order, 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. Note: “Transaction amount” is filtered above 0, and the next transaction categories will be predefined in the “Category” filter:
|
| Promotion | The amount spent on promotions and discounts for the order. |
| Amazon fees |
All Amazon orders 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. Note: Next transaction categories will be predefined in the “Category “ filter:
|
| Expenses |
All expenses applied to the order, excluding "Amazon fees" and "Promotion" values.
The value in this column is clickable, and clicking upon it opens a new browser tab with predefined parameters on the “Transactions“ page. Note: “Transaction amount” will be filtered below 0. |
| Estimated margin | The estimated margin generated by the order, calculated as revenue minus total expenses. |
| Refunded units | The number of product units refunded for the order. The value in this column is clickable, and clicking it opens a new browser tab with predefined parameters on the “Orders“ page. |
Business Analytics Freemium mode
If you have no active Business Analytics subscription, both tabs in the Product list widget will be available in Freemium mode with visible values in the following columns:
- Product title
- Image
- ASIN
- SKU
- Marketplace
- Manufacturer
- Units
- 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.