SQL update of customer groups

[jpryce]

Seems this is a sticking point for a lot of users... creating a new cutsomer group doesn't automatically add them to categories. It seems the only way to do it is to add your new customer group into the database by inserting into all the category IDs. Anyone know the SQL statement to do this in one hit? Maybe a range would work but i don't know SQL well e.g. id_category 1-388, id_group 4 or is there a way of adding an 'all' statement...

 

Thanks

 

James

[Ali Samie]

Thats why the system is designed in layers and the core developers implemented ObjectModels.

You can create a customer group with CustomerGroup object model and then associate that into the categories with out SQL codes