Advanced Search

Return to Snippet

Revision: 39052
at January 12, 2011 21:57 by TheJasonParker
Initial Code 
UPDATE catalog_product_entity_int cpei, catalog_product_entity cpe
SET value = '2'
WHERE cpe.entity_id = cpei.entity_id
AND attribute_id = "80"
AND cpe.category_ids = "%35%"
AND (cpe.category_ids LIKE "35,%" OR cpe.category_ids LIKE "%,35,%")
Initial URL 
http://www.sonassi.com/knowledge-base/magento-knowledge-base/fast-bulk-product-status-change-with-magento/
Initial Description 
After the MySQL above has run – you’ll need to let Magento take the reigns back a little to update the category indexes, this is quite straightforward, but a little time consuming.

Login to your admin and go to System > Cache Management, the select Rebuild Catalog Index
Initial Title 
Disable products by category
Initial Tags 
magento
Initial Language 
MySQL