how do mass delete all products from one manufacturer?

[alibaba99]

hi, not sure how to do this and i wanted to know if there is an easy way to have all products (which are spread across a range of my categories) from just one of my manufaturer, all delleted at the same time.

is it as simple as just deleing the manufacturer from the list?

any help please

mark

[Soniccc]

I don't think it's actually possible to delete the way you described. If you don't want to delete manually you could try using easy populate (it'll take you some time to learn how to use it, but it'll be worth it).

http://www.zen-cart.com/forum/showthread.php?t=34970

/soniccc

[alibaba99]

thanks for reply. not surte where on that thread link to look for the answer as its 102 pages long.

I use easy populate to upload csv so i understand it a little, but how do i use it to manipulate deleting the producst all from one of the manufacturers?

[alibaba99]

I have ahd a thought? would this work.
download csv file of all products.
on excel, filter out the products wity only the manufature i want to delete.
add a dummy category for all the products to appear in.
upload all of these via csv file using easy populate, which should only update each product into the new category.
then perhaps, i can just delet ethat new category???

Would any of the old information still reside on the old categories, or linked to other categories?

would that work?

[kamion]

You could try to fashion an SQL query that will delete it for you from the tables.

Is it just a general product type? Or have you got extra customised SQL tables for your products?

If it's just a general product type without extra SQL tables, then you can simply run this line (but change the "manufacturers_id" number 2 to match the one you want to delete):

DELETE FROM products WHERE manufacturers_id = '2'; 

You run this from the admin page Tools->Install SQL Patches.

Do make a backup of your SQL database before hand though!

Edit: Actually, that would leave the products_description entries.

[Ajeh]

This would be a bad idea as there are many tables involved with Products ...
products
products_description
specials
featured
reviews
etc. etc. etc.