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?
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?
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.
You can use the information to generate an email within Zen Cart (using the customer names) or outside Zen Cart with the email addresses.Code:SELECT customers_name,customers_email_address FROM `orders` where orders_id in (select orders_id from orders_products where products_id='999')
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
thanks for that, i used that and then use mail merge to email out the product recall :-D cheers
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
Bookmarks