Few Questions (manual operations on the DB)

[crucial]

We are importing our data from WHMAP, and rather than manually edit each package, can we do either of the following without worrying about messing up any other data, or relationships within the database.

 

1. All packages are set to visible by default, the majority of our packages need to be hidden. Can we run something like this to change all packages to hidden:

 

UPDATE `tblproducts` SET hidden='on';

 

2. By default all packages do not have tax enabled, I would like to add tax support to all packages without having to go through and edit each package manually, so can I perform the following:

 

UPDATE `tblproducts` SET tax='1';

 

 

I have tested this on a temporary database, and there does not appear to be any problems - however as I don't know the exact workings of WHMCS I don't know if this will effect anything else.

[crucial]

And another one (for making all product groups hidden):

 

UPDATE `tblproductgroups` SET hidden='on';

[Matt]

Yes, that will be fine.

[crucial]

Hi Matt, great thanks for the quick reply!