Deleting discontinued products

[thelatinbarbie]

I need to delete over 200 products. Can I delete by bulk or do I have to delete 1 by 1

[Ajeh]

Unfortunately ... there is not a bulk deleter at this time and to delete just the products table based on products_status would leave junk in multiple tables and really make a mess ...

You could write custom code for this to be used in the future ... but for now, unless all the products are in the same category and you want to get rid of the whole category this is not possibly to do enmass ...

[thelatinbarbie]

AWWWW!!! darn, ok thanks anyways

[wtashby]

Ajeh,

What if you wanted to delete all of your zero quantity items via sql, and you deleted just a portion of the data, then used easy populates built-in clean up function to get the rest of it. Could that work? And if so, could you please share a snippet that will delete zero quantity products?

What I have right now is something you posted a while back in a different thread that "hides" zero quantity items:

UPDATE products SET products_status = 0 WHERE products_quantity <= 0;

Thanks in advance.

[Ajeh]

Changing products_status in a bulk manner based on products_quantity = 0 is very different from deleting the product ...

To delete the product you have to also clean up the associated tables:
products
products_description
products_to_categories
products_attributes
products_attributes_download
specials
featured
meta_tags_products_description
customers_basket
customers_basket_attributes
reviews
reviews_description

to name just a few ...

While this could be written to manage all of this, it is not something I can just whip together without really working on thi$ for $ome period of time and te$t everything need to make thi$ a perfect add-on to $ave you time and money ...

[wtashby]

I do believe I get get what you're $aying

PM me if'n you wanna talk $ome more about thi$.

Thank$

Tom