Magento 1.4: Disabling all products in a particular category

Question

I need to disable all products that are in a particular category (the category itself is disabled but the products must not show in search, either).

I found this blog post but that's for an older version of Magento than 1.4 - the database structure has changed and I don't know how to adjust the SQL accordingly.

The filtering of products could alternatively be done on a dropdown attribute if that's easier, as all products with this attribute set a certain way are in the category.

Thanks.

Answer 1

with the enhanced admin product grid you can configure it to show the categories: from there you could filter by the category you want and then use "actions" dropdown to disable the products.

HTH.

Answer 2

Just Export the products in your store, then filter the spreadsheet by the category you want to affect. Now you only have the products in that category. Change the Status to disabled and then import the products with the updated status to make the change.