Forums / General Questions / Delete a categrory from database

Delete a categrory from database

Locked

Results 1 to 2 of 2

This thread is locked. New replies are disabled.

18 Oct 2009, 7:53 AM

caroline08

New Zenner

Join Date:: Oct 2009
Posts:: 3
Plugin Contributions:: 0

Delete a categrory from database

Hi,

I wanted to delete a category, but I forgot to delete it from the admin page. What I did is I simply delete the category from the category table in mysql database. Actually there are a lot more tables have this category information. How can I delete all the rows which related to this category? Can somebody help me? It's urgent! Thanks a lot!!!

18 Oct 2009, 10:15 PM

perlgerl

New Zenner

Join Date:: Nov 2008
Posts:: 9
Plugin Contributions:: 0

Re: Delete a categrory from database

The category_id appears in tables categories, categories_descriptions, products_to_categories and possibly meta_tags_categories_description.

If you can determine the deleted categories_id (perhaps from one of the other tables) it might be easier to restore the categories_id, parent_id, and categories_status = 1 in table categories, and then delete it properly from Admin > Catalog > Categories/Products.