svenweer Posted December 20, 2012 Share Posted December 20, 2012 I want to delete all my categories. Somehow I got like 8000 categories while I only need 12 of them. Does anyone have a SQL script to delete them. It doesnt matter if it delete products or something. thanks! Link to comment Share on other sites More sharing options...
tdr170 Posted December 21, 2012 Share Posted December 21, 2012 Just go to database browse to categories at the top of the page while viewing categories click on empty this will truncate the categories and reset to 1. You may want to also do this for all category tables as well as product tables this will give you a clean slate. As always before editing or changing database tables make a backup. Link to comment Share on other sites More sharing options...
Recommended Posts