Bulk delete empty categories from DB

[bibob]

Hello

 

is there any way to bulk delete empty categories by a query from the database?

[bibob]

Found a solution

 

DELETE FROM`ps_category`  WHERE   `id_category` != 1   and  id_category not in    (SELECT cp.id_category from  ps_category_product cp ) ;

DELETE FROM `ps_category_lang` where id_category not in (select id_category from ps_category);
DELETE FROM `ps_category_group` where id_category not in (select id_category from ps_category);
DELETE FROM `ps_category_shop` where id_category not in (select id_category from ps_category);

[pedash1]

This is excellent

 

Was successful

 

Thankful    

 

 

Found a solution

 

DELETE FROM`ps_category`  WHERE   `id_category` != 1   and  id_category not in    (SELECT cp.id_category from  ps_category_product cp ) ;

DELETE FROM `ps_category_lang` where id_category not in (select id_category from ps_category);
DELETE FROM `ps_category_group` where id_category not in (select id_category from ps_category);
DELETE FROM `ps_category_shop` where id_category not in (select id_category from ps_category);

 

[oleksandr]

Удаление пустых категорий. Что были созданы при тестировании загрузчика, работает, спасибо.

да можно было в ручную, но долго !

[Gipielle]

Hello, this query is for all prestashop versions ?

[jmauclair]

On 4/21/2020 at 12:11 AM, Gipielle said:

Hello, this query is for all prestashop versions ?

I ps 1.7 replace ps_ by miib_

 

DELETE FROM`miib_category`  WHERE   `id_category` != 1   and  id_category not in    (SELECT cp.id_category from  miib_category_product cp ) ;
DELETE FROM `miib_category_lang` where id_category not in (select id_category from miib_category);
DELETE FROM `miib_category_group` where id_category not in (select id_category from miib_category);
DELETE FROM `miib_category_shop` where id_category not in (select id_category from miib_category);

 

Edited July 4, 2021 by jmauclair (see edit history)