problem exporting customers as csv file

[Lpeek]

I'm having problems trying to send emails to my customers. I think the prestashop csv export doesn't really work how it should??

I've tried using lots of different email marketing softwares and every time I try import a csv file I get errors. here is an example:

1. from Constant Contact:

The file customers_export_11464774311593936443.csv has id_customer;lastname;firstname;email;ip_address;newsletter_date_add as a heading for column 1. If this column contains email addresses change the column header to Email Address.

2. from MailChimp:

There were no emails added to your list.
64 emails had syntax errors.


Has anyone else had problems importing prestashop csv files into an email marketing program? And more importantly... does anyone know how to fix it??

Any help.. greatly appreciaetd!

[Eugene]

I have exactly the same problem.

I will try to open csv file in Spreadsheet editor and leave only 3 fields: last name, first name and email. However it looks like I'll need to change lastnames as well, since all of them are upper-cased.

I can make a script for correct export, but unfortunately I don't know the structure of Presta shop good enough to make a plugin. If somebody familiar with Presta wants to collaborate - we can release a nice plugin together.

[Lpeek]

Hey Eugene,

I think i might be able to adjust the code in prestashop enough, but I dont know the correct format to export. If you that would be great?!

Although if anyone else is an expert that would be even better!

One other problem I noticed that would be nice to fix is you cannot specify the dates of the users to export. so if you export 100 users, then 10 unsubscribe, then you re-export to get some new users who have signed up you will overwrite the mailing list, including putting back in the users that have already unsubscribed?

[stealthmktg]

lol @ at the "CSV export". It should be called the SCSV export because it exports SEMI-COLON Separated Values, not comma separated values. Freaking boneheaded

[jackbeanoffendsyou]

Anyone got a solution to this? I can't find a way around it! (using mail chimp)