bulk transfering products form one server to another within whmcs

[naushad]

Hi,

I have two servers configured on my WHMCS. I upgraded one of them and want to let the smaller one go away. Now lets say that on Server1 (which I want to let go) has a product Linux hosting Product_1 with 25 clients on it. And Server 2 (that I am keeping) has a product Linux hosting Product_1a. Both the products have same privileges. How can I, in one go, shift all 25 accounts on product_1 to product_1a?

Thanks in advance.

[WHMCS John]

Hi,

Running something like this via the SQL tab of phpmyadmin should so the trick:

 

UPDATE tblhosting SET server = 'x' WHERE server = 'y';

 

Replace x with the ID of server 1 and y with the ID of server 2. You can get these values from the tblservers table.

You can then retire/delete Server 2 from the Setup > Products/Services > Servers page.