CE Phoenix Cart Forum

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.

lecarlb wrote: ↑Sun Jan 28, 2024 1:06 pmsql query that will select the customers that have opted in to receive newsletters.

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

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

Here's what worked:

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.

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