Mass enabling disabled products

[bigsy85]

Hi all,

I'm having a problem with alot of products being disabled and having google send visitors to them which causes a redirect as the product no longer exists, I think google is penalizing me for this as traffic has haltered since disabling alot of products.

What I want to do is for all products that are disabled I want to enable them but set the quanity to '0' so that the product will exist but not allow the user to check out.

I have an idea of how to do it but i'm limited by my sql knowledge, the following in the query I want to run on all my products:-

Where product active = '0' set product active to '1' and quantity to '0'.

Can some zen cart wizard please help me out?

[Ajeh]

This will set the Product Quantity to 0 for all Products that are currently disabled:

UPDATE products SET products_quantity= 0 WHERE products_status= 0;

This will set all Product Status to enabled for all Products that have a 0 quantity on the stock:

UPDATE products SET products_status= 1 WHERE products_quantity=0;

NOTE: backup your database before running these ...

[bigsy85]

thanks alot ajeh! that did the job

[Ajeh]

Thanks for the update that you were able to update your products to all display on your catalog by setting the products quantity to 0 and then the products status to on ...

[Sushigal]

I want to do a similar thing except I want to set the quantity of all enabled products to 2000 number. How can I do this without having to go through each individual product? If I need to add a bit of code in, where do I put it? As I'm very new to css and editing code!

Thanks

[Ajeh]

You can run this in the Tools ... Install SQL Patches ...

UPDATE products SET products_quantity = 2000 WHERE products_status =1;

be sure to backup your database before doing changes in this manner ...

[Sushigal]

Fantastic thats just the job. Thank you very much!

[Ajeh]

Thanks for the update that this was able to work for you ...