Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2007
    Posts
    215
    Plugin Contributions
    0

    Default Download customers

    What is the best way to download email addresses - I suppose I could use phpMyAdmin. Tried Quickbooks thing and email download but neither work. Thx.

  2. #2
    Join Date
    Feb 2005
    Location
    Lansing, Michigan USA
    Posts
    20,024
    Plugin Contributions
    3

    Default Re: Download customers


  3. #3
    Join Date
    Sep 2007
    Posts
    215
    Plugin Contributions
    0

    Default Re: Download customers

    Nope doesn't...

  4. #4
    Join Date
    May 2010
    Location
    Arkansas
    Posts
    33
    Plugin Contributions
    0

    Default Re: Download customers

    I would either use phpMyAdmin, or write a custom script to query the database and get the email addresses. Maybe something like this. I only have 1.5 installed anywhere, so if the table or field names are different, they will have to be modified.

    PHP Code:
    <?php
    include("includes/configure.php");

    mysql_connect(DB_SERVER,DB_SERVER_USERNAME,DB_SERVER_PASSWORD);
    mysql_select_db(DB_DATABASE);

    $q "SELECT * FROM " DB_PREFIX "customers ORDER BY customers_firstname;";

    if(
    $r mysql_query($q)){

        
    $output "
    <table>
        <tr>
            <th>Customer Name</th>
            <th>Customer Email Address</th>
        </tr>"
    ;
        while(
    $row mysql_fetch_assoc($r)){
            
    $output .= "
        <tr>
            <td>" 
    $row['customers_firstname'] . " " $row['customers_lastname'] . "</td>
            <td>" 
    $row['customers_email_address'] . "</td>
        </tr>"
    ;
        }
        
    $output .= "
    </table>"
    ;

    echo 
    $output;
    } else {
        echo 
    "Query Failed: " mysql_error();
    }
    ?>

  5. #5
    Join Date
    Feb 2005
    Location
    Lansing, Michigan USA
    Posts
    20,024
    Plugin Contributions
    3

    Default Re: Download customers

    The mod I mentioned works fine on my Zencart test site. What problems did you have with it ?

  6. #6
    Join Date
    Jun 2012
    Posts
    1
    Plugin Contributions
    0

    Default Re: Download customers

    Quote Originally Posted by skrillnet View Post
    I would either use phpMyAdmin, or write a custom script to query the database and get the email addresses. Maybe something like this. I only have 1.5 installed anywhere, so if the table or field names are different, they will have to be modified.
    Hello. I'm sorry - I'm a total beginner, but where would I go to input that text? Or find phpMyAdmin?

 

 

Similar Threads

  1. Need to amend a customers Order Download Status
    By coopergl in forum Managing Customers and Orders
    Replies: 0
    Last Post: 8 Sep 2011, 09:36 PM
  2. Replies: 3
    Last Post: 2 Jan 2011, 01:10 AM
  3. need customers to download more than i file
    By john54 in forum Managing Customers and Orders
    Replies: 2
    Last Post: 11 Jul 2006, 07:47 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