[SOLVED] I need change id of group product

[Abdelkarim]

I have a serious problem with a recently purchased template. Right now I don't have time to wait for your painful support, or to turn back.

For this reason I need to change the id number of a product group.

I have two groups of Hosting products.

• An old one with no products currently in use (id 1)
• Another current one that is the one that I want to convert to id=1

I have seen the following after doing an analysis of the tables.

• tblproductgroup id
• tblproducts gid is associated to tblproductgroup.id
• tblproducts_slug group_id is associated to tblproductgroup.id
• tblproductslinks gid is associated to tblproductgroup.id
• tblproductconfigoptions gid is associated to tblproductgroup.id

I only want to exchange the id, since due to the bad programming of the template, I have to do it to avoid a tremendous UX problem, and the fastest way is for the current Hosting group to come out first in the drop-down list.

Is something left in the pipeline before executing the sql that will change the corresponding id?

Doubts
tblproducts_slugs_tracking slug_id ??? tblproduct.id ?

 

Best regrads.

Edited December 28, 2022 by Abdelkarim

[Abdelkarim]

```

UPDATE tblproductgroups SET id=35 WHERE id=1;
UPDATE tblproducts SET gid=35 WHERE gid=1;
UPDATE tblproducts_slugs SET group_id=35 WHERE group_id=1;
UPDATE tblproductgroups SET id=1 WHERE id=27;
UPDATE tblproducts SET gid=1 WHERE gid=27;
UPDATE tblproducts_slugs SET group_id=1 WHERE group_id=27;

```

 

And working

[othellotech]

n old one with no products currently in use (id 1)

Another current one that is the one that I want to convert to id=1

Would not a simpler method than updating the DB have been to just edit the products in Group2 and change their group to be Group 1 in WHMCS itself ?