thezey Posted April 24, 2015 Share Posted April 24, 2015 Hi, I'm running under Prestashop 1.5.4 version. I have a list of customers who order products from my website, and I'd like to know if it is possible to export this list to CSV file so that I can save their email addresses in my webmail accounts and send them emails when required. I'd also like to organize the CSV file by product so that I know who ordered what product. How can I do that? Thank you Link to comment Share on other sites More sharing options...
NemoPS Posted April 24, 2015 Share Posted April 24, 2015 Did you try the export button at the top of the customers list? Link to comment Share on other sites More sharing options...
thezey Posted April 24, 2015 Author Share Posted April 24, 2015 Yes, I did but it doesn't export emails nor order details. When I open the file in excel, it's quite gibberish as well. Link to comment Share on other sites More sharing options...
NemoPS Posted April 24, 2015 Share Posted April 24, 2015 Odd, it should export emails. As for order details, I guess the only way is to export them separately using the same method. Otherwise, you need a third party module, necessarily Link to comment Share on other sites More sharing options...
thezey Posted April 24, 2015 Author Share Posted April 24, 2015 Is there a module you have in mind that could do the job? Link to comment Share on other sites More sharing options...
prestatent Posted April 24, 2015 Share Posted April 24, 2015 Hi Another option is to export the tables separately using PHPMyAdmin. You would of course have to link up the spreadsheets manually, probably via customer id. If you are familiar with PHPMyAdmin, this should be a straightforward task. The tables you would want to export are: - ps_customer - ps_customer_message - ps_customer_thread - ps_orders 2 Link to comment Share on other sites More sharing options...
NemoPS Posted April 25, 2015 Share Posted April 25, 2015 If you do manage to use phpmyadmin, I'd sugges to join ps_order_detail as well, to grab product names as well, if you need 1 Link to comment Share on other sites More sharing options...
prestatent Posted April 27, 2015 Share Posted April 27, 2015 Good idea Nemo. Link to comment Share on other sites More sharing options...
thezey Posted April 27, 2015 Author Share Posted April 27, 2015 Thank you, guys! I'll give it a try and report back. In the meantime, I still have an open thread about the "on sale" icon not displayed for volume discount. I'll be more than happy if you could take a look at my post (https://www.prestashop.com/forums/topic/434526-on-sale-icon-not-displayed/) and share your knowledge about the topic. Thank you! Link to comment Share on other sites More sharing options...
kirubanidhi Posted May 26, 2017 Share Posted May 26, 2017 Yes it is possible to export customer email in CSV file format. Refered this link https://www.prestashop.com/forums/topic/82304-how-to-export-the-emails-of-customers/ Link to comment Share on other sites More sharing options...
Recommended Posts