imadka

imadka / magento_removeAllCategories.sql

Created July 3, 2017 02:37 — forked from jklance/magento_removeAllCategories.sql

Magento: Remove all categories from a store

	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`;