Mass change customer group

Hi everybody!

I wonder if it's possible (or how difficult it is, I mean :)) to achieve this :

I have a long list of e-mail addresses of current customers in my zen cart database. They are currently in no discount group at all.

I want to add all these people to a certain discount group without too much hassle. I would prefer to not do it manually as it's gonna be more than 5.000 people on this list when I'm done.

Is there a simple and safe way to achieve this with some MySQL script? I mean, I want to import the long list of e-mails into Zen Cart and whenever there is a matching e-mail address in the database I want the script to put that customer in a certain group.

Any ideas would be truly appreciated!

Thanks!

Best regards

Peter

Simply set the customers_group_pricing field to whatever group_id value (from the group_pricing table) you want them to be a member of.

If you have access to phpmyadmin, and it is a one-time thing with the 5000 emails, you could note the current customer_id. Import the new customers, then run a query that changes all customers_group_pricing fields where customer_id is greater than XXX.