Send Email To Customers

15 May 2008, 10:06 PM

#1

Zen Follower

Join Date:: Oct 2007
Location:: Safford, AZ
Posts:: 313
Plugin Contributions:: 0

Send Email To Customers

With the Send Email To Customers (Admin->Tools->Send Email) is it possible to configure something so you are able to email customers that are part of a specific group? I have put a few select customers into a group so they can have a discount. Now I would like to email this group to let them know about their new discount level.

Thank you

Steve
Zen cart version: 1.3.9h

15 May 2008, 11:26 PM

#2

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,511
Plugin Contributions:: 176

Re: Send Email To Customers

You'd have to create a new query in the query_builder table for that.
There are several discussions about doing that for other views of the data elsewhere in the forum.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

15 May 2008, 11:35 PM

#3

fatguyinaz

Zen Follower

Join Date:: Oct 2007
Location:: Safford, AZ
Posts:: 313
Plugin Contributions:: 0

Re: Send Email To Customers

Thank you. I will do some searching and reading on the subject.

Steve
Zen cart version: 1.3.9h

16 May 2008, 4:46 AM

#4

fatguyinaz

Zen Follower

Join Date:: Oct 2007
Location:: Safford, AZ
Posts:: 313
Plugin Contributions:: 0

Re: Send Email To Customers

If anyone is interested, I was able to set this up. If you have a special Price Group and you want to be able to send emails to people ONLY in that group. The following I ran from Admin->Tools->Install SQL Patches. Mine in this example is called Monthly.

INSERT INTO query_builder (query_category, query_name, query_description, query_string, query_keys_list) VALUES ('email,newsletters', 'Monthly Group Customers', 'Customers that are all part of the Monthly price group', 'select customers_firstname, customers_lastname, customers_email_address from TABLE_CUSTOMERS where customers_group_pricing = ''1''', '');

You would change wording of your group (query_name), drop-down menu wording (query_description) and the query itself finds my only price group. If you have more then one, make sure to define which you want in customers_group_pricing = 1.

Works perfect. Thank you DrByte for pointing me in the right direction.

Steve
Zen cart version: 1.3.9h

1 Jun 2008, 9:49 PM

#5

thegardenbath

New Zenner

Join Date:: May 2008
Posts:: 7
Plugin Contributions:: 0

Re: Send Email To Customers

Ah, that's just what I was searching for! Brilliant - worked like a charm! :clap:

using: Zen Cart 1.3.8a

1 Dec 2010, 2:09 AM

#6

alabasta79

New Zenner

Join Date:: Jun 2010
Posts:: 21
Plugin Contributions:: 0

Re: Send Email To Customers

FatGuyinAZ:

If anyone is interested, I was able to set this up. If you have a special Price Group and you want to be able to send emails to people ONLY in that group. The following I ran from Admin->Tools->Install SQL Patches. Mine in this example is called Monthly.

INSERT INTO query_builder (query_category, query_name, query_description, query_string, query_keys_list) VALUES ('email,newsletters', 'Monthly Group Customers', 'Customers that are all part of the Monthly price group', 'select customers_firstname, customers_lastname, customers_email_address from TABLE_CUSTOMERS where customers_group_pricing = ''1''', '');

You would change wording of your group (query_name), drop-down menu wording (query_description) and the query itself finds my only price group. If you have more then one, make sure to define which you want in customers_group_pricing = 1.

Works perfect. Thank you DrByte for pointing me in the right direction.

Refering to your customers_group_pricing = ''1'' . The number 1 there refer to group id, is it? If my customer group id is 2, so i must put 2... correct or not?