thomasharnan Posted July 31, 2015 Share Posted July 31, 2015 Hello Guys, does anybody know how to mass change edit the default category on various products at the same time? if there existes a module that can do that or an SQL query?, any help will be greatly appreciated, thanks! Link to comment Share on other sites More sharing options...
NemoPS Posted August 1, 2015 Share Posted August 1, 2015 Yes, you can use a sql query. What do these products have in common? The current default category? Otherwise you need to use the IDS Link to comment Share on other sites More sharing options...
gabdara Posted August 1, 2015 Share Posted August 1, 2015 Adapt this SQL to your needs: UPDATE `ps_product` SET `id_category_default`=[new default category id] WHERE `id_category_default`=[old default category id] 1 Link to comment Share on other sites More sharing options...
NemoPS Posted August 5, 2015 Share Posted August 5, 2015 Don't forget the ps_category_product tab association, if they were not associated to it before Link to comment Share on other sites More sharing options...
Recommended Posts