Articles E-Commerce

How to Generate Reports in Magento eCommerce Store?

How to Generate Reports in Magento eCommerce Store

One of the coolest features in Magento is that it allows the website owners to generate custom reports. Sales report can indicate the progress of your eCommerce store. Most of us create sales reports using the default features in Magento. The website admin can go to Reports -> Sales -> Orders. Filling up the filter form on the same page allows you to create custom sales reports, which helps you get all the required information on the online store.

When you run an online Magento store, you would need to generate accurate sales revenue reports. Different types of custom reports can be generated with Magento.

How to Generate Reports in Magento eCommerce Store

Refreshing Report Statistics:

How to refresh sales report statistics:

  1. On the Admin menu, select Reports > Refresh Statistics.
  2. In the list, select the check box of each report that needs to be refreshed.
  3. Set the Actions control as one of the following:

Refresh Lifetime Statistics

Refresh the Statistics for the Last Day

  1. When complete, click the Submit button.

Product Sales Reports:

Navigate to: Reports > Products > Products Ordered

  • For generating a report for the products ordered for a specific period, you need to select the period from the fields, From and To, Select Show by as Day/Month/Year as per your report period.

For example, lets create a report for 1st June 2016 to 17th June 2016.

Select the dates, select Day as Show by and click on refresh.

Product Sales Reports

Day wise report will be generated for the products ordered for the specified period.

This report can also be exported from the system in excel sheet supported format called CSV. Also as an XML. Select the prefered option from the drop down: Export to, and Export the report.

Total Sales Reports:

Navigate to: Reports > Sales > Orders

  • For generating a report for the sales for a specific period, you need to select the period from the fields, From and To, Select Show by as Day/Month/Year as per your report period.
  • Report can be filtered by Order Status by specific Status as well.
  • Also, you can get the report by Order Created/ Order Updated date.

For example, let’s create a report for 1st June 2016 to 17th June 2016.

Select the dates, select Day as Show by and click on refresh.

Total Sales Reports

Day wise report will be generated for the orders placed per day for the specified period.

This report can also be exported from the system in excel sheet supported format called CSV. Also as an XML. Select the preferred option from the drop down: Export to, and Export the report.

About the author

Binay Jha

Binay Jha is having 16+ years of experience in software development industry. Currently associated with the management team of Magento Development Company. He has a flair for writing on technology related topics.

1 Comment

Click here to post a comment

  • Please let me know if you’re looking for a author for your site.
    You have some really good posts and I think I would be a good asset.
    If youu ever want to take some of the load off, I’d
    absolutely love to write some matterial for your bpog
    inn exchange for a link back to mine. Please blast
    mme an e-mail if interested. Kudos!