Merging 2 Product Groups

[SERVERJI]

Greetings...

 

We have just migrated from clientexec.

We used to have 2 hosting products A and B under the same group "Shared Hosting" with 100 clients in A and 100 clients in B.

in WHMCS We wish to merge these 2 products into one product A or B (or maybe create a C and put A & B in C) resulting in a single list of 200 clients.

 

Is it possible via WHMCS interface ?

if not, is it possible via SQL tweak ?

Would appreciate the steps kindly.

 

Thanks

 

Jim

[othellotech]

You have 100 users on *product* A and 100 on *product* B in WHMCS

 

Then yes, I'd suggest you create

1 new product with the appropriate description, price, settings etc that you want first.

 

Assuming you dont want to "alter" the settings for the client - i.e. their *package* definition on the server stays the same - then it's as "simple" as

update tblhosting set packageid=N where packageid=O; (swap N for new and O for old)

you can get the ID from the url when you hover over the edit icon in setup, products&services

 

If you do want to change the plan on the server as well, then for each hosting plan in whmcs, view the client details, change the plan in the drop-down, click save, then click "change package"