How to delete bunch of products in Magento2?

Question

Is there a short and best way to delete bunch of products in Magento2.

I am having list if 1,20,000 SKUs and want to delete that.

Tried:

1. Read CSV
2. Delete products in loop by repository.

Problem:

But the problem is that it is taking too much time.

Any suggestions ?

Answer 1

It's Magento default provide functionality using csv import.

Go to Admin >> System >> Data Trasfer >> Import. https://prnt.sc/26ct8w6

CSV file :

Admin setting:

Answer 2

create below query by php code and Run it in MySQL directly.

DELETE FROM catalog_product_entity WHERE sku in (sku1, sku2, sku3, sku4, ...);

Take Backup first Database

Answer 3

Delete Products from Magento Import/Export option.

System -> Import -> select Entity Type - "Products" -> select Import Behavior - "Delete"

CSV file should contain one column with "sku". Upload CSV file and choose the delete option from Import Behavior.

Answer 4

Please try to this code. or share me your existing code to deleting product.

<?php
$objectManager->get('Magento\Framework\Registry')->register('isSecureArea', true);
$productCollection = $objectManager->create('Magento\Catalog\Model\ResourceModel\Product\CollectionFactory');
$collection = $productCollection->create()->addAttributeToSelect('*')->load();
$app_state = $objectManager->get('\Magento\Framework\App\State');
//$app_state->setAreaCode('frontend');

foreach ($collection as $product){
    try {
        echo 'Deleted '.$product->getName()."<br>";
        $product->delete();

    } catch (Exception $e) {
        echo 'Unable to delete product '.$product->getName()."<br>";
        echo $e->getMessage() . "<br>";
    }   
}
?>