How to mass deactive one manufacturer's products within a category

[Andrew J]

How to mass deactive one manufacturer's products within a category?

I'd like to do it via phpmyadmin.

Pe: I have Adobe category under the Software category. I'd like to deactivate all the products within the Adobe category.

A proper sql command will help more than just point me to the right direction. :thumbsup:

 

thx, Andrew

[Andrew J]

???

[Guest]

update products set products_status ='0' where manufacturers_id = '2';

 

here 2 is the manufacturers_id of adobe or the required manufacturer.

check what is the manufacturers_id of the manufacturer u want to disable all the products

 

cheers

[Andrew J]

update products set products_status ='0' where manufacturers_id = '2';

 

here 2 is the manufacturers_id of adobe or the required manufacturer.

check what is the manufacturers_id of the manufacturer u want to disable all the products

 

cheers

 

That's what I looking for!

 

Thanks!!!