As a common tasks when working with Magento 2, deleting existing categories is always a pain if you have to do one by one. With the script below we can remove them via database, saving as a lot of time.

Also see: How to create categories programmatically.

SET FOREIGN_KEY_CHECKS = 0;

TRUNCATE TABLE catalog_category_entity;

TRUNCATE TABLE catalog_category_entity_datetime; 
TRUNCATE TABLE catalog_category_entity_decimal; 
TRUNCATE TABLE catalog_category_entity_int; 
TRUNCATE TABLE catalog_category_entity_text; 
TRUNCATE TABLE catalog_category_entity_varchar; 
TRUNCATE TABLE catalog_category_product; 
TRUNCATE TABLE catalog_category_product_index;

INSERT INTO `catalog_category_entity` (`entity_id`, `attribute_set_id`, `parent_id`, `created_at`, `updated_at`, `path`, `position`, `level`, `children_count`) VALUES ('1', '0', '0', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, '1', '0', '0', '1'),
('2', '3', '1', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, '1/2', '1', '1', '0');

INSERT INTO `catalog_category_entity_int` (`value_id`, `attribute_id`, `store_id`, `entity_id`, `value`) VALUES 
('1', '69', '0', '1', '1'),
('2', '46', '0', '2', '1'),
('3', '69', '0', '2', '1');

INSERT INTO `catalog_category_entity_varchar` (`value_id`, `attribute_id`, `store_id`, `entity_id`, `value`) VALUES 
('1', '45', '0', '1', 'Root Catalog'),
('2', '45', '0', '2', 'Default Category');

DELETE FROM url_rewrite WHERE entity_type = 'category';

SET FOREIGN_KEY_CHECKS = 1;

Happy Coding!

Magento 2: Delete all categorieshttps://i1.wp.com/blog.mdnsolutions.com/wp-content/uploads/2016/05/Screen-Shot-2016-05-06-at-9.29.33-AM.png?fit=452%2C240&ssl=1https://i1.wp.com/blog.mdnsolutions.com/wp-content/uploads/2016/05/Screen-Shot-2016-05-06-at-9.29.33-AM.png?resize=150%2C150&ssl=1Renato MedinaMagentoMagento 2Catalog,Categories,Delete,Magento 2,QueryAs a common tasks when working with Magento 2, deleting existing categories is always a pain if you have to do one by one. With the script below we can remove them via database, saving as a lot of time. Also see: How to create categories programmatically. SET FOREIGN_KEY_CHECKS =...A Magento Craftsman in Melbourne