Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2007
    Posts
    1,704
    Plugin Contributions
    0

    Default can i email all customers who purchased an item?

    I would like to email all the customers who have purchased a set item from me.

    This is due to an item fault from manufacture and are offing a free upgrade to all customers.

    Is there a way i can email all the customers who have purchased an item?

  2. #2
    Join Date
    Aug 2004
    Location
    New York City
    Posts
    7,174
    Plugin Contributions
    0

    Default Re: can i email all customers who purchased an item?

    Do you know how to run mySQL from your webmaster's panel (most likely CPanel)? This is outside Zen Cart. If you do, this statement will give you the names and email addresses for customers who purchased the product_id in red. Replace that number with the product_id from your database.

    Code:
    SELECT customers_name,customers_email_address  FROM `orders` where orders_id in (select orders_id from orders_products where products_id='999')
    You can use the information to generate an email within Zen Cart (using the customer names) or outside Zen Cart with the email addresses.

    Does that help any?
    Mary Ellen
    I came; I saw; I Zenned
    Taking over the world... one website at a time
    Make sure brain is engaged before putting mouth in gear... or fingers to keyboard.

    Holzheimer
    Fan Odyssey

  3. #3
    Join Date
    Feb 2007
    Posts
    1,704
    Plugin Contributions
    0

    Default Re: can i email all customers who purchased an item?

    thanks for that, i used that and then use mail merge to email out the product recall :-D cheers

  4. #4
    Join Date
    Aug 2004
    Location
    New York City
    Posts
    7,174
    Plugin Contributions
    0

    Default Re: can i email all customers who purchased an item?

    Glad I could help.
    Mary Ellen
    I came; I saw; I Zenned
    Taking over the world... one website at a time
    Make sure brain is engaged before putting mouth in gear... or fingers to keyboard.

    Holzheimer
    Fan Odyssey

 

 

Similar Threads

  1. v139h Email to customers who have ordered a specific item?
    By thehomeopath in forum General Questions
    Replies: 0
    Last Post: 11 Sep 2012, 03:24 PM
  2. Coupon for customers who previously purchased a specific item
    By CKlemow in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 4
    Last Post: 29 Jun 2010, 08:32 AM
  3. Customers who purchased this, also purchased this, CSS issue
    By stlnyc in forum Templates, Stylesheets, Page Layout
    Replies: 5
    Last Post: 25 Jul 2009, 11:12 PM
  4. Replies: 1
    Last Post: 18 Oct 2008, 11:21 PM
  5. Emailing all customers who purchased a product
    By decohenh in forum General Questions
    Replies: 2
    Last Post: 31 Jan 2008, 07:21 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