Overview

The Top Sellers & Worst Sellers reports reveal the quantity sold and revenue earned for your top-selling products and worst-selling products.

You can find both the Top Sellers & Worst Sellers reports in the Analytics module under the Products section.

Filters you can specify:

• The number of SKUs in the report (the default number is 100 SKUs).
• The sales channels included in the report.
• The date range (the default date range is 1 year - i.e. FROM date is Sept 1, 2021 and TO date is Sept 1, 2022). Please keep in mind that the report will show data based on orders that were shipped within this date range.

Choose the data you want to review:

• Units Sold: The total number of units that were shipped.
• Revenue: The total amount of revenue per product.
• Listing SKU: Selecting listing SKU instead of master SKU will show data for the original orders that were downloaded from the sales channel rather than what was shipped in the order. Bundle SKUs will show Units Sold and Revenue based on the number of bundles that were ordered regardless of whether they were shipped as prepackaged inventory or broken down into core components prior to shipping.
• Master SKU: Selecting master SKU instead of listing SKUs will show data for orders based on what was shipped within the order rather what was included in the original order from the sales channel. Units Sold and Revenue is on the Master SKUs that were shipped to fulfill the order. If you break down bundles into core components, or ship bundles/kits using core components, selecting master SKUs will provide accurate information on what was shipped within each order. If you do not use bundle breakdown and instead ship bundles using prepackaged inventory, then selecting master SKU will produce the same data as selecting listing SKU.

Exporting these reports:

These reports are exportable as Microsoft Excel spreadsheets. To export them, click on the Export button in the top right corner of the report.

Notes:

• These reports will not show data for external orders (orders that do not exist in Extensiv Order Manager).
• These reports will not show data from stock transfers or FBA workflows.
• Previously, the Top Seller & Worst Seller reports only displayed the Units Sold and Revenue based on the listings that were sold for each product. If you still want to view this data based on listings, select the Listing SKU option for either of these reports.