Change All Product Status

[Kenichi]

Hi,

I have a weird situation where 'out of stock and disabled' products are displayed in search and when browsing through categories, but when I click on them it doesn't give the product description or show you product image, since the product is disabled.

I changed the "Products status in Catalog when out of stock should be set to" option to 1, so that should take care of any future problems.

However, is there any SQL command to set ALL product status to 1. Then another SQL command to set all products directly under a disabled category back to 0? I wouldn't want them to appear in searches.

(ZC version 1.5)

Thanks!

[DrByte]

How many "disabled categories" do you have, and why?

[Kenichi]

There's probably around 20ish categories throughout that I have disabled. They're disabled because I use a script to automatically import supplier datafeeds and can't have certain products listed on my site for legal reasons (i.e. weapons that the payment processors do not want sold).

I guess I can go through and do it manually, I just wasn't sure if there was a quick one-liner SQL statement to de-activate products in de-activated categories that someone smart could write out for me :)

Thanks

[DrByte]

There's a quick one-liner to enable all products:
update products set products_status = 1;

or use 0 to disable them all.

It gets more complicated when you want to start involving certain categories, especially if you have products linked to multiple categories.

But you could do the category part by hand: enable the category from the admin, and then disable it again and say yes when it asks if you want to also disable all the products within it.