mass delete manfacturers with no products

[kburner]

I could not find a thread regarding this issue. Please redirect if you do. Sorry...

I would like to do a mass SQL delete of manufacturers with no products. I do not know SQL.

Does anyone know how to do this? And if it could cause any other problems?

I deleted a lot of products and no longer need manufacturer.

Thanks, Kim

[kuroi]

As always, make sure you have a good backup of your database, then run this via Admin > Tools > SQL Patch

DELETE FROM manufacturers WHERE manufacturers_id NOT IN (SELECT DISTINCT manufacturers_id FROM products WHERE manufacturers_id IS NOT NULL);

[kburner]

As always, make sure you have a good backup of your database, then run this via Admin > Tools > SQL Patch

Worked Perfect!!!

Thank you so much! Kim