30
5 usages left
Rating 0 stars - 0 votes

Magento 2 reports tutorial

In Magento 2 reports can provide you with full sales and marketing statistics. This tool can help you a lot in determining your best approaches in selling goods and increasing customers loyalty.

Use this Magento 2 reports tutorial to guide you through the process of order creation and management in Magento 2.

There is a wide range of reports available in Magento 2. In this tutorial, we will consider the most important Magento 2 reports that are Sales, Marketing, Products, Customers, Reviews and Statistics reports, each with multiple subselections. Each of the reports can be generated and exported in few clicks.


all-magento-2-reports
Magento 2 Reports Tutorial

Magento 2 Report Types

Sales reports

All reports of this type (except PayPal Settlement) can be filtered by order creation date, period and status.

  • Orders report includes the list of orders with totals, amounts invoiced, refunded, shipping charge, taxes, and discounts.
  • Tax report contains tax rules and tax rates used, number of orders and tax charged.
  • Invoiced report includes number of orders and invoices, amounts invoiced, paid and not paid.
  • Shipping report allows to get the number of orders with carrier or shipping method specified in filters.
  • Refunded report shows the number of orders refunded, total amount refunded.
  • Coupons report contains the list of coupon codes, related price rule, number of times used.
  • PayPal Settlement report can be filtered by date, merchant account, transaction ID, invoice ID, PayPal reference ID, event, gross/fee amount.

Marketing reports

  • Products in Cart report includes all products that are currently in shopping carts with their names and prices.
  • Search Items report shows what your client search for in each of the store views, the number of matching products, and the number of times a particular query has been used.
  • Abandoned Carts report contains the list of registered customers with abandoned carts which have not still expired. You can view customers' name, emails, number of products in cart, the date of creation and latest update.
  • Newsletter Problems report shows data about newsletter queues that transmitted unsuccessfully.

Reviews reports

  • By customers report contains the list of customers who submitted a product review with their number and the links on the reviews.
  • By products report lists the items that have been reviewed, the number of reviews, average rating, and links to each product reviews list.

Customer reports

  • Order Total report shows orders created by a particular customer during specific time period, average order amount and total amount.
  • Order Count report includes the number of orders per customer created within particular time period, average order amount and total amount.
  • New Accounts report shows the number of new accounts registered during specific time interval.

Products reports

  • Product views report lists the products that have been viewed during particular time period with their names, prices and the number of views.
  • Bestsellers report shows five best-sold items within the specific interval of time, their names, prices, and quantity ordered.
  • Low Stock report contains the list of goods with stock levels within selected range.
  • Ordered Products report shows all products that have been ordered during particular time period.
  • Downloads report contains all downloaded products within specified date range with their names, download links, SKU and number of purchases or downloads.

Magento 2 Sales Report Tutorial

Sales report is likely most frequently used in Magento 2 as it provides with figures that are most important for every merchant. Check how to generate a sales report in a proper way.

  1. Go to 'Reports' and find 'Sales' section. Select the report you want to create.

  2. reports-generation-in-magento-2
    Magento 2 Reports Tutorial

  3. Refresh the latest statistics to get most recent data.

  4. refresh-magento-2-sales-statistics
    Magento 2 Reports Tutorial

  5. Filter out the data you want to get.
    • Select the store view
    • Date range of order created/updated
    • Order status

    • filter-out-sales-data
      Magento 2 Reports Tutorial

  6. Tap the 'Show report' button in the right upper corner to generate the report.

  7. press-show-report-button-to-get-magento-2-report
    Magento 2 Reports Tutorial

If you want to save the report to file, use the 'Export to' drop down in the right lower corner and select the file format, after that press 'Export'.


export-magento-2-report-to-file
Magento 2 Reports Tutorial

It is highly recommended to use Magento 2 reports feature as it can clear out store's performance in deep details and concerning any side of your online business. In case the possibilities of the provided report selections are not enough for you, you can try Magento Store Manager reports generator and create a bulk of additional reports.


Manage Magento 2 reports via Store Manager for 14 days for free - Try now




Related Articles:


How to Create Magento 2 Reports Tutorial

How to Create Magento 2 Reports

Check the variety of Magento 2 reports that can be generated with Store Manager. Read More...

Magento 2 Latency Matrix report Tutorial

Magento 2 Latency Matrix Report

Determine Magento 2 order statistics and analyse customer behavior with Latency Matrix Report. Read More...

Magento 2 Recency Frequency Monetary Report tutorial

Magento 2 Customer Segmentation Report

Perform Magento 2 customer segmentation based on orders with Recency, Frequency and Monetary Report. Read More...

create magento 2 custom reports

Create Magento 2 Custom Reports

Magento 2 custom reports tutorial: build SQL-queries, select report relation (products, customers, orders), design it at your sole discretion. Read More...


COMMENTS
Be the first to comment.
Live Chat