How to set up e-mail test group?

Hi everyone! When I go to send my newsletters, there is an option under "Please select the audience for this newsletter mailing" for "Email test group".

Does anyone know how to set this group up? Right now there are 0 in it. I'd love to get to preview the actual e-mail before it goes out to everyone.

Thanks so much!

https://www.chacha-vintage.com

http://www.zen-cart.com/forum/showthread.php?t=80564

DrByte, thanks so much for your quick reply! I am trying to following the instructions from http://www.zen-cart.com/forum/showpost.php?p=112304&postcount=14.

I am confused by this part: (totally clueless about SQL...)

You can cut and paste the above SQL - just remember to change 'customers_group_pricing = '2'' to match your own 'Test' group ID

If my group name is NewsletterTest, what exact part is supposed to be replaced here? Just the number 2? I have tried a bunch of different combos and nothing seems to be working right.

Thanks so much!

In your Admin->Customers->Group Pricing, which pricing group "number" is assigned to your newsletter test group?

Replace the '2' with '78' if your group number is 78.

Great! That makes a lot more sense! I guess I missed a vital step there.

Now I am trying to run the SQL and get this error:

1062 Duplicate entry 'Newsletter to Test Group Only' for key 2
in:
[INSERT INTO zen_query_builder ( query_id , query_category , query_name , query_description , query_string ) VALUES ( '', 'email,newsletters', 'Newsletter to Test Group Only', 'Send sample newsletter to Customer Test Group only', 'select customers_email_address, customers_lastname, customers_firstname from TABLE_CUSTOMERS WHERE customers_group_pricing = '2'');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Does this mean I first have to restore the backup database before I run this script? Or is there some other way around it? (My group is indeed #2.)

Thanks again for all your help!

That's telling you that you already have a group added named 'Newsletter to Test Group Only'.
Why are you trying to add it twice?

Well, I guess I have made a mess. I was trying to run the script again because this is the error I got when I tried to use the Newsletter Manager and send to my test group.

So, this is the error I need to correct. Gosh, I am feeling high maintenance today.

1054 Unknown column 'NewsletterTest' in 'where clause'
in:
[select customers_email_address, customers_lastname, customers_firstname from zen_customers WHERE customers_group_pricing = NewsletterTest ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Thanks again!

Why did you replace the '2' with 'NewsletterTest' ?

You're making it way harder than you need to.

Undo what you did (delete the extra record you added), and just run the query from the referred post.

DrByte, you're giving me way too much credit. I replaced 2 with NewsletterTest when I was just doing a bunch of stuff and didn't know what I was doing. I didn't know that I really could run the query exactly as written because my test group actually is 2.

I have no idea how to delete that column.

Obviously, as this post has demonstrated and taken up way too much of your time, I need clear step-by-step instructions written for a 2 year-old.

Is there any possibility that you could give me instructions on how to delete that column and return myself to semi-sanity?

Thanks again for all your help!

Try this in phpMyAdmin:```
DELETE FROM zen_query_builder where query_id>6;
INSERT INTO zen_query_builder ( query_id , query_category , query_name , query_description , query_string ) VALUES ( NULL, 'email,newsletters', 'Newsletter to Test Group Only', 'Send sample newsletter to Customer Test Group only', 'select customers_email_address, customers_lastname, customers_firstname from TABLE_CUSTOMERS WHERE customers_group_pricing = '2'');

YAY! It worked!

DrByte, thank you so much for your patience with me!

Also, just wanted to mention that as I was just trying to figure out why my html was not showing up in my test e-mail (I'm sure I'll figure it out eventually!), I came upon another way to set up the Newsletter Test Group!

Admin > Configuration > E-mail Option > Newsletter Test Group E-mail (very last setting)
You just enter the e-mails in there! Who knew?

All the best to you!

chacha-vintage:

Admin > Configuration > E-mail Option > Newsletter Test Group E-mail (very last setting)
You just enter the e-mails in there! Who knew?

All the best to you!

That's part of an addon contribution you're using, and not part of the default Zen Cart install.