How to delete all products with images in Magento 2

on 


Copy the query and run in database
SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE catalog_product_entity_media_gallery;
TRUNCATE catalog_product_entity_media_gallery_value;
TRUNCATE catalog_product_entity_media_gallery_value_to_entity;
DELETE FROM `catalog_product_entity`;
ALTER TABLE `catalog_product_entity` AUTO_INCREMENT =1
SET FOREIGN_KEY_CHECKS = 1;
And then run this command in terminal 
1
2
cd <magento_root>/pub/media/catalog/product
rm -rf *

Comments

Post a Comment