Mass change packages?

[djwmguk]

Hey,

 

I've just imported 60 clients however by accident I selected the wrong package - Is there a way to change several client packages?

 

Thanks

[WHMCS John]

Not via the admin interface. You could run a query via phpmyadmin, but be sure to backup first.

[apsmike]

You can do this but it has risk in it. As suggested by john, first backup your database. Secondly you should have good knowledge of MySql . If you see the WHMCS database you will find a table there by name:

 

tblproducts

 

This table has all the hosting plans added by you in the WHMCS system.

For example now you want to change the packages of clients having current package as "A" to "B"

 

So from "tblproducts" table find thevalue of "id" field for both the packges.

 

For example say package "A" has id 1

and package "B" has id as 2

 

Then now you have to change the table "tblhosting", in this table there is a field by name "packageid". You have to update "packageid" to value 2 where "packageid" value is 1, in this way all clients having hosting plan "A" will be converted to hosting plan "B".

 

Please Note: Do this on your own risk or by some MySql expert as one wrong query can change your whole database.

 

 

 

<<signatures to be set up in your profle>>