How to set up e-mail test group?

[chacha-vintage]

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!

www.chacha-vintage.com

[DrByte]

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

[chacha-vintage]

DrByte, thanks so much for your quick reply! I am trying to following the instructions from http://www.zen-cart.com/forum/showpo...4&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!

[DrByte]

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.

[chacha-vintage]

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!

[DrByte]

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?

[DrByte]

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\'');