How do I generate a list of all my customers and/or newsletter subscribers?

I can see them in the html newsletter editor, but I want a list of them independently of zen cart (to integrate other client management systems that I use for my business) - and I especially need all of their email addresses.

Where does Zen-Cart store this information on my server and how do I locate it?

Please help!!! THANK YOU!!!

You will need to look in the customers table of the database.

Thank you so much for your reply. Do you know how I can access the database? Should I use an FTP client? Or can I do it through the Zen Cart interface?

I want to export everyone on that customer table.

Neither.

You can access them manually by browsing your customer table using a browser-based database tool such as phpMyAdmin or one of the free GUI tools such as Emma for Linux, Sequel Pro for Mac or HeidiSQL for Windows.

If you want to extract the customer data for use elsewhere you could export it using one of these tools, but if it's going to be a regular thing, you would probably want a developer to write a program that pushes or pulls the data between the databases used by each of your systems.

If this sounds like it's getting a bit technical, that would be because it is, and there's no avoiding it. Creating interoperability between systems requires some technical knowledge of both the systems and the environment in which they operate.

As you're still at the wondering how you can access your database stage, I'm afraid that you may find this a little too much for now, and may need to consider getting some local technical assistance.

If you just want the customers email and first and last name, this add-on is great. It doesn't show addresses or anything though.

http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=80

So, I've installed the Export MOd... but I'm not seeing where it's accessible.

???

luvstoxstitch:

If you just want the customers email and first and last name, this add-on is great. It doesn't show addresses or anything though.

http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=80

This problem and question is being asked in two separate threads. This one and here: http://www.zen-cart.com/forum/showthread.php?t=171110

Does anyone have this add on working and can explain how it works? I've added it also, but now what???

It's under Tools - Export Email...

Choose the type of export you want, CSV, etc. and if you've put the check mark in the 'save to directory' - when you click on 'Save' - it exports the file there.

The filename is 'email_addresses'

Worked just fine with a direct install for me in the last 10 minutes. I did change the download directory to a common one for all my up/downloads.

I'll be looking at adding the HTML/text switch for the download... as soon as I understand digital watches.

I'll be trying to use this with PHPList, since our server is limited to sending 400 emails per hour. gag Can't wait to get big enough for a dedicated server! :cool:

Have fun.

I realize this is an older thread, but I have followed the installation instructions and nothing shows up under Tools, the same problem many other people have had. Does this module work and if so how do I get it working? If it doesn't work, is there another module that will export email addresses? Thank you.

growliesgirl:

Does this module work and if so how do I get it working? If it doesn't work, is there another module that will export email addresses?Yes it works. I used it yesterday.

growliesgirl:

I realize this is an older thread, but I have followed the installation instructions and nothing shows up under Tools, the same problem many other people have had.That usually means you're using a version of the plugin that was designed for a different version of Zen Cart, or your installation steps weren't correct - I'd copy and paste them from the readme file, but you already have them.

Same problem here.

Dragged and dropped the files without touching them to my admin folder.
And nothing under "tools".
Easiest mod to install so far, but not working and I'm under v.1.3.9.h.

Just in case someone knows why it's not working :)

I'm guessing there might be a conflict with another mod.

In v1.3.x the admin tools menu is controlled by the files in /admin/includes/boxes/extra_boxes/
So if you didn't upload the file for that folder, then the menu option won't show.

DrByte:

In v1.3.x the admin tools menu is controlled by the files in /admin/includes/boxes/extra_boxes/
So if you didn't upload the file for that folder, then the menu option won't show.

thanks, just checked and I have email_export_tools_dhtml.php in there.
As a said, just dragged and dropped the whole order, didn't change a thing.

But as other have experienced the same issue, isn't it possible that it's because of another mod?

petitplat:

thanks, just checked and I have email_export_tools_dhtml.php in there.
As a said, just dragged and dropped the whole order, didn't change a thing.

But as other have experienced the same issue, isn't it possible that it's because of another mod?

Did you rename admin folder?

picandnix:

Did you rename admin folder?

yes! hopeful is there something to change somewhere about that?

petitplat:

picandnix:

Did you rename admin folder?yes! hopeful is there something to change somewhere about that?

Sigh.

Yes, there is. It's really quite simple: If you renamed the /admin/ folder to /myadmin/ then any future files you add or edit for the /admin/ folder should be done in the /myadmin/ folder. That includes anything you upload to your site: anything that's to be uploaded to the /admin/ folder would be uploaded to the /myadmin/ folder instead.
Same if you called it /fred/ instead of /myadmin/

DrByte:

Sigh.

Yes, there is. It's really quite simple: If you renamed the /admin/ folder to /myadmin/ then any future files you add or edit for the /admin/ folder should be done in the /myadmin/ folder. That includes anything you upload to your site: anything that's to be uploaded to the /admin/ folder would be uploaded to the /myadmin/ folder instead.
Same if you called it /fred/ instead of /myadmin/

...
ok.
Sorry.
Since there's also an "includes" folder in the "shop" folder... I copied the files there.
Ahem. I have no words for my stupidity.

I hope that at least it'll help some people realize their stupidity too.

Thank you very much.
hiding behind a huge pile of rocks

We have been using this mod without problems until we changed host.

Using version 1.39h with the latest version of the mod installed, but when trying to generate a list, our server eventually times out with an internal server error.

Our host support can replicate the issue and have given the following reason for the error:

Yes, I got the internal server error when I followed the steps you mentioned, I could see the issue is causing due to the timeout error regarding the variable mod_fcgid.

[Wed Oct 30 18:47:25 2013] [warn] [client 86.181.100.118] mod_fcgid: read data timeout in 350 seconds,
[Wed Oct 30 18:47:25 2013] [error] [client 86.181.100.118] Premature end of script headers: (some data removed for privacy)

It is very much clear from the above logs that the module fails to execute in the 350Sec, can you recommend the appropriate value which should be set for mod_fcgid? I can assign the value if that doesn't make harm to the server performance and other users on server. Okay, feel free to get in touch with us if you need us to tweak any server variables like Apache, Nginx(we have reverse proxy enabled in server) or fcgi variables.

Any suggestions how we can get this working as its been a very useful tool for us I the past?

I know this is an old thread, but I wanted to bump with a kudos. This mod rocks! I have three clients using phpList for newsletter processing, and I was trying to find an easy way for them to grab the on-site signups rather than me doing the exporting from the database. Thanks, Doc!

I have a question about the data exported using this mod.

Basically it is giving us 5 choices and counts:

all subscribers
dormant customers
active customer in last 3 months
active customers in last 3 months regardless of subscription status
customers who have never completed a purchase

does the first one (all subscribers) include everyone in the other 4 choices? (except probably the regardless of subscription status of course would include other customers that didn't subscribe)

Or for example is "all subscribers" only people that have made a purchase (and subscribed) and separate from the "customers who have never completed a purchase" choice.