Export customer email and birthday?

[idoityourself]

Hi

I was looking at sending out a birthday email to customers, but I hear the module is a little buggy and I want to send the email a month before with a discount to specific birthday party shop products. I thought the easiest way might be to just create a voucher and then send an email through mailchimp each month but does anyone know how to generate an email list with the birth date info on there?

thanks

[hxd]

You can export that info from the database. You can do that with phpMyAdmin, or if you use PrestaShop 1.5 you can do it from the admin panel with the built-in SQL manager (Advanced Parameters menu>SQL Manager).

 

You can execute an SQL query such as this one:

 

SELECT `firstname`, `lastname`, `email`, `birthday` FROM `ps_customer`

 

You have to replace ps with the actual table prefix of your database. Then you can export the results into a CSV file and save it on your local computer. You can view and edit the file with an application such as Microsoft Excel or Open Office Spreadsheet.

 

Hope this helps.

[idoityourself]

Thanks hxd 1.5 doesn't apparently work with my attributes wizard so I cant upgrade, not sure about the other way to do it

[Rhapsody]

you can use phpmyadmin and do the same sql query

[idoityourself]

Found a free module that exports all the data

thanks

[tuomas.anttonen]

Please share the module!!!

[hijabgal]

Found a free module that exports all the data thanks

 

Please share where you got the module from.