l3bel l3bel

l3bel / magento_removeAllCategories.sql

Created March 23, 2016 13:13 — 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`;