Set Use Default Value for all categories attributes Magento 2
I have around 1260 categories.If i switch the store view , the all attributes have own value.But i want to set the all attribute values as parent main store view value.
I can not open each category and checked the Use Default Value checkbox.
So can you give me any hint how can i checked this checkbox using programmatically or sql Query.
Please see this screenshot.!
magento2 category category-attribute
asked Dec 3 '18 at 9:19
Sunny RahevarSunny Rahevar
936112
add a comment |
I have around 1260 categories.If i switch the store view , the all attributes have own value.But i want to set the all attribute values as parent main store view value.
I can not open each category and checked the Use Default Value checkbox.
So can you give me any hint how can i checked this checkbox using programmatically or sql Query.
Please see this screenshot.!
magento2 category category-attribute
asked Dec 3 '18 at 9:19
Sunny RahevarSunny Rahevar
936112
add a comment |
I have around 1260 categories.If i switch the store view , the all attributes have own value.But i want to set the all attribute values as parent main store view value.
I can not open each category and checked the Use Default Value checkbox.
So can you give me any hint how can i checked this checkbox using programmatically or sql Query.
Please see this screenshot.!
magento2 category category-attribute
asked Dec 3 '18 at 9:19
Sunny RahevarSunny Rahevar
936112
I have around 1260 categories.If i switch the store view , the all attributes have own value.But i want to set the all attribute values as parent main store view value.
I can not open each category and checked the Use Default Value checkbox.
So can you give me any hint how can i checked this checkbox using programmatically or sql Query.
Please see this screenshot.!
magento2 category category-attribute
magento2 category category-attribute
asked Dec 3 '18 at 9:19
Sunny RahevarSunny Rahevar
936112
asked Dec 3 '18 at 9:19
Sunny RahevarSunny Rahevar
936112
asked Dec 3 '18 at 9:19
Sunny RahevarSunny Rahevar
936112
asked Dec 3 '18 at 9:19
Sunny RahevarSunny Rahevar
936112
asked Dec 3 '18 at 9:19
Sunny RahevarSunny Rahevar
936112
936112
add a comment |
add a comment |
3 Answers
3
active
oldest
votes
For categories i ran the following query and it worked.
DELETE FROM `catalog_category_entity_text` where store_id = 1;
DELETE FROM `catalog_category_entity_datetime` where store_id = 1;
DELETE FROM `catalog_category_entity_decimal` where store_id = 1;
DELETE FROM `catalog_category_entity_int` where store_id = 1;
DELETE FROM `catalog_category_entity_varchar` where store_id = 1;
answered Dec 3 '18 at 9:34
JaiminJaimin
1,021428
1
Great!! it works for me. Thanks.. Keep it up bro
– Sunny Rahevar
Dec 3 '18 at 11:15
add a comment |
You need to change in database OR create PHP script to update database value.
answered Dec 3 '18 at 9:29
DivyarajsinhDivyarajsinh
33419
Can you please explain me in brief?
– Sunny Rahevar
Dec 3 '18 at 9:29
Yes, you need to create PHP script for update values for all categories in Database.
– Ronak
Dec 3 '18 at 9:30
add a comment |
I do not see the Use Default checkbox at all! On several platforms running 2.1.16 there is no checkbox to restore the Default values. In the Release notes I can't find anything about it. What Magento version were you running in the screenshot?
answered Jan 7 at 14:25
Jacco AmersfoortJacco Amersfoort
785717
Thanks for your answer.! I have solved issue. jaimin's answer is working for me.
– Sunny Rahevar
Jan 8 at 5:47
add a 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%2f252192%2fset-use-default-value-for-all-categories-attributes-magento-2%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
For categories i ran the following query and it worked.
DELETE FROM `catalog_category_entity_text` where store_id = 1;
DELETE FROM `catalog_category_entity_datetime` where store_id = 1;
DELETE FROM `catalog_category_entity_decimal` where store_id = 1;
DELETE FROM `catalog_category_entity_int` where store_id = 1;
DELETE FROM `catalog_category_entity_varchar` where store_id = 1;
answered Dec 3 '18 at 9:34
JaiminJaimin
1,021428
1
Great!! it works for me. Thanks.. Keep it up bro
– Sunny Rahevar
Dec 3 '18 at 11:15
add a comment |
For categories i ran the following query and it worked.
DELETE FROM `catalog_category_entity_text` where store_id = 1;
DELETE FROM `catalog_category_entity_datetime` where store_id = 1;
DELETE FROM `catalog_category_entity_decimal` where store_id = 1;
DELETE FROM `catalog_category_entity_int` where store_id = 1;
DELETE FROM `catalog_category_entity_varchar` where store_id = 1;
answered Dec 3 '18 at 9:34
JaiminJaimin
1,021428
1
Great!! it works for me. Thanks.. Keep it up bro
– Sunny Rahevar
Dec 3 '18 at 11:15
add a comment |
For categories i ran the following query and it worked.
DELETE FROM `catalog_category_entity_text` where store_id = 1;
DELETE FROM `catalog_category_entity_datetime` where store_id = 1;
DELETE FROM `catalog_category_entity_decimal` where store_id = 1;
DELETE FROM `catalog_category_entity_int` where store_id = 1;
DELETE FROM `catalog_category_entity_varchar` where store_id = 1;
answered Dec 3 '18 at 9:34
JaiminJaimin
1,021428
For categories i ran the following query and it worked.
DELETE FROM `catalog_category_entity_text` where store_id = 1;
DELETE FROM `catalog_category_entity_datetime` where store_id = 1;
DELETE FROM `catalog_category_entity_decimal` where store_id = 1;
DELETE FROM `catalog_category_entity_int` where store_id = 1;
DELETE FROM `catalog_category_entity_varchar` where store_id = 1;
answered Dec 3 '18 at 9:34
JaiminJaimin
1,021428
answered Dec 3 '18 at 9:34
JaiminJaimin
1,021428
answered Dec 3 '18 at 9:34
JaiminJaimin
1,021428
answered Dec 3 '18 at 9:34
JaiminJaimin
1,021428
1,021428
1
Great!! it works for me. Thanks.. Keep it up bro
– Sunny Rahevar
Dec 3 '18 at 11:15
add a comment |
1
Great!! it works for me. Thanks.. Keep it up bro
– Sunny Rahevar
Dec 3 '18 at 11:15
1
1
Great!! it works for me. Thanks.. Keep it up bro
– Sunny Rahevar
Dec 3 '18 at 11:15
Great!! it works for me. Thanks.. Keep it up bro
– Sunny Rahevar
Dec 3 '18 at 11:15
add a comment |
You need to change in database OR create PHP script to update database value.
answered Dec 3 '18 at 9:29
DivyarajsinhDivyarajsinh
33419
Can you please explain me in brief?
– Sunny Rahevar
Dec 3 '18 at 9:29
Yes, you need to create PHP script for update values for all categories in Database.
– Ronak
Dec 3 '18 at 9:30
add a comment |
You need to change in database OR create PHP script to update database value.
answered Dec 3 '18 at 9:29
DivyarajsinhDivyarajsinh
33419
Can you please explain me in brief?
– Sunny Rahevar
Dec 3 '18 at 9:29
Yes, you need to create PHP script for update values for all categories in Database.
– Ronak
Dec 3 '18 at 9:30
add a comment |
You need to change in database OR create PHP script to update database value.
answered Dec 3 '18 at 9:29
DivyarajsinhDivyarajsinh
33419
You need to change in database OR create PHP script to update database value.
answered Dec 3 '18 at 9:29
DivyarajsinhDivyarajsinh
33419
answered Dec 3 '18 at 9:29
DivyarajsinhDivyarajsinh
33419
answered Dec 3 '18 at 9:29
DivyarajsinhDivyarajsinh
33419
answered Dec 3 '18 at 9:29
DivyarajsinhDivyarajsinh
33419
33419
Can you please explain me in brief?
– Sunny Rahevar
Dec 3 '18 at 9:29
Yes, you need to create PHP script for update values for all categories in Database.
– Ronak
Dec 3 '18 at 9:30
add a comment |
Can you please explain me in brief?
– Sunny Rahevar
Dec 3 '18 at 9:29
Yes, you need to create PHP script for update values for all categories in Database.
– Ronak
Dec 3 '18 at 9:30
Can you please explain me in brief?
– Sunny Rahevar
Dec 3 '18 at 9:29
Can you please explain me in brief?
– Sunny Rahevar
Dec 3 '18 at 9:29
Yes, you need to create PHP script for update values for all categories in Database.
– Ronak
Dec 3 '18 at 9:30
Yes, you need to create PHP script for update values for all categories in Database.
– Ronak
Dec 3 '18 at 9:30
add a comment |
I do not see the Use Default checkbox at all! On several platforms running 2.1.16 there is no checkbox to restore the Default values. In the Release notes I can't find anything about it. What Magento version were you running in the screenshot?
answered Jan 7 at 14:25
Jacco AmersfoortJacco Amersfoort
785717
Thanks for your answer.! I have solved issue. jaimin's answer is working for me.
– Sunny Rahevar
Jan 8 at 5:47
add a comment |
I do not see the Use Default checkbox at all! On several platforms running 2.1.16 there is no checkbox to restore the Default values. In the Release notes I can't find anything about it. What Magento version were you running in the screenshot?
answered Jan 7 at 14:25
Jacco AmersfoortJacco Amersfoort
785717
Thanks for your answer.! I have solved issue. jaimin's answer is working for me.
– Sunny Rahevar
Jan 8 at 5:47
add a comment |
I do not see the Use Default checkbox at all! On several platforms running 2.1.16 there is no checkbox to restore the Default values. In the Release notes I can't find anything about it. What Magento version were you running in the screenshot?
answered Jan 7 at 14:25
Jacco AmersfoortJacco Amersfoort
785717
I do not see the Use Default checkbox at all! On several platforms running 2.1.16 there is no checkbox to restore the Default values. In the Release notes I can't find anything about it. What Magento version were you running in the screenshot?
answered Jan 7 at 14:25
Jacco AmersfoortJacco Amersfoort
785717
answered Jan 7 at 14:25
Jacco AmersfoortJacco Amersfoort
785717
answered Jan 7 at 14:25
Jacco AmersfoortJacco Amersfoort
785717
answered Jan 7 at 14:25
Jacco AmersfoortJacco Amersfoort
785717
785717
Thanks for your answer.! I have solved issue. jaimin's answer is working for me.
– Sunny Rahevar
Jan 8 at 5:47
add a comment |
Thanks for your answer.! I have solved issue. jaimin's answer is working for me.
– Sunny Rahevar
Jan 8 at 5:47
Thanks for your answer.! I have solved issue. jaimin's answer is working for me.
– Sunny Rahevar
Jan 8 at 5:47
Thanks for your answer.! I have solved issue. jaimin's answer is working for me.
– Sunny Rahevar
Jan 8 at 5:47
add a 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%2f252192%2fset-use-default-value-for-all-categories-attributes-magento-2%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
