Magento 2 – Deleting all Categories and Products

• admin
• June 25th, 2024
• No Comments

DELETE FROM `catalog_product_entity`;
DELETE FROM `catalog_category_entity` WHERE `entity_id` >= 3;
ALTER TABLE `catalog_category_entity` AUTO_INCREMENT = 3;
DELETE FROM `url_rewrite` WHERE entity_type = 'product';
DELETE FROM `url_rewrite` WHERE entity_type = 'category';