Show / Hide Table of Contents
    • Updated: 1/9/2023
      • Andrei Mazulnitsyn
      • Anokhin Alexey
      • Mariann

    Reports

    Reports are important for management; they allow for monitoring store's performance, tracking key metrics, and supporting decision-making. nopCommerce reports provide access to sales and customer information.

    Dashboard

    The dashboard is the first page you see when accessing the admin area. It enables you to view your store statistics, including the total number of orders processed over the chosen period (year, month, week), registered customers, low-stock products, and the most popular products in your store.

    Dashboard

    The dashboard consists of several blocks:

    nopCommerce news

    Displays general nopCommerce news like new version releases. News

    Common statistics

    Common

    Here, you can find links to more detailed reports:

    • Sales → Orders
    • Sales → Return requests
    • Customers → Registered customers
    • Reports → Low stock

    Orders

    This diagram shows the number of orders processed in the last week, month, year. Orders

    New customers

    This diagram shows the number of customers registered in the last week, month, year. New customers

    Order totals

    This section shows the total of orders processed in the last day, week, month, year. Orders are shown by order status. Order totals

    Incomplete orders

    This section shows the number of orders that are currently incomplete. Orders incomplete

    Latest orders

    The Latest orders section shows you the latest placed orders. Latest orders

    Popular search keywords

    This block displays the most used keywords.

    Keywords

    Bestsellers reports

    This section displays the bestsellers by quantity and by amount. Bestsellers

    Sales summary

    This report represents the total orders summary. To generate a report, you can use the following filters:

    • Start date for the search.
    • End date for the search.
    • Order status to search by a specific order status, for example, "Complete."
    • Payment status to search by a specific payment status, for example, "Paid."
    • Category to search in a specific category.
    • Manufacturer to search by a specific manufacturer.
    • Billing country to filter by order billing country.
    • Vendor to search by a specific vendor.
    • Product to search by a specific product.
    • Group by for grouping by time periods. When this option is set to "Day," it will display a list of dates for a selected period (start/end date). For example, "Nov 8th, 2020," "Nov 7th, 2020," etc. When it is set to "Week", it will display a list of weeks (for example, "December 7th, 2020 - December 12th, 2020," etc.). When it is set to "Month", it will display a list of months (for example, "December 2020," "November 2020," etc.).

    Then click Run report.

    Sales summary

    Low stock report

    A low stock report contains a list of products currently under stock. In the example shown below, the min stock quantity was set to 20, and the stock quantity is 0; therefore a low stock report is generated for this product. You can set up low stock settings when adding the product.

    To view low stock reports, go to Reports → Low stock. The Low stock report window will be displayed as follows: Low stock report

    The low stock reports can be filtered by the Published property, which represents the Published property of products.

    In the displayed table, click View to view the product details page where the stock quantity can be updated.

    Bestsellers and never purchased

    Knowing the best-selling products and products never purchased is essential for any shop owner.

    First of all, this can help in making better purchasing decisions: you can scale up on your popular items and exclude unpopular ones from your product list. When analyzing, consider, for example, whether certain colors sell faster or whether your product sales depend on a season.

    Secondly, defining most and least selling goods can help you re-evaluate product design and marketing. Maybe your best items go faster just because of their placement in your webstore or better description. Come up with various options and test them. To do it more effectively, engage with your customers. Conduct various surveys to find out why the best-selling items are preferred, what makes them special for your buyers. Use the insights to improve your marketing and increase sales.

    Bestsellers

    To view bestsellers in nopCommerce, go to Reports → Bestsellers. Enter one or more of the following search criteria to run the report:

    • Start date and/or End date.
    • Store if you want to select one of your stores.
    • Order status, such as All, Pending, Processing, Complete or Cancelled.
    • Payment status, such as All, Pending, Authorized, Paid, Refunded, Partially refunded or Voided.
    • Choose the Category.
    • Choose the Manufacturer.
    • Choose the Billing country.
    • Choose the Vendor.

    Then click Run report.

    The report will break down your best-selling products based on both units sold and revenue:

    Bestsellers

    Products never purchased

    To view products never purchased, go to Reports → Products never purchased. Enter one or more of the following search criteria to run the report:

    • Choose the Category.
    • Choose the Manufacturer.
    • Store if you want to select one of your stores.
    • Choose the Vendor.
    • Start date and/or End date.

    Then click Run report.

    Products never purchased

    Country sales

    A country report contains a list of orders that includes the number of orders and the total order sum in each country. This enables store owners to view the orders per country.

    To view a country sales report, go to Reports → Country sales.

    Country sales

    To set up the report, enter one or more of the following search criteria:

    • Start date for the search.
    • End date for the search.
    • Order status, such as All, Pending, Processing, Complete or Cancelled.
    • Payment status, such as All, Pending, Authorized, Paid, Refunded, Partially refunded or Voided.

    Then click Run report.

    Customer reports

    Customer reports give a store owner general information about registered customers and their orders. You can find various reports in the Reports → Customer reports menu.

    Registered customers

    To run this report, go to Reports → Customer reports → Registered customers. This report displays the number of registered customers for a certain period. You can track the number of users registered within the last day, week, two weeks, month, and year.

    Registered customers

    Customers by order total

    To run this report, go to Reports → Customer reports → Customers by order total. In this report, you can see the order totals spent and number of orders made by customers.

    Customers by order total

    Enter one or several search criteria to compile a report:

    • Registration Start date.
    • Registration End date.
    • Order status, such as All, Pending, Processing, Complete or Cancelled.
    • Payment status, such as All, Pending, Authorized, Paid, Refunded, Partially refunded or Voided.
    • Shipping Status, such as All, Shipping not required, Not yet shipped, Partially shipped, Shipped, Delivered.

    Then click Run report.

    Customers by number of orders

    To run this report, go to Reports → Customer reports → Customers by number of orders. This report displays the top 20 customers based on the total number of orders issued.

    Customers by number of orders

    Enter one or several search criteria to compile a report:

    • Registration Start date.
    • Registration End date.
    • Order status, such as All, Pending, Processing, Complete or Cancelled.
    • Payment status, such as All, Pending, Authorized, Paid, Refunded, Partially refunded or Voided.
    • Shipping Status, such as All, Shipping not required, Not yet shipped, Partially shipped, Shipped, Delivered.

    Then click Run report.

    Tutorials

    • Running reports in nopCommerce
    • Improve this Doc
    Back to top Generated by DocFX