--- title: "Step by Step Guide to Generate Order Report in Magento 2" url: "https://magecomp.com/blog/generate-order-report-magento-2/" date: "2021-09-21T10:00:36+00:00" modified: "2021-09-21T10:00:36+00:00" author: name: "Gaurav Jain" url: "https://magecomp.com/" categories: - "Magento Tutorials" word_count: 414 reading_time: "3 min read" summary: "Hello Magento Friends," description: "To generate order report in Magento 2, go to Report > Sales > Orders. Find out further settings for generating order report in Magento 2." keywords: "Magento Tutorials" language: "en" schema_type: "Article" related_posts: - title: "How To Create 301 Redirect In Magento 2?" url: "https://magecomp.com/blog/create-301-redirect-magento-2/" - title: "MageComp Launched Maintenance Page for Magento 2" url: "https://magecomp.com/blog/magecomp-maintenance-page-magento-2/" - title: "How to Set Shipping Point of Origin in Magento 2" url: "https://magecomp.com/blog/set-shipping-point-of-origin-magento-2/" --- # Step by Step Guide to Generate Order Report in Magento 2 _Published: September 21, 2021_ _Author: Gaurav Jain_ ![How to Generate Order Report in Magento 2](https://magecomp.com/blog/wp-content/uploads/2021/09/How-to-Generate-Order-Report-in-Magento-2-1024x512.webp) **Hello Magento Friends,** In this tutorial, we will learn about How to Generate Order Report in Magento 2. The report provides information about sales, orders, and customer activity. Magento 2 backend provides various reports options for admin to stay informed about various activities of the store like marketing, sales, reviews, and customers. One such report is Order Report. Order Reports can be filtered with options like date, status, and time period. Order Report shows the information on the number of orders, items, sales price, shipping charges, invoice amount, tax charges, and discounts. Let’s get started with How to Generate Order Report in Magento 2. ## Steps to Generate Order Report in Magento 2: **Step 1:** Log in to Admin Panel and navigate to **Report > Sales > Orders** [![order report configuration](https://magecomp.com/blog/wp-content/uploads/2021/09/order-report-configuration.png)](https://magecomp.com/blog/wp-content/uploads/2021/09/order-report-configuration.png) **Step 2:** Perform the configuration settings as follows: - **Date Used** – You have two options here, Order Created or Order Updated.- **Period** – Set it as Day, Month, or Year according to the type of report you need.- **From** – Set this field when the order was created.- **To** – Set this field as till when the order is valid.- **Order Status** – It defines the reported to be generated of which order status. Option Any includes all types of orders excluding Canceled Orders. Selecting the Specified option provides further choices to select specific order statuses from the list.- **Empty Rows** – Setting it to No will exclude empty rows in the report.- **Show Actual Values** – Setting it to No will not mention the actual values of the product in the report. [![order report filter](https://magecomp.com/blog/wp-content/uploads/2021/09/order-report-filter.png)](https://magecomp.com/blog/wp-content/uploads/2021/09/order-report-filter.png) **Step 3:** Once you are done with the configuration, click the **Show Report** button. **Note:** When you click on the Show Report button and if it shows “We couldn’t find any records.” At that time you need to refresh the statistics. - Click on the anchor text **Statistics**. [![statistics](https://magecomp.com/blog/wp-content/uploads/2021/09/statistics.png)](https://magecomp.com/blog/wp-content/uploads/2021/09/statistics.png) - Select all the reports, choose **Refresh Lifetime Statistics**, and click the **Submit** button. [![refresh statistics](https://magecomp.com/blog/wp-content/uploads/2021/09/refresh-statistics.png)](https://magecomp.com/blog/wp-content/uploads/2021/09/refresh-statistics.png) **Step 4:** Now go back to reports and generate order reports by clicking on the **Show Report** button. The report will be generated as shown below based on the specified time period. [![order report](https://magecomp.com/blog/wp-content/uploads/2021/09/order-report.png)](https://magecomp.com/blog/wp-content/uploads/2021/09/order-report.png) The reports can also be saved in a CSV file or Excel File. Select the format and click on **Export**. [![export order report](https://magecomp.com/blog/wp-content/uploads/2021/09/export-order-report.png)](https://magecomp.com/blog/wp-content/uploads/2021/09/export-order-report.png) ## Concluding Words: Consequently, you can Generate Order Report in Magento 2. You can also [**Setup Reports Configuration in Magento 2**](https://magecomp.com/blog/setup-reports-configuration-in-magento-2/). In case of any difficulty feel comfortable and reach out to me via the comment section. Share the article further and be in the loop for more Magento 2 Tutorials. **Happy Reading!** --- _View the original post at: [https://magecomp.com/blog/generate-order-report-magento-2/](https://magecomp.com/blog/generate-order-report-magento-2/)_ _Served as markdown by [Third Audience](https://github.com/third-audience) v3.5.3_ _Generated: 2026-10-02 13:08:23 UTC_