Quickly Deleting Products & Categories via MySQL

During the development of your Magento project it may be necessary to clear out on mass the Products and Categories from time to time, to do this you can use the following SQL code via phpMyAdmin.

Please note that the following code will DELETE! all of the products and categories from your website, please backup your data first if you are unsure of what you are doing!

Thanks to Mike Smullin in the post http://www.magentocommerce.com/boards/viewthread/20553/ for posting the great set of SQL queries to achieve this.

Unknown source


Leave a reply