Jump to content

Client Groups - Mass update/Add


Recommended Posts

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?



Link to comment
Share on other sites

  • WHMCS Support Manager


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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated