Is there a solution to enable / disable manufacturer?

[Guest]

Hi,

 

I'm looking for a solution to enable / disable all products from a specific manufacturer. Some manufacturers we work with are on a break for a few months but they'll be back so I don't want to delete the products (hundreds of products, will be a pain to put them back).

So I need to disable a manufacturer and all his products then enable later. I saw that some recommend modifying a contribution like enable/disable categories, but it's waaaay beyond my expertise :)

I'm thinking that maybe someone already did this and could help.

 

Thank you so much!

[♥mdtaylorlrim]

I am not all that familiar with contributions so maybe there is one and I do not know it. But, all it would take is a simple sql statement to make all the products from a specific manufacturer disabled.

 

If no one points you to a contribution we can draft the sql statement for you.

[burt]

UPDATE `products`
SET `products_status` = '0'
WHERE `manufacturers_id` = 'x';

 

Change the x to the numeric ID of the manufacturer whose products you want disabled.

 

Should do it.

[russischblauekatze]

UPDATE `products`
SET `products_status` = '0'
WHERE `manufacturers_id` = 'x';

 

Change the x to the numeric ID of the manufacturer whose products you want disabled.

 

Should do it.

 

Unfortunately it's not done by setting the manufacturer's products to "not available". The manufacturer will still show up in the advanced search and in the search by manufacturers.

If you don't want this, you have to delete the manufacturer (but not his products!). Later, when you reactivate him, you need to give back each product the manufacturer.

This method isn't very comfortable.

I'd liked to implement a procedure in admin/manufacturers.php like Easy Enable and Disable product categories does for categories in admin/categories.php.

 

Birgit

[Guest]

Yes, I understand that something like Easy Enable categories is best. But I'm sure I can't do that.. Thank you all for answering, I'm not yet sure what to do.