Order Management

Updated on September 18th, 2023

  • Extensiv Hub
    Popular Articles Getting Started Using Hub Technical Issues & FAQs Extensiv's Ideas Portal
  • 3PL Warehouse Manager
    Receiving Operations Inventory Management Shipping Operations System Configuration Scanning Operations Integrations Content Best Practice Resources Release Notes Popular Articles Troubleshooting Guides
  • Warehouse Management
    Getting Started Admin Console Shipping Order Picking & Packing Receiving Customer Portal Cycle Counting Kit Building Managing Users Barcode Scanner Import/Export Integrations Barcoding Wave Picking Bin Move Mobile Receiving and Picking Settings Popular Articles Reporting
  • Order Management
    Dashboard Orders Inventory Purchase Orders Shipments Customers Products Analytics Settings API API Integrations Accessing and Navigating Order Manager Error Messages Order Manager Popular Articles Accounting Integrations
  • Integration Management
    Getting Started with Integration Manager General Support Troubleshooting Extras & Addons API Documentation Popular Articles Order Sources Order Destinations
  • FAQs
  • Network Manager
    Getting Started Order Routing Management Technical Issues Shopping Carts Settings Settings, Products, and Orders
  • Billing Manager
    Getting Started Using Billing Manager
  • Release Notes
    Extensiv Sandbox Extensiv Extensiv Hub 3PL Warehouse Manager Integration Management Warehouse Management Order Management Billing Manager
  • Fulfillment Marketplace
    Getting Started
  • Sandbox
    Getting Started
+ More
  • Help Center
  • Order Management
  • Analytics
  • Products
  • Analytics
    • General
        • Historical Purchase Orders Export - Analytics
        • The Analytics Module's Landing Page
        • Analytics Reports
        • Printing Charts from Analytics
        • Exporting Reports
    • Products
        • Analytics - SKU Profitability
        • Y-O-Y Growth
        • Understanding Listing Profitability Analytics
        • Understanding Top Sellers & Worst Sellers Reports
        • Analytics - Trending Profitability
    • Dashboard
        • Opportunities Found by Extensiv Order Manager
    • Inventory
        • Analytics - Inventory Replenishment Alerts
        • Analytics - Snapshot Inventory Value
        • Analytics - Trending Inventory Value
        • Analytics - Critical Inventory Levels
        • Analytics - Inventory Aging
    • Customers
        • Analytics - Lifetime Value
        • Analytics - Biggest Spenders
        • Analytics - Most Frequent Customers
        • Analytics - Most Recent Customers
    • Orders
        • Historical Orders Exports - Analytics
        • Analytics - Sales Overview
        • Analytics - Biggest Tickets
        • Analytics - Shipments
    • Accounting
        • Analytics - Shipment Summary
        • Analytics - COGS by SKU
        • Analytics - Sales Summary
        • Analytics - COGS By Sales Channel
        • Analytics - Inventory Value
    • Inventory Analytics Dashboard
        • Understanding the Inventory Analytics Dashboard
        • Inventory Analytics Dashboard FAQs
      • Sales Analytics Dashboard FAQs

Understanding Top Sellers & Worst Sellers Reports

Overview

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

These reports will only show data for shipped orders.

 

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.

The timezone for these reports is UTC.

 

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.
high-demand best-sellers

Was this article helpful?

Yes
No
Share additional feedback about this article

Related Articles

  • Updating PO Number Prefix
  • Can I have additional order information populated on my Shipping label?
  • Adding UPS as a Shipping Provider

Not finding the help you need?

Contact Support
Solutions
  • Solutions for Brands
  • Solutions for 3PLs
  • Solutions for 4PLs
  • Solutions for B2B
Products
  • Extensiv 3PL Warehouse Manager
  • Extensiv Warehouse Manager
  • Extensiv Order Manager
  • Extensiv Integration Manager
  • Extensiv Network Manager
Products
  • Customer Success
  • Implementation
  • Consulting
Ecosystem
  • Fulfillment Marketplace
  • Integrations
  • Partners
  • Become a Partner
Resources
  • Resource Library
  • Blog
  • Market Insights
  • What is a 3PL?
  • What is a 4PL?
  • What is a WMS?
  • Why a Cloud-based WMS?
  • Glossary
Help
  • Help Center
  • API Documentation
  • Extensiv Univerisity
  • Community
  • System Status
  • Extensiv Logo
  • 100 N Pacific Coast Hwy, Suite 1100, El Segundo, CA 90245
  • |
  • Contact Us:
  • 83-EXTENSIV 888.375.2368 (main)
  • |
  • 310.844.7570 (local)
  • Copyright © 2023 Extensiv
  • |
  • All rights reserved.
  • Privacy Policy
  • |
  • Terms of Service
  • Follow Us:
Expand