Set all categories Use Parent Category Settings to yes
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 47 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 47 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 47 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 47 mins ago
Teja Bhagavan Kollepara
3,01241949
asked Mar 20 '18 at 23:01
GSM BoutiqueGSM Boutique
284
edited 47 mins ago
Teja Bhagavan Kollepara
3,01241949
asked Mar 20 '18 at 23:01
GSM BoutiqueGSM Boutique
284
edited 47 mins ago
Teja Bhagavan Kollepara
3,01241949
edited 47 mins ago
Teja Bhagavan Kollepara
3,01241949
edited 47 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
