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
Rotate a column
Is there a difference between "Fahrstuhl" and "Aufzug"
MessageLevel in QGIS3
What was the first Unix version to run on a microcomputer?
Indicator light circuit
I believe this to be a fraud - hired, then asked to cash check and send cash as Bitcoin
Complex fractions
Why didn't Khan get resurrected in the Genesis Explosion?
How did the Bene Gesserit know how to make a Kwisatz Haderach?
Which kind of appliances can one connect to electric sockets located in an airplane's toilet?
How to avoid supervisors with prejudiced views?
Does it take more energy to get to Venus or to Mars?
Is it my responsibility to learn a new technology in my own time my employer wants to implement?
Is it ever safe to open a suspicious html file (e.g. email attachment)?
What is the result of assigning to std::vector<T>::begin()?
Preparing Indesign booklet with .psd graphics for print
How to safely derail a train during transit?
Written every which way
How do I reset passwords on multiple websites easily?
If a black hole is created from light, can this black hole then move at speed of light?
What happened in Rome, when the western empire "fell"?
What does convergence in distribution "in the Gromov–Hausdorff" sense mean?
What benefits would be gained by using human laborers instead of drones in deep sea mining?
Unreliable Magic - Is it worth it?
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 56 mins ago
Teja Bhagavan Kollepara
3,01241949
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 56 mins ago
Teja Bhagavan Kollepara
3,01241949
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 56 mins ago
Teja Bhagavan Kollepara
3,01241949
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 56 mins ago
Teja Bhagavan Kollepara
3,01241949
asked Mar 20 '18 at 23:01
GSM BoutiqueGSM Boutique
284
edited 56 mins ago
Teja Bhagavan Kollepara
3,01241949
asked Mar 20 '18 at 23:01
GSM BoutiqueGSM Boutique
284
edited 56 mins ago
Teja Bhagavan Kollepara
3,01241949
edited 56 mins ago
Teja Bhagavan Kollepara
3,01241949
edited 56 mins ago
Teja Bhagavan Kollepara
3,01241949
3,01241949
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
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;
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
