Support » Fixing WordPress » Exporting Customer emails

  • Hey,

    I’m looking for a plugin that will allow me to export all subscribers (active, paused or cancelled) customer emails into a database or excel file. I’ve found a way to export only active subscribers but I would like to also have the info of past subscribers that have cancelled their subscription. I’ve also found a way to export customers who are not subscribers but have made retail purchases. Is there a way I can narrow down my export to only past subscribers and not customers?

    • This topic was modified 2 months, 1 week ago by  Steve Stern.
Viewing 1 replies (of 1 total)
  • Moderator bcworkz

    (@bcworkz)

    Not a plugin, and rather techy, but you could use phpMyAdmin app to do a query for any data you want, constrained by any valid parameters. The resulting list should hopefully fit on one page by changing the number of rows setting. You can then select all rows and export them in any of several formats like CSV, SQL, XML, etc.

    Even if it doesn’t all fit (>500 rows), you can use the SQL LIMIT clause to get several big chunks of data of 500 each. The biggest constraint here is you need to be able to compose the proper SQL query. It may take some research and trial and error, but it’s doable if you have any coding aptitude at all. By aptitude, I do not mean knowledge. Two different things.

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.