Client Groups - Mass update/Add

[Beno78]

Hey guys,

 

Our previous admin failed to utilise client groups on WHMCS, and I am wanting to set it up.

 

Problem is, we have 600+ clients, and 400-500 are to go in one group. Is there anyway to do this as a mass update, instead of one by one?

 

Thanks.

[WHMCS John]

Hi,

Something like this should do the trick (run it via the SQL tab in phpmyadmin):

 

update tblclients
set groupid = 'x'
where groupid = '';

 

Replace x with the ID of the client group you wish to use (you can find this in your browser's URL bar when editing the client group) All clients will be assigned to this group.

 

As always, before making changes to the database, please backup.