Removing categories from Magento database
![](http://dev.global4net.com/wp-content/uploads/2018/08/magento-thumbnail.jpeg)
In case of stores which have large category structure, their manual setting may be too difficult. As to make the process faster, it is worth to realize such a process in database.
In that kind of cases You can use the list of the following commands :
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 | TRUNCATE <span class = "a8nnfh" id= "a8nnfh_3" >TABLE</span> `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`; <span class = "a8nnfh" id= "a8nnfh_2" >INSERT</span> INTO `catalog_category_entity`(`entity_id`,`entity_type_id`,`attribute_set_id`,`parent_id`,`created_at`,`updated_at`,`path`,`POSITION`,`level`,`children_count`) VALUES (1,3,0,0, '0000-00-00 00:00:00' , '2009-02-20 00:25:34' , '1' ,1,0,1),(2,3,3,0, '2009-02-20 00:25:34' , '2009-02-20 00:25:34' , '1/2' ,1,1,0); INSERT INTO `catalog_category_entity_int`(`value_id`,`entity_type_id`,`attribute_id`,`store_id`,`entity_id`,`value`) VALUES (1,3,32,0,2,1),(2,3,32,1,2,1); INSERT INTO `catalog_category_entity_varchar`(`value_id`,`entity_type_id`,`attribute_id`,`store_id`,`entity_id`,`value`) VALUES (1,3,31,0,1, 'Root Catalog' ),(2,3,33,0,1, 'root-catalog' ),(3,3,31,0,2, 'Default Category' ),(4,3,39,0,2, 'PRODUCTS' ),(5,3,33,0,2, 'default-category' ); /**** Magento ver. 1.6.x.x ****/ 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`,`entity_type_id`,`attribute_set_id`,`parent_id`,`created_at`,`updated_at`,`path`,`POSITION`,`level`,`children_count`) VALUES (1,3,0,0, '0000-00-00 00:00:00' , '0000-00-00 00:00:00' , '1' ,1,0,1), (2,3,3,1, '0000-00-00 00:00:00' , '0000-00-00 00:00:00' , '1/2' , '1' , '1' , '0' ); INSERT INTO `catalog_category_entity_int`(`value_id`,`entity_type_id`,`attribute_id`,`store_id`,`entity_id`,`value`) VALUES (1,3,32,0,2,1),(2,3,36,0,2,1),(3,3,61,0,2,1),(4,3,44,0,2,NULL),(5,3,45,0,2,1),(6,3,62,0,2,1),(7,3,63,0,2,1),(8,3,64,0,2,NULL); INSERT INTO `catalog_category_entity_varchar`(`value_id`,`entity_type_id`,`attribute_id`,`store_id`,`entity_id`,`value`) VALUES (1,3,31,0,1, 'Root Catalog' ),(2,3,35,0,2, 'Default Category' ),(3,3,37,0,2, 'default-category' ),(4,3,40,0,2,NULL),(5,3,43,0,2, 'PRODUCTS' ),(6,3,52,0,2,NULL),(7,3,55,0,2,NULL); /**** Magento ver. 1.6.x.x ****/ |