tim_ver Posted January 17, 2014 Share Posted January 17, 2014 Is there a way or a mod out that will allow me to deactivate and reactive all products by manufacture or category? As it is now I can only do this one by one and it takes for ever. Link to comment Share on other sites More sharing options...
♥kymation Posted January 17, 2014 Share Posted January 17, 2014 There are addons that allow you to hide/disable any category. I'm not aware of a similar addon for manufacturers. Regards Jim See my profile for a list of my addons and ways to get support. Link to comment Share on other sites More sharing options...
burt Posted January 17, 2014 Share Posted January 17, 2014 update products set products_status = 0 where manufacturers_id = x Change x to the ID of the manufacturer. update products set products_status = 0 where products_id in (select products_id from products_to_categories where categories_id = y) Change y to the ID of the category. Link to comment Share on other sites More sharing options...
tim_ver Posted January 19, 2014 Author Share Posted January 19, 2014 Burt, What files do I make these changes in? And what does this do? Link to comment Share on other sites More sharing options...
tim_ver Posted January 20, 2014 Author Share Posted January 20, 2014 Will this do what I am after - http://addons.oscommerce.com/info/8921? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.