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
934112
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
934112
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
934112
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
934112
asked Dec 3 '18 at 9:19
Sunny RahevarSunny Rahevar
934112
asked Dec 3 '18 at 9:19
Sunny RahevarSunny Rahevar
934112
asked Dec 3 '18 at 9:19
Sunny RahevarSunny Rahevar
934112
asked Dec 3 '18 at 9:19
Sunny RahevarSunny Rahevar
934112
934112
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
30919
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 yesterday
Jacco AmersfoortJacco Amersfoort
785717
Thanks for your answer.! I have solved issue. jaimin's answer is working for me.
– Sunny Rahevar
23 hours ago
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
30919
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
30919
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
30919
You need to change in database OR create PHP script to update database value.
answered Dec 3 '18 at 9:29
DivyarajsinhDivyarajsinh
30919
answered Dec 3 '18 at 9:29
DivyarajsinhDivyarajsinh
30919
answered Dec 3 '18 at 9:29
DivyarajsinhDivyarajsinh
30919
answered Dec 3 '18 at 9:29
DivyarajsinhDivyarajsinh
30919
30919
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 yesterday
Jacco AmersfoortJacco Amersfoort
785717
Thanks for your answer.! I have solved issue. jaimin's answer is working for me.
– Sunny Rahevar
23 hours ago
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 yesterday
Jacco AmersfoortJacco Amersfoort
785717
Thanks for your answer.! I have solved issue. jaimin's answer is working for me.
– Sunny Rahevar
23 hours ago
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 yesterday
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 yesterday
Jacco AmersfoortJacco Amersfoort
785717
answered yesterday
Jacco AmersfoortJacco Amersfoort
785717
answered yesterday
Jacco AmersfoortJacco Amersfoort
785717
answered yesterday
Jacco AmersfoortJacco Amersfoort
785717
785717
Thanks for your answer.! I have solved issue. jaimin's answer is working for me.
– Sunny Rahevar
23 hours ago
add a comment |
Thanks for your answer.! I have solved issue. jaimin's answer is working for me.
– Sunny Rahevar
23 hours ago
Thanks for your answer.! I have solved issue. jaimin's answer is working for me.
– Sunny Rahevar
23 hours ago
Thanks for your answer.! I have solved issue. jaimin's answer is working for me.
– Sunny Rahevar
23 hours ago
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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
