Delete empty categories?

[sigol]

Hi,

I am looking for a way (via SQL?) to easily delete all empty categories all the way up to the root.

For example, if I have a third-level category that has no products, I need to delete it. Then, if it's parent category (on level 2) has no other categories, I need to delete that too, etc. etc. all the way back up to the root categories.

Please can somebody point me in the right direction. I'm not afraid of SQL, if you can tell me where I need to be looking.

Best wishes,

Sigol.

[sigol]

Sorry to bump this but I'm a bit desperate. Anybody help?

Thanks in advance.

[Ajeh]

There really isn't a simple method to delete Categories en masse that have no products built into Zen Cart, at this time ...

[sigol]

Hi Ajeh,

Thank you for your reply. I appreciate there may be no ready-made function that deletes empty categories. What I am looking for is an algorithm that I can use to build SQL from.

For instance, for a given category, say ID=x, if the following two statements were true:

1. (select count(*) from products where master_categories_id = x) = 0
2. (select count(*) from categories where parent_id = x) = 0

...then would it be safe to delete category x ?

Thanks,

sigol.

[DrByte]

Don't use master_categories_id. Use products_to_categories.