How to remove all products of one manufacturer in OpenCart?

Question

opencart

Can you please tell me how to remove all products of one manufacturer in OpenCart?

Answer 1

UPDATE oc_product SET status=0 WHERE manufacturer_id ={desired id}