Results 1 to 10 of 30

Hybrid View

  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
    9,106
    Plugin Contributions
    11

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

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

  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,569
    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.
    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
    36
    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
    Nov 2013
    Posts
    4
    Plugin Contributions
    0

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

    Quote Originally Posted by Grancino View Post
    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!!!
    Hello. Where is the "subscribed" field in the customers' table, please? We don't want all customer email addresses.

  9. #9
    Join Date
    Nov 2013
    Posts
    4
    Plugin Contributions
    0

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

    Quote Originally Posted by siriusmw View Post
    Hello. Where is the "subscribed" field in the customers' table, please? We don't want all customer email addresses.
    Note to self: Try exporting the field headers. :) customers_newsletter 1

 

 

Similar Threads

  1. Newsletter Subscriber Discount
    By swguy in forum All Other Contributions/Addons
    Replies: 119
    Last Post: 13 May 2023, 07:51 PM
  2. How to download Newsletter Subscriber Info?
    By goldnuggetsales.com in forum General Questions
    Replies: 1
    Last Post: 12 Aug 2011, 07:19 AM
  3. newsletter subscriber
    By cla74 in forum General Questions
    Replies: 0
    Last Post: 10 May 2009, 02:54 PM
  4. store sends plain text newsletter even to the HTML subscriber
    By one tall man in forum General Questions
    Replies: 3
    Last Post: 13 Mar 2009, 01:49 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
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR