How to search for subscribers with a specific "Preference"?

[Krishna Path]

In the Subscription Form I have set up a Preference.

I want to search for all the subscribers that have chosen that preference.

I do not see any way to do this at all.

How to find out which subscribers have chosen a specific preference?

In my case I have set up only one preference, but I just realized that there does not seem to be any way (functionality) that allows me to search through all my subscribers to show me which ones have enabled/selected that preference.

I have hundreds of subscribers and do not want to search through them all one by one individually opening their profiles to try to find out which subscribers selected that preference.

Please help!

[Stefano]

Hi, but did you need a list of those subscribers? You can use the export function to have that list… but usually have a list of houndreds of subscriber is not very useful… explain me what you need to do with that list, may be I can be of help.

[Krishna Path]

“may be I can be of help” Thanks I need it with this one.

What I am trying to do is this:

I have previously set a “Preference” for subscribers to check off to subscribe to get blogposts by email.

So the way I was doing things before I got your “feed by mail” plugin was: I would have to copy the blog post into a newsletter and then I would just check off under the tab in newsletter called “Who will receive It” the preference I created that I made and called “Get Blog Posts By Email”. and send to only those subscribers that had chosen that preference.

But that was a big hassle. And now I have the “feed By Mail” plugin that automatically does this for me.

So the problem is I want to have all the subscribers that have the “preference” chosen “Get Blog Posts By Email” to be now subscribed to the “feed by mail” thing.

But first of all I do not see how to determine on the export list of my subscribers which ones have that preference chosen. And second of all I do not want to go through all the work of individually looking up in the exported file of all my subscribers who chose that preference and then individually open their settings and change them to get the feed by mail. that would be a major time consuming headache.

So if you can recommend a solution to this that would be great!

[Stefano]

Hi, the only solution at this moment is to execute a database query. If you’re able to run a query, I can write it for you.

[Krishna Path]

Yes, please can you write it for me.

But could you just send out a Newsletter plugin update that would add this option to the search options on the Subscribers page? as is shown in this image.

[Stefano]

Assuming the preference you want to “convert” in feed by mail is the number N the query is:

update wp_newsletter set feed=1 where list_N=1

replacing N with your preference number.

[Krishna Path]

As mentioned in my last post “Could you just send out a Newsletter plugin update that would add this option to the search options on the Subscribers page? as is shown in this image.”

How much would it be worth to you to do this if I could pay you to do it?
And it will benefit everyone else to have the functionality! 🙂

[Author]

Posts