Bulk removing clients from a client group

[WHMCS JimmyW]

Having clients organized into groups offers some great benefits ranging from being able to identify certain level of clients, to offering automatic group discounts. If you ever need to manage or remove a large number of clients in order to delete a particular group, WHMCS doesn't currently provide a mass deletion option in the UI.

There are alternative options that may save you time to bulk update. As an example, this action could be performed directly within the database.

Firstly, you would need to identify the ID of the client group that you are wanting to empty. This can be identified by checking within the tblclientgroups table. The entry in the `ID` column is the value we need to retrieve. An easy way to do this would be to identify the `group name` and use the `id` from the same row. 

Finally, using the SQL query below, it is possible to remove all clients from a specific client group using the ID you have just located.  

 

UPDATE `tblclients` SET groupid="0" WHERE groupid="X";

In this scenario, you would simply need to update the “X” with the group ID from tblclientgroups.

Using the above command and updating the “0” to another group ID, you would also be able to move all clients from one group into another. 

Please note: performing queries directly to the database is not something that is typically recommended. This is provided only as an example. We are unable to offer any guarantee this query will work with future versions of WHMCS.  As with any change made to a WHMCS installation, we do recommend ensuring you have a full database backup prior to starting. This backup would allow for a swift resolution should any errors occur. 

[Dknowledge]

What about if i want to auto asign client to group base on their account currency

do you have idea on how to fix that?