Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2005
    Posts
    186
    Plugin Contributions
    0

    Default Need Snail Mail List

    I am wanting to occasionally mail special flyers to customers and can not figure out how to export the most current customer addresses. I tried exporting the address book in CSV format from MyPhpAdmin but it does not give me the state or county. Just the codes. I really do not want to have to manually enter thousands of addresses for a mailing.

    Thanks,
    Marc

  2. #2
    Join Date
    Jul 2009
    Location
    Texas
    Posts
    209
    Plugin Contributions
    2

    Default Re: Need Snail Mail List

    Here's my query to get all US deliverable addresses.

    SELECT CONCAT( c.customers_firstname, " ", c.customers_lastname ) AS FullName, ab.entry_street_address AS Address1, ab.entry_suburb AS Address2, ab.entry_postcode AS ZipPostalCode, ab.entry_city AS City, sa.abbrev AS StateAB
    FROM cart1_customers c, cart1_address_book ab
    LEFT JOIN cart1_zones z ON ( ab.entry_zone_id = z.zone_id
    AND ab.entry_country_id = z.zone_country_id )
    LEFT JOIN cart1_countries co ON ab.entry_country_id = co.countries_id
    LEFT JOIN mailing_lists.stateabbrev sa ON IF(ISNULL(z.zone_name), co.countries_name, z.zone_name ) = sa.name
    WHERE ab.customers_id = c.customers_id
    AND ab.address_book_id = c.customers_default_address_id
    AND (
    co.countries_name = 'Guam' OR
    co.countries_name = 'Puerto Rico' OR
    co.countries_name = 'Virgin Islands (U.S.)' OR
    co.countries_name = 'American Samoa' OR
    co.countries_name = 'Marshall Islands' OR
    co.countries_name = 'Micronesia, Federated States of' OR
    co.countries_name = 'Northern Mariana Islands' OR
    co.countries_name = 'Palau' OR
    co.countries_name = 'United States')

  3. #3
    Join Date
    Jan 2010
    Posts
    189
    Plugin Contributions
    1

    Default Re: Need Snail Mail List

    You should be able to use the Apsona export add-on for this purpose. The add-on is here: http://www.zen-cart.com/index.php?ma...oducts_id=1500


    Your feedback on this add-on is very welcome.

    Apsona
    -------------------------------
    http://apsona.com

 

 

Similar Threads

  1. (Snail) Mail list?
    By Serious in forum General Questions
    Replies: 8
    Last Post: 6 Mar 2013, 12:13 AM
  2. downloads and snail mail
    By Didee in forum Setting Up Categories, Products, Attributes
    Replies: 12
    Last Post: 14 Feb 2009, 07:12 AM
  3. sql query to output snail mail addresses?
    By filmfr3ak in forum General Questions
    Replies: 1
    Last Post: 24 Jan 2009, 11:23 PM
  4. Creating a Snail Mail List
    By cherish in forum General Questions
    Replies: 1
    Last Post: 17 Oct 2006, 11:48 PM

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