Gathering a list of Newsletter subscribers?

[lecarlb]

Hello everyone,

After getting a new newsletter addon coded I noticed that at this moment Phoenix doesn't have the ability to filter or any way of separating the customers that have opted in to receive newsletters. That's the beauty of open source so the community can solve things like this

I need an sql query that will select the customers that have opted in to receive newsletters. Also, I think @raiwa's guest checkout allows customers to opt-in to newsletters.

The purpose is to start capitalizing on past customers via internal marketing.

Thanks for your help. Happy New Year.

EDIT: Does Phoenix's current Newsletter infrastructure has a way to unsubscribe or subscribe in case past customers change their mind?

The reason I asked is because you may be able to entice past customers to subscribe or become a repeat buyer by offering an incentive.

[heatherbell]

sql query that will select the customers that have opted in to receive newsletters.

Depends on what information you want from the table.
For example:

Code: Select all

SELECT customers_firstname, customers_lastname, customers_email
FROM customers
WHERE customers_newsletter = 1;

[lecarlb]

Thank you @heatherbell. The query you suggested helped me to get the info I needed.

Here's what worked:

Code: Select all

SELECT customers_firstname, customers_lastname, customers_email_address FROM customers WHERE customers_newsletter = 1;

[raiwa]

Guest checkout allows to write reviews. Newsletter subscription is not supported. Remember guest accounts are auto deleted. So no customer account mail is available and the sense of guest checkout is to store only the strict necessary information for the order.

[Dan Cole]

You can set up an account content module so customers can subscribe and unsubscribe. I've done that on my site and have created sub groups for different types of mailings....ie new products, specials, general hobby information mailings etc. Customers can choice those they are interested in and leave the rest. At the moment it is in use on an old 1.0.5.0 site but I'm in the process of updating it. If you want to have a look just send me a PM and I'll give you a link to my site.

Dan