Updating Existing Domain To New Registrar

Note: This is ONLY to update the domains registrar displayed in Clientexec, and does not actually transfer the domain to a new registrar.

In the event that you wish to move one of your clients domains to a new registrar, these instructions will help you with that.

First run this query, to find the ID of the customField (you can run the query at Settings > Utilities > SQL Tool.)

SELECT id FROM customField where groupId=2 AND subGroupId=3 AND name='Registrar';

With that id (normally it will be 8 ) run the next query:

update object_customField SET value='enom' WHERE customFieldId=8 AND objectid=27;

Adjust these in the above Query to match your settings:

value=newregistrar (in the example we used enom).
customFieldId=idFromFirstQuery (this is where we used the 8 from step one, if you got a different number then you would use that).
objectid=UserPackageId (this would be the user package ID of the domain you want to change to the new registrar, see screenshot below).

Updated on: 31/08/2023