delete products with a specific attribute

Question

I have an attribute which is called manufacturer (attribute code: manufacturer) and I want to delete all sku's that are from a specific manufacturer.

However I am not sure how to write the SQL (I want to do this via Mysql) I know the basic query to delete a product would be like

  SELECT * FROM magento.catalog_product_entity where sku='abc';

any suggestions? thank you!

Answer 1

Since Magento works with an EAV structure deleting data from the catalog_product_entity table is not enough. You'll also need to delete the data from other tables.

Using Magento objects might be easier and ensures a cleaner database.

A script like the following would do the trick

$collection = Mage::getModel('catalog/product')->getCollection()
 ->addAttributeToFilter('manufacturer', [id]);

foreach ($collection as $product) {
   $product->delete();
}

Answer 2

You can use this query for delete one or multple products from mysql in magento.

DELETE FROM `catalog_product_entity` WHERE `sku` IN ('SKU1', 'SKU2', ...., 'SKU1000');