Set all categories Use Parent Category Settings to yes

Question

I need to set all categories Use Parent Category Settings to "Yes" from mysql

I have done this sql query:

SELECT * FROM eav_attribute where attribute_code = 'custom_use_parent_settings';

wich give me attribute_id = 68

if i do

UPDATE catalog_category_entity_int set value = 1 where attribute_id = 68; 

only 103 rows are affected but i have 3000 categories

I am missing someting ? only level 1 categories are affected by the query

Answer 1

I tested your queries and works for me. I can think only at this scenario. If value is already set to 1 that row is not modified. Run this query first:

SELECT COUNT(*) FROM catalog_category_entity_int WHERE attribute_id = 68 AND value = 0;

And see how many categories don't use parent category settings and you can run this to see how many already used parent category settings:

SELECT COUNT(*) FROM catalog_category_entity_int WHERE attribute_id = 68 AND value = 1;