roback Posted October 16, 2009 Share Posted October 16, 2009 I just created a new Group with a 10% discount. but when I went into one of my categories I noticed that it was NOT activated for that group. This would be extremely tedious to change each category and product to include this new group (or future new groups) so is there a way to globally do this for all products/categories?thanks Link to comment Share on other sites More sharing options...
roback Posted October 23, 2009 Author Share Posted October 23, 2009 anyone? Is there a SQL command I can use to do this? or BO way to do this? Please advise. Link to comment Share on other sites More sharing options...
doigro Posted October 24, 2009 Share Posted October 24, 2009 Also interested! Up! Link to comment Share on other sites More sharing options...
roback Posted October 26, 2009 Author Share Posted October 26, 2009 anyone? Seriously? Link to comment Share on other sites More sharing options...
roback Posted October 27, 2009 Author Share Posted October 27, 2009 Okay, I have found the table where the groups are stored. It is (ps_)category_group. i need to add to each id_category a new id_group value of 2.please advise how this is can be written as a SQL command.For each id_category create id_group value=2 in table ps_category_group.any help would be appreciated. Link to comment Share on other sites More sharing options...
Recommended Posts