Set all categories Use Parent Category Settings to yes The Next CEO of Stack OverflowGet subcategories of parent category when FLAT categories enabledProduct Collection for Default CategoryCategory layer filter issueHow to set category Is Anchor default to yes for all categoriesApply category's display settings to all subcategoriesWhy do child categories incorrectly inherit custom design from their parent when “Use Flat Catalog Category” is enabled?Truncate Custom Attribute Label/Options using SQL QueryProducts not showing in parent categoriesCustom Page Layouts Assigned Only To Top Level Categories Are Being Applied To Subcategories?Magento 2 tries to load old theme on category pages
Avoiding the "not like other girls" trope?
Is it possible to make a 9x9 table fit within the default margins?
Why do we say “un seul M” and not “une seule M” even though M is a “consonne”?
What did the word "leisure" mean in late 18th Century usage?
Do I need to write [sic] when including a quotation with a number less than 10 that isn't written out?
Ising model simulation
Calculate the Mean mean of two numbers
Is it OK to decorate a log book cover?
How to pronounce fünf in 45
How dangerous is XSS
How exploitable/balanced is this homebrew spell: Spell Permanency?
Raspberry pi 3 B with Ubuntu 18.04 server arm64: what pi version
How do I secure a TV wall mount?
Small nick on power cord from an electric alarm clock, and copper wiring exposed but intact
Would a grinding machine be a simple and workable propulsion system for an interplanetary spacecraft?
Is it possible to create a QR code using text?
Can Sri Krishna be called 'a person'?
Why does freezing point matter when picking cooler ice packs?
Why was Sir Cadogan fired?
Simplify trigonometric expression using trigonometric identities
Is the offspring between a demon and a celestial possible? If so what is it called and is it in a book somewhere?
What day is it again?
Compensation for working overtime on Saturdays
Prodigo = pro + ago?
Set all categories Use Parent Category Settings to yes
The Next CEO of Stack OverflowGet subcategories of parent category when FLAT categories enabledProduct Collection for Default CategoryCategory layer filter issueHow to set category Is Anchor default to yes for all categoriesApply category's display settings to all subcategoriesWhy do child categories incorrectly inherit custom design from their parent when “Use Flat Catalog Category” is enabled?Truncate Custom Attribute Label/Options using SQL QueryProducts not showing in parent categoriesCustom Page Layouts Assigned Only To Top Level Categories Are Being Applied To Subcategories?Magento 2 tries to load old theme on category pages
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
magento-1.9 database category layout
edited 2 days ago
Teja Bhagavan Kollepara
3,00841949
asked Mar 20 '18 at 23:01
GSM BoutiqueGSM Boutique
284
add a comment |
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
magento-1.9 database category layout
edited 2 days ago
Teja Bhagavan Kollepara
3,00841949
asked Mar 20 '18 at 23:01
GSM BoutiqueGSM Boutique
284
add a comment |
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
magento-1.9 database category layout
edited 2 days ago
Teja Bhagavan Kollepara
3,00841949
asked Mar 20 '18 at 23:01
GSM BoutiqueGSM Boutique
284
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
magento-1.9 database category layout
magento-1.9 database category layout
edited 2 days ago
Teja Bhagavan Kollepara
3,00841949
asked Mar 20 '18 at 23:01
GSM BoutiqueGSM Boutique
284
edited 2 days ago
Teja Bhagavan Kollepara
3,00841949
asked Mar 20 '18 at 23:01
GSM BoutiqueGSM Boutique
284
edited 2 days ago
Teja Bhagavan Kollepara
3,00841949
edited 2 days ago
Teja Bhagavan Kollepara
3,00841949
edited 2 days ago
Teja Bhagavan Kollepara
3,00841949
3,00841949
asked Mar 20 '18 at 23:01
GSM BoutiqueGSM Boutique
284
asked Mar 20 '18 at 23:01
GSM BoutiqueGSM Boutique
284
asked Mar 20 '18 at 23:01
GSM BoutiqueGSM Boutique
284
284
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
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;
answered Mar 21 '18 at 7:31
CiprianCiprian
342114
if i run SELECT COUNT(*) FROM catalog_category_entity_int WHERE attribute_id = 68 AND value = 0; i have 0 results
– GSM Boutique
Mar 21 '18 at 8:48
That means all the categories are set to get parent category settings. So everything is what you want. Right?
– Ciprian
Mar 21 '18 at 9:02
no is not if i run SELECT COUNT(*) FROM catalog_category_entity_int WHERE attribute_id = 68 AND value = 1; i get 109 rows.
– GSM Boutique
Mar 21 '18 at 9:11
And what you get if you run: SELECT * FROM catalog_category_entity_int WHERE attribute_id = 68; ? Or SELECT COUNT(*) FROM catalog_category_entity_int WHERE attribute_id = 68;
– Ciprian
Mar 21 '18 at 9:25
I get count 109
– GSM Boutique
Mar 21 '18 at 11:50
|
show 1 more comment
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f219133%2fset-all-categories-use-parent-category-settings-to-yes%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
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;
answered Mar 21 '18 at 7:31
CiprianCiprian
342114
if i run SELECT COUNT(*) FROM catalog_category_entity_int WHERE attribute_id = 68 AND value = 0; i have 0 results
– GSM Boutique
Mar 21 '18 at 8:48
That means all the categories are set to get parent category settings. So everything is what you want. Right?
– Ciprian
Mar 21 '18 at 9:02
no is not if i run SELECT COUNT(*) FROM catalog_category_entity_int WHERE attribute_id = 68 AND value = 1; i get 109 rows.
– GSM Boutique
Mar 21 '18 at 9:11
And what you get if you run: SELECT * FROM catalog_category_entity_int WHERE attribute_id = 68; ? Or SELECT COUNT(*) FROM catalog_category_entity_int WHERE attribute_id = 68;
– Ciprian
Mar 21 '18 at 9:25
I get count 109
– GSM Boutique
Mar 21 '18 at 11:50
|
show 1 more comment
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;
answered Mar 21 '18 at 7:31
CiprianCiprian
342114
if i run SELECT COUNT(*) FROM catalog_category_entity_int WHERE attribute_id = 68 AND value = 0; i have 0 results
– GSM Boutique
Mar 21 '18 at 8:48
That means all the categories are set to get parent category settings. So everything is what you want. Right?
– Ciprian
Mar 21 '18 at 9:02
no is not if i run SELECT COUNT(*) FROM catalog_category_entity_int WHERE attribute_id = 68 AND value = 1; i get 109 rows.
– GSM Boutique
Mar 21 '18 at 9:11
And what you get if you run: SELECT * FROM catalog_category_entity_int WHERE attribute_id = 68; ? Or SELECT COUNT(*) FROM catalog_category_entity_int WHERE attribute_id = 68;
– Ciprian
Mar 21 '18 at 9:25
I get count 109
– GSM Boutique
Mar 21 '18 at 11:50
|
show 1 more comment
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;
answered Mar 21 '18 at 7:31
CiprianCiprian
342114
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;
answered Mar 21 '18 at 7:31
CiprianCiprian
342114
answered Mar 21 '18 at 7:31
CiprianCiprian
342114
answered Mar 21 '18 at 7:31
CiprianCiprian
342114
answered Mar 21 '18 at 7:31
CiprianCiprian
342114
342114
if i run SELECT COUNT(*) FROM catalog_category_entity_int WHERE attribute_id = 68 AND value = 0; i have 0 results
– GSM Boutique
Mar 21 '18 at 8:48
That means all the categories are set to get parent category settings. So everything is what you want. Right?
– Ciprian
Mar 21 '18 at 9:02
no is not if i run SELECT COUNT(*) FROM catalog_category_entity_int WHERE attribute_id = 68 AND value = 1; i get 109 rows.
– GSM Boutique
Mar 21 '18 at 9:11
And what you get if you run: SELECT * FROM catalog_category_entity_int WHERE attribute_id = 68; ? Or SELECT COUNT(*) FROM catalog_category_entity_int WHERE attribute_id = 68;
– Ciprian
Mar 21 '18 at 9:25
I get count 109
– GSM Boutique
Mar 21 '18 at 11:50
|
show 1 more comment
if i run SELECT COUNT(*) FROM catalog_category_entity_int WHERE attribute_id = 68 AND value = 0; i have 0 results
– GSM Boutique
Mar 21 '18 at 8:48
That means all the categories are set to get parent category settings. So everything is what you want. Right?
– Ciprian
Mar 21 '18 at 9:02
no is not if i run SELECT COUNT(*) FROM catalog_category_entity_int WHERE attribute_id = 68 AND value = 1; i get 109 rows.
– GSM Boutique
Mar 21 '18 at 9:11
And what you get if you run: SELECT * FROM catalog_category_entity_int WHERE attribute_id = 68; ? Or SELECT COUNT(*) FROM catalog_category_entity_int WHERE attribute_id = 68;
– Ciprian
Mar 21 '18 at 9:25
I get count 109
– GSM Boutique
Mar 21 '18 at 11:50
if i run SELECT COUNT(*) FROM catalog_category_entity_int WHERE attribute_id = 68 AND value = 0; i have 0 results
– GSM Boutique
Mar 21 '18 at 8:48
if i run SELECT COUNT(*) FROM catalog_category_entity_int WHERE attribute_id = 68 AND value = 0; i have 0 results
– GSM Boutique
Mar 21 '18 at 8:48
That means all the categories are set to get parent category settings. So everything is what you want. Right?
– Ciprian
Mar 21 '18 at 9:02
That means all the categories are set to get parent category settings. So everything is what you want. Right?
– Ciprian
Mar 21 '18 at 9:02
no is not if i run SELECT COUNT(*) FROM catalog_category_entity_int WHERE attribute_id = 68 AND value = 1; i get 109 rows.
– GSM Boutique
Mar 21 '18 at 9:11
no is not if i run SELECT COUNT(*) FROM catalog_category_entity_int WHERE attribute_id = 68 AND value = 1; i get 109 rows.
– GSM Boutique
Mar 21 '18 at 9:11
And what you get if you run: SELECT * FROM catalog_category_entity_int WHERE attribute_id = 68; ? Or SELECT COUNT(*) FROM catalog_category_entity_int WHERE attribute_id = 68;
– Ciprian
Mar 21 '18 at 9:25
And what you get if you run: SELECT * FROM catalog_category_entity_int WHERE attribute_id = 68; ? Or SELECT COUNT(*) FROM catalog_category_entity_int WHERE attribute_id = 68;
– Ciprian
Mar 21 '18 at 9:25
I get count 109
– GSM Boutique
Mar 21 '18 at 11:50
I get count 109
– GSM Boutique
Mar 21 '18 at 11:50
|
show 1 more comment
Thanks for contributing an answer to Magento Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f219133%2fset-all-categories-use-parent-category-settings-to-yes%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
