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

[Joso970]

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.

[Aheadworks]

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/

[Amasty]

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.

[Berone]

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

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

[exto_io]

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.