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?
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.
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:
The data can then be exported in different formats, including CSV, PDF, etc.
You should check out http://www.MagentoReporting.com.
It has a super simple integration through the API and will get you everything you need.
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.