Posted By

TheJasonParker on 01/12/11



Versions (?)

Disable products by category

 / Published in: MySQL


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

  1. UPDATE catalog_product_entity_int cpei, catalog_product_entity cpe
  2. SET value = '2'
  3. WHERE cpe.entity_id = cpei.entity_id
  4. AND attribute_id = "80"
  5. AND cpe.category_ids = "%35%"
  6. AND (cpe.category_ids LIKE "35,%" OR cpe.category_ids LIKE "%,35,%")

Report this snippet  


RSS Icon Subscribe to comments
Posted By: TheJasonParker on January 15, 2011

Doesn't seem to work on Magento v1.4.1.1

You need to login to post a comment.