Jump to content

Bulk Change Registrar For Multiple Domains


thisismatt

Recommended Posts

I've had a quick look around here and general Google search results and don't think I've seen the answer to my question, so - 

I have about 50 domains that I need to change the registrar for in WHMCS; they're currently assigned to different ones and they now all need to move over to a single registrar. How can I make this change in bulk, without needing to individually change 50 records on various client profiles?

Thanks
Matt

Link to comment
Share on other sites

23 minutes ago, thisismatt said:

I've had a quick look around here and general Google search results and don't think I've seen the answer to my question,

at least you made the effort to check first! thanks.png

23 minutes ago, thisismatt said:

I have about 50 domains that I need to change the registrar for in WHMCS; they're currently assigned to different ones and they now all need to move over to a single registrar. How can I make this change in bulk, without needing to individually change 50 records on various client profiles?

using a SQL update query would be the obvious way - though that then leads to the next question of can you easily identify these 50 domains? i'm assuming that you can get a list of these 50 domains and then run an update query such as...

UPDATE tbldomains
SET registrar = 'brian'
WHERE domain IN ('domain1.com','domain2.net')

obviously, change the registrar value to whatever you want to use (and ideally find a domain that is already using that registrar so that you get the value correct).

alternatively, you could just do a copy&paste using phpMyadmin on the affected domains in tbldomains and just change the value of the 'registrar' column for those domains... but if you have a list, the query should be quicker.

Link to comment
Share on other sites

Just now, thisismatt said:

All done, with a slight tweak

aahh, you're a Nominet member too. 🙂

I should add for the avoidance of confusion, that all this query does is change which registrar WHMCS tries to use to manage these domains - you haven't actually changed the registrar responsible for these domains by doing this, and I assume that you have already done that, or intend to do it.

Link to comment
Share on other sites

  • 1 year later...

Hello @brian! 

Another valuable contribution - thank you - I found this as I have a similar - but slightly different  need - to update over 100 domains client domain contact email addresses e.g. the email for the registrant.   

I can see that it is possible to update the SQL with new registrant information (e.g. a new email address in clientsdomaincontacts.php) but - how could I then ensure that all of the new records actually get changed at the registrar too ?

I am needing some kind of way to trigger a mass update to the registrar...  any thoughts?

 

Link to comment
Share on other sites

  • 2 weeks later...

Join the conversation

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

Guest
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