Temporarily disabling products

[stuffdone]

I need to temporarily disable ALL products from a particular manufacture. Is there a way I can do this? My prior distributor no longer carries this maker and while I negotiate drop ship terms with the new supplier I can't fill orders for this one line of products.

I spent a LOT of time entering about 100 items and don't want to either delete them or manually edit each individual product to "out of stock" while I wait as I would then have to manually make them active again.

Is there a way to temporarily make one mfg's products unavailable for purchase then turn them all back on again later?

[kuroi]

Go to Admin > Catalog > Manufacturers and hover over the information icon ("i" in a circle) for the manufacturer whose products you want to disable. In the bottom left hand corner of your browser a link should appear that ends mID=<number>. That number is the manufacturers ID in your database.

Now BACKUP YOUR DATABASE.

Then go to Admin > Tools > Install SQL Patches, type the following into the big box

update products set products_status=0 where manufacturers_id=<number>;

where <number> is the manufacturers ID and click on the send button.

This should turn all those products from that manufacturer off. To turn them back on again repeat but enter

update products set products_status=1 where manufacturers_id=<number>;

[stuffdone]

Go to Admin > Catalog > Manufacturers and hover over the information icon ("i" in a circle) for the manufacturer whose products you want to disable. In the bottom left hand corner of your browser a link should appear that ends mID=<number>. That number is the manufacturers ID in your database.

Now BACKUP YOUR DATABASE.

Then go to Admin > Tools > Install SQL Patches, type the following into the big boxwhere <number> is the manufacturers ID and click on the send button.

This should turn all those products from that manufacturer off. To turn them back on again repeat but enter

Thanks much ! I will give that a try !

Paul