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!
It is very simple to export them yiyinlah, but it needs to be done from your database manager (usually phpmyadmin).
The query is simply:
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.
The query is simply:
Code: Select all
SELECT email FROM customer WHERE newsletter = 1It 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.
Free v1.4.9 Extensions: Default Specials | Improved Search | Customer Activity Report | Customer Groups | Royal Mail With Handling | Improved Product Page | Random Products | Stock Report | All Products
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..
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
mystifier: thank you very much, been looking for this mysql command for weeks.
--- please reply only with verified data, that is: no 'I think', 'maybe' etc. ---
This was really useful information. I would also like to know how to add the Date Added information to the export.
Michael Bielaczyc
http://www.aradanicostumes.com
http://www.aradani.com
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 = 1cue4cheap not cheap quality
Who is online
Users browsing this forum: No registered users and 85 guests
