cancel
Showing results for 
Search instead for 
Did you mean: 

Report data with customers, orders and products purchased in csv format.

Report data with customers, orders and products purchased in csv format.

Hi, I need to create reports in CSV / Excel file with details of customers and products they bought. It would also be interesting to view them in the backend before export them.

I tried the extensions around, but I was not entirely convinced.

Could you help me to understand how I can do for this type of report?

Thank you.

4 REPLIES

Re: Report data with customers, orders and products purchased in csv format.

Hi, 

You can try our Advanced Reports allowing to export each report to CSV or XML formats. And it has the report (Orders Detailed) you ask for, I think.

Magento 1: https://ecommerce.aheadworks.com/magento-extensions/advanced-reports.html

Magento 2: http://ecommerce.aheadworks.com/magento-2-extensions/advanced-reports/

 

Re: Report data with customers, orders and products purchased in csv format.

Hi @Joso970

 

I believe this extension will let you create the reports you need https://amasty.com/magento-advanced-reports.html

 

Currently it includes the following report types:

  • Advanced Sales ReportS
  • Sales by Product Report
  • Sales by Weekday
  • Sales by Hour
  • Sales by Coupon Code
  • Profit Report
  • Country Report
  • New vs. Returning Customers Report
  • Bestsellers Report

The data can then be exported in different formats, including CSV, PDF, etc.

 

 

Was my answer helpful? You can accept it as a solution.
200+ professional extensions for M1 & M2 with free lifetime updates!

Re: Report data with customers, orders and products purchased in csv format.

You should check out http://www.MagentoReporting.com.

 

It has a super simple integration through the API and will get you everything you need.

Re: Report data with customers, orders and products purchased in csv format.

Have a look at Exto Analytics: exto.io/exto-analytics-for-magento-2.html

It does most what you need and is totally free for M2 CE.