Page 1 of 1
EXPORT/IMPORT Newsletters Subscribers.
Posted: Thu Sep 30, 2010 4:55 am
by yiyinlah
Hi!
I have searched everywhere in this forum but I only see export/import product/category/catalog modules.
Sorry if I missed it out.
I would like to be able to export newsletters subscribers in CSV format.
But I do not know how.
Is there a way I could view all newsletters subscribers in admin?
Please kindly help me & reply, because this is important.
I do not want to use the default newsletter in admin.
I have my own newsletters services so I would like to export newsletters subscribers.
Thank you!
Re: EXPORT/IMPORT Newsletters Subscribers.
Posted: Thu Sep 30, 2010 8:15 pm
by yiyinlah
Hello?
Anyone please??
Re: EXPORT/IMPORT Newsletters Subscribers.
Posted: Fri Oct 01, 2010 9:14 am
by yiyinlah
Can someone kindly help me?
Re: EXPORT/IMPORT Newsletters Subscribers.
Posted: Fri Oct 01, 2010 2:49 pm
by mystifier
It is very simple to export them yiyinlah, but it needs to be done from your database manager (usually phpmyadmin).
The query is simply:
Code: Select all
SELECT email FROM customer WHERE newsletter = 1
Once you have run the query, the export facility provides many formats including csv.
It ought to be possible to use the Opencart database as a direct datasource in any decent newsletter program but it wouldn't be difficult to write a Newsletter import/export based on the existing back-up/restore.
Re: EXPORT/IMPORT Newsletters Subscribers.
Posted: Sun Jan 16, 2011 2:44 am
by sunburn1979
More typical data in email marketing would include first and last name along with email address for personalisation in your email campaigns.
you can use the following to pull the above data out of the db..
Code: Select all
SELECT firstname, lastname, email FROM customer WHERE newsletter = 1
Re: EXPORT/IMPORT Newsletters Subscribers.
Posted: Sun Nov 04, 2012 5:56 am
by michael2820
mystifier: thank you very much, been looking for this mysql command for weeks.
Re: EXPORT/IMPORT Newsletters Subscribers.
Posted: Sun Nov 04, 2012 6:45 pm
by yiyinlah
Thank you so much everyone!
Re: EXPORT/IMPORT Newsletters Subscribers.
Posted: Wed Jun 25, 2014 3:31 am
by josee225
This information is great thanks.
Could someone tell me how to add the Date Added to export?
Thank you!
Re: EXPORT/IMPORT Newsletters Subscribers.
Posted: Fri Dec 19, 2014 6:59 am
by zerojinx
This was really useful information. I would also like to know how to add the Date Added information to the export.
Re: EXPORT/IMPORT Newsletters Subscribers.
Posted: Fri Dec 19, 2014 10:12 pm
by Cue4cheap
zerojinx wrote:This was really useful information. I would also like to know how to add the Date Added information to the export.
Code: Select all
SELECT firstname, lastname, email, date_added FROM customer WHERE newsletter = 1
Mike