Mass Change Of Customer Group

[Paul13]

I have need to change the Group to a lot of customers.
Can someone help me with the sql command in order to change the group to all clients?

Thanks in advance
 

[Tyson]

Be sure to backup your database before making any changes to it directly.

 

If you are wanting to change all clients from one group to another, then you can run:

UPDATE `clients` SET `client_group_id` = '2' WHERE `clients`.`client_group_id` = '1';

That will result in all clients from group 1 (the default group) being changed to group 2.