Temporarily disabling products

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?

:blink:

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>;

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 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:smartalec: