Page 1 of 2 12 LastLast
Results 1 to 10 of 18
  1. #1
    Join Date
    Jan 2011
    Posts
    2
    Plugin Contributions
    0

    red flag How do I Export the Newsletter Subscriber List?

    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!!!

  2. #2
    Join Date
    Jan 2004
    Location
    N of San Antonio TX
    Posts
    5,319
    Plugin Contributions
    6

    Default Re: How do I Export the Newsletter Subscriber List?

    You will need to look in the customers table of the database.
    Did you read the posting tips?!?

  3. #3
    Join Date
    Jan 2011
    Posts
    2
    Plugin Contributions
    0

    Default Re: How do I Export the Newsletter Subscriber List?

    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.

  4. #4
    Join Date
    Apr 2006
    Location
    London, UK
    Posts
    10,655
    Plugin Contributions
    25

    Default Re: How do I Export the Newsletter Subscriber List?

    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.
    See and test drive Zen Cart's free templates at zencarttemplates.info

    Kuroi Web Design and Development | Twitter

    (Questions answered in the forum only - so that any forum member can benefit - not by personal message)

  5. #5
    Join Date
    Jun 2010
    Location
    Ohio
    Posts
    35
    Plugin Contributions
    0

    Default Re: How do I Export the Newsletter Subscriber List?

    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?ma...products_id=80

  6. #6
    Join Date
    Jan 2011
    Posts
    4
    Plugin Contributions
    0

    Default Re: How do I Export the Newsletter Subscriber List?

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

    ???

  7. #7
    Join Date
    Aug 2010
    Posts
    2
    Plugin Contributions
    0

    Default Re: How do I Export the Newsletter Subscriber List?

    Quote Originally Posted by luvstoxstitch View Post
    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?ma...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???

  8. #8
    Join Date
    Sep 2009
    Location
    California
    Posts
    215
    Plugin Contributions
    0

    Have a Drink Re: How do I Export the Newsletter Subscriber List?

    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!

    Have fun.

  9. #9
    Join Date
    Jan 2013
    Posts
    3
    Plugin Contributions
    0

    Default Re: How do I Export the Newsletter Subscriber List?

    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.

  10. #10
    Join Date
    Jan 2004
    Posts
    60,160
    Blog Entries
    4
    Plugin Contributions
    139

    Default Re: How do I Export the Newsletter Subscriber List?

    Quote Originally Posted by growliesgirl View Post
    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.

    Quote Originally Posted by growliesgirl View Post
    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.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donations always welcome: www.zen-cart.com/donate

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.



 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. Newsletter Subscriber Discount
    By swguy in forum All Other Contributions/Addons
    Replies: 101
    Last Post: 8 Jul 2014, 07:31 PM
  2. Error 1267 - Newsletter Subscriber add-on
    By Mana in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 3 Jul 2010, 11:28 PM
  3. Notify on new newsletter subscriber
    By BassFace in forum General Questions
    Replies: 4
    Last Post: 14 Aug 2009, 06:26 AM
  4. newsletter subscriber
    By cla74 in forum General Questions
    Replies: 0
    Last Post: 10 May 2009, 02:54 PM
  5. Export Subscriber Report
    By thecubelab3 in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 29 Sep 2008, 08:59 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •