mage cleanup - The two queries you need when you need to clean out categories and products. I haven't tested this with active orders, yet. I usually use this before re-importing via Magmi. I use this for my own DEVELOPMENT purposes. SHORT RAW: http://git.io/4KbqhA

magecleanup.sql

## PLEASE use this for DEVELOPMENT only. Don't blame me if you're a dumbass.

DELETE FROM `catalog_product_entity`;
DELETE FROM `catalog_category_entity` WHERE `entity_id` NOT IN (1,2);