I'm looking for a script that allows me to retrieve the list of orders for 6 months with the products sold.
The csv file should look like this:
Salutation,First Name,Last name,Email,Transaction Id,Product Id,Product name,Transaction Timestamp,Telephone
Mr.,John,Doe,JohnDoe@example.com,11800,001,Product Name 1,,020-123-45678
Mr.,John,Doe,JohnDoe@example.com,11800,002,Product Name 2,,020-123-45678
Mr.,John,Doe,JohnDoe@example.com,11800,003,Product Name 3,,020-123-45678
Mr.,Sam,Smith,SSmith@example.com,11801,001,Product Name 1,,
,Jane,,Jane1985@example,11802,001,Product Name 1,009287654321
,Jane,,Jane1985@example,11802,002,Product Name 2,009287654321.
Being a beginner on magento2, I do not know how to develop the script myself.
I hope you can help me
Thank you very much
Best Answer
You can create a stand alone page on root of the magento folder and proceed in this manner :
You can filter the order collection as you want and also get data as per your requirements.