wpmattuk Posted February 18, 2019 Share Posted February 18, 2019 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 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted February 18, 2019 Share Posted February 18, 2019 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! 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. 0 Quote Link to comment Share on other sites More sharing options...
wpmattuk Posted February 18, 2019 Author Share Posted February 18, 2019 You're like my personal support at the moment @brian!! Thank you once again. I did wonder about an SQL query, but I'm not that proficient, so thanks for confirming how to do that 🙂 0 Quote Link to comment Share on other sites More sharing options...
wpmattuk Posted February 18, 2019 Author Share Posted February 18, 2019 All done, with a slight tweak - UPDATE tbldomains SET registrar = 'nominet' WHERE domain like '%.uk' Thanks once again @brian! 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted February 18, 2019 Share Posted February 18, 2019 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. 0 Quote Link to comment Share on other sites More sharing options...
wpmattuk Posted February 18, 2019 Author Share Posted February 18, 2019 Understood! I have already moved them over to my TAG yes 🙂 This was the final piece of the jigsaw! 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted February 18, 2019 Share Posted February 18, 2019 Just now, thisismatt said: I have already moved them over to my TAG yes 🙂 This was the final piece of the jigsaw! ok fair enough... just thought it worth mentioning in case you thought transferring the domains was just an SQL query away! 😛 0 Quote Link to comment Share on other sites More sharing options...
sol2010 Posted December 8, 2020 Share Posted December 8, 2020 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? 0 Quote Link to comment Share on other sites More sharing options...
Kian Posted December 8, 2020 Share Posted December 8, 2020 With DomainUpdateWhoisInfo. Registrant details are not stored on your WHMCS but on the Registrar. Depending on the TLD, there could be restrictions and limitations. For example plenty of TLDs require Registrant to approve/verify changes via email. In other words the involved customers could receive notifications (nobody likes it). 0 Quote Link to comment Share on other sites More sharing options...
sol2010 Posted December 8, 2020 Share Posted December 8, 2020 Hi Kian Yes, good point - I hadn't thought about that and it's a real PITA. I'll have to think about it another way. 0 Quote Link to comment Share on other sites More sharing options...
sol2010 Posted December 19, 2020 Share Posted December 19, 2020 Just to follow up, I did a mass update at the registrar and then used the sql above to update WHMCS - not exactly easy but got there in the end without any dramas! 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.