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
Why don't programming languages automatically manage the synchronous/asynchronous problem?
Make solar eclipses exceedingly rare, but still have new moons
Is there a difference between "Fahrstuhl" and "Aufzug"
Would a galaxy be visible from outside, but nearby?
How to safely derail a train during transit?
WOW air has ceased operation, can I get my tickets refunded?
Real integral using residue theorem - why doesn't this work?
How do I go from 300 unfinished/half written blog posts, to published posts?
Why didn't Khan get resurrected in the Genesis Explosion?
Is it ever safe to open a suspicious html file (e.g. email attachment)?
Why am I allowed to create multiple unique pointers from a single object?
Is 'diverse range' a pleonastic phrase?
Example of a Mathematician/Physicist whose Other Publications during their PhD eclipsed their PhD Thesis
If Nick Fury and Coulson already knew about aliens (Kree and Skrull) why did they wait until Thor's appearance to start making weapons?
MessageLevel in QGIS3
If the heap is zero-initialized for security, then why is the stack merely uninitialized?
Plot of histogram similar to output from @risk
Why do remote companies require working in the US?
Are there any limitations on attacking while grappling?
Elegant way to replace substring in a regex with optional groups in Python?
Novel about a guy who is possessed by the divine essence and the world ends?
What happens if you roll doubles 3 times then land on "Go to jail?"
Can I run my washing machine drain line into a condensate pump so it drains better?
How to prevent changing the value of variable?
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
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
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
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 44 mins ago
![](https://i.stack.imgur.com/qUGVv.jpg?s=32&g=1)
![](https://i.stack.imgur.com/qUGVv.jpg?s=32&g=1)
Teja Bhagavan Kollepara
3,01241949
3,01241949
asked Mar 20 '18 at 23:01
![](https://lh4.googleusercontent.com/-YBkWj6PpQgk/AAAAAAAAAAI/AAAAAAAAABU/buFHokB9lr8/photo.jpg?sz=32)
![](https://lh4.googleusercontent.com/-YBkWj6PpQgk/AAAAAAAAAAI/AAAAAAAAABU/buFHokB9lr8/photo.jpg?sz=32)
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;
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
Your Answer
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;
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;
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;
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
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