Set Use Default Value for all categories attributes Magento 2
Clash Royale CLAN TAG#URR8PPP
up vote
7
down vote
favorite
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 at 9:19
Sunny Rahevar
894112
add a comment |
up vote
7
down vote
favorite
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 at 9:19
Sunny Rahevar
894112
add a comment |
up vote
7
down vote
favorite
up vote
7
down vote
favorite
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 at 9:19
Sunny Rahevar
894112
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 at 9:19
Sunny Rahevar
894112
asked Dec 3 at 9:19
Sunny Rahevar
894112
asked Dec 3 at 9:19
Sunny Rahevar
894112
asked Dec 3 at 9:19
Sunny Rahevar
894112
asked Dec 3 at 9:19
Sunny Rahevar
894112
894112
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
up vote
4
down vote
accepted
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 at 9:34
Jaimin
1,019428
1
Great!! it works for me. Thanks.. Keep it up bro
– Sunny Rahevar
Dec 3 at 11:15
add a comment |
up vote
1
down vote
You need to change in database OR create PHP script to update database value.
answered Dec 3 at 9:29
Divyarajsinh
30919
Can you please explain me in brief?
– Sunny Rahevar
Dec 3 at 9:29
Yes, you need to create PHP script for update values for all categories in Database.
– Ronak
Dec 3 at 9:30
add a comment |
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
4
down vote
accepted
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 at 9:34
Jaimin
1,019428
1
Great!! it works for me. Thanks.. Keep it up bro
– Sunny Rahevar
Dec 3 at 11:15
add a comment |
up vote
4
down vote
accepted
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 at 9:34
Jaimin
1,019428
1
Great!! it works for me. Thanks.. Keep it up bro
– Sunny Rahevar
Dec 3 at 11:15
add a comment |
up vote
4
down vote
accepted
up vote
4
down vote
accepted
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 at 9:34
Jaimin
1,019428
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 at 9:34
Jaimin
1,019428
answered Dec 3 at 9:34
Jaimin
1,019428
answered Dec 3 at 9:34
Jaimin
1,019428
answered Dec 3 at 9:34
Jaimin
1,019428
1,019428
1
Great!! it works for me. Thanks.. Keep it up bro
– Sunny Rahevar
Dec 3 at 11:15
add a comment |
1
Great!! it works for me. Thanks.. Keep it up bro
– Sunny Rahevar
Dec 3 at 11:15
1
1
Great!! it works for me. Thanks.. Keep it up bro
– Sunny Rahevar
Dec 3 at 11:15
Great!! it works for me. Thanks.. Keep it up bro
– Sunny Rahevar
Dec 3 at 11:15
add a comment |
up vote
1
down vote
You need to change in database OR create PHP script to update database value.
answered Dec 3 at 9:29
Divyarajsinh
30919
Can you please explain me in brief?
– Sunny Rahevar
Dec 3 at 9:29
Yes, you need to create PHP script for update values for all categories in Database.
– Ronak
Dec 3 at 9:30
add a comment |
up vote
1
down vote
You need to change in database OR create PHP script to update database value.
answered Dec 3 at 9:29
Divyarajsinh
30919
Can you please explain me in brief?
– Sunny Rahevar
Dec 3 at 9:29
Yes, you need to create PHP script for update values for all categories in Database.
– Ronak
Dec 3 at 9:30
add a comment |
up vote
1
down vote
up vote
1
down vote
You need to change in database OR create PHP script to update database value.
answered Dec 3 at 9:29
Divyarajsinh
30919
You need to change in database OR create PHP script to update database value.
answered Dec 3 at 9:29
Divyarajsinh
30919
answered Dec 3 at 9:29
Divyarajsinh
30919
answered Dec 3 at 9:29
Divyarajsinh
30919
answered Dec 3 at 9:29
Divyarajsinh
30919
30919
Can you please explain me in brief?
– Sunny Rahevar
Dec 3 at 9:29
Yes, you need to create PHP script for update values for all categories in Database.
– Ronak
Dec 3 at 9:30
add a comment |
Can you please explain me in brief?
– Sunny Rahevar
Dec 3 at 9:29
Yes, you need to create PHP script for update values for all categories in Database.
– Ronak
Dec 3 at 9:30
Can you please explain me in brief?
– Sunny Rahevar
Dec 3 at 9:29
Can you please explain me in brief?
– Sunny Rahevar
Dec 3 at 9:29
Yes, you need to create PHP script for update values for all categories in Database.
– Ronak
Dec 3 at 9:30
Yes, you need to create PHP script for update values for all categories in Database.
– Ronak
Dec 3 at 9:30
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
