Oodlesforless Posted September 11, 2013 Share Posted September 11, 2013 (edited) I want to redo the features that show, but without realizing what the "home" category would (make items the featured ones) do I put all of my items (700+) under subcategories but clicked the home category as well. Is there a way to bulk unclick all items from the home category so my featured items show without screwing up the main category they are in or do I have to do all 700+ one by one (removing the home category)? Edited October 18, 2013 by vekia (see edit history) Link to comment Share on other sites More sharing options...
parsifal Posted September 15, 2013 Share Posted September 15, 2013 (edited) Good morning Oodlesforless. There is a way to achieve such a mass update in one move but it involves direct manipulation of your store's database, i.e. execution of an appropriate MySQL statement via a tool like phpMyAdmin (or via command line, if your host allows you shell access). If your Home category has an ID of 2, the following statement should do the trick: DELETE FROM ps_category_product WHERE id_category = 2; All product-category associations are apparently stored in the table "ps_category_product", so this statement searches all entries for products having been associated with the Home category and deletes those associations. Please, before running this statement, wait for confirmation from other, more knowledgable than me, forum members. I would hate for you to inflict some irreversible damage on your store's database due to a bad piece of advice. And in the name of all that is holy, always backup your database before trying operations such as this that involve direct DB manipulation! Edited September 15, 2013 by parsifal (see edit history) Link to comment Share on other sites More sharing options...
ender666 Posted September 15, 2013 Share Posted September 15, 2013 I was running this statement last week on my shop, its ok DELETE FROM ps_category_product WHERE id_category='2' Link to comment Share on other sites More sharing options...
rarakids Posted October 15, 2013 Share Posted October 15, 2013 Hi guys, Same problem here... with 2000 products. I've just set the wheel sensitivity from my mouse to 100 and all the drag& drop operation was done in 30 seconds )) Select product, scroll from the mouse wheel... done! No sql, php and stuff Link to comment Share on other sites More sharing options...
vekia Posted October 15, 2013 Share Posted October 15, 2013 well, it's good solution, but with sql query it will take 1-2 sec Link to comment Share on other sites More sharing options...
rarakids Posted October 18, 2013 Share Posted October 18, 2013 actually 1881 rows deleted. (Query took 0.0237 sec) Link to comment Share on other sites More sharing options...
vekia Posted October 18, 2013 Share Posted October 18, 2013 well, it's good solution, but with sql query it will take 1-2 sec actually 1881 rows deleted. (Query took 0.0237 sec) my bad it is faster than i thought problem solved? Link to comment Share on other sites More sharing options...
rarakids Posted October 18, 2013 Share Posted October 18, 2013 Yea...kind of... i don't know! ) All my products are gone from "home"! - very good! When I select a product from specific category, it shows featured products from that category - good thing! But when I enter to same product from a direct link it shows featured products from home! - strange Anyway, better than before so I think is solved Link to comment Share on other sites More sharing options...
vekia Posted October 18, 2013 Share Posted October 18, 2013 ok thank you for confirmation im going to mark topic as [solved] best regards Link to comment Share on other sites More sharing options...
prerana Posted October 13, 2014 Share Posted October 13, 2014 ok thank you for confirmation im going to mark topic as [solved] best regards Hi, May be unrelated, but a curious question. How do I delete all the existing categories via query execution? Is it something like, DELETE FROM ps_category WHERE id_category='2' Regards, Prerana Link to comment Share on other sites More sharing options...
pegasus6464 Posted February 18, 2016 Share Posted February 18, 2016 (edited) How can I now add all products to the home category? i only have 5 productos on home thanks!!!!!!!!!!!!!! Edited February 18, 2016 by pegasus6464 (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts