Set Use Default Value for all categories attributes Magento 2












7














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.!



enter image description here






magento2 category category-attribute







share|improve this question



























    7














    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.!



    enter image description here






    magento2 category category-attribute







    share|improve this question

























      7












      7








      7







      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.!



      enter image description here






      magento2 category category-attribute







      share|improve this question













      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.!



      enter image description here






      magento2 category category-attribute




      magento2 category category-attribute






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Dec 3 '18 at 9:19









      Sunny RahevarSunny Rahevar

      934112




      934112






















          3 Answers
          3






          active

          oldest

          votes


















          4














          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;





          share|improve this answer

















          • 1




            Great!! it works for me. Thanks.. Keep it up bro
            – Sunny Rahevar
            Dec 3 '18 at 11:15



















          1














          You need to change in database OR create PHP script to update database value.






          share|improve this answer





















          • 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



















          0














          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?






          share|improve this answer





















          • Thanks for your answer.! I have solved issue. jaimin's answer is working for me.
            – Sunny Rahevar
            23 hours ago











          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
          });


          }
          });














          draft saved

          draft discarded


















          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









          4














          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;





          share|improve this answer

















          • 1




            Great!! it works for me. Thanks.. Keep it up bro
            – Sunny Rahevar
            Dec 3 '18 at 11:15
















          4














          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;





          share|improve this answer

















          • 1




            Great!! it works for me. Thanks.. Keep it up bro
            – Sunny Rahevar
            Dec 3 '18 at 11:15














          4












          4








          4






          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;





          share|improve this answer












          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;






          share|improve this answer












          share|improve this answer



          share|improve this answer










          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














          • 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













          1














          You need to change in database OR create PHP script to update database value.






          share|improve this answer





















          • 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
















          1














          You need to change in database OR create PHP script to update database value.






          share|improve this answer





















          • 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














          1












          1








          1






          You need to change in database OR create PHP script to update database value.






          share|improve this answer












          You need to change in database OR create PHP script to update database value.







          share|improve this answer












          share|improve this answer



          share|improve this answer










          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


















          • 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











          0














          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?






          share|improve this answer





















          • Thanks for your answer.! I have solved issue. jaimin's answer is working for me.
            – Sunny Rahevar
            23 hours ago
















          0














          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?






          share|improve this answer





















          • Thanks for your answer.! I have solved issue. jaimin's answer is working for me.
            – Sunny Rahevar
            23 hours ago














          0












          0








          0






          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?






          share|improve this answer












          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?







          share|improve this answer












          share|improve this answer



          share|improve this answer










          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


















          • 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


















          draft saved

          draft discarded




















































          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.




          draft saved


          draft discarded














          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





















































          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







          -

          Popular posts from this blog

          An IMO inspired problem

          Image
          14 4 This problem from IMO 1988 is said to be one of the most elegant ones in functional equations. Problem : The function $f$ is defined on the set of all positive integers as follows: begin{align} f(1) = 1, f(3) &= 3, f(2n) = f(n), \ f(4n+1) &= 2f(2n+1) - f(n), \ f(4n+3) &= 3 f(2n+1) - 2f(n) end{align} Find the number of $n$ with $f(n) = n, 1 leq n leq 1988$. The main idea towards the solution is realizing that these conditions stand for the fact that $f(n)$ just reverses the digits in the binary representation of the number $n$. So, essentially the solution is finding the number of binary pallindromes $leq 1988_{10}$. My question is the following : How to reformulate the problem so that $f(n)$ reverses the digits of $n$ in its ternary representation. Or even better, can we reformulate it for a
          Read more

          Management

          Image
          Management From Wikipedia, the free encyclopedia Jump to navigation Jump to search "Manager" redirects here. For other uses, see Management (disambiguation) and Manager (disambiguation). An organization chart for the United States Coast Guard shows the hierarchy of managerial roles in that organization. Business administration Management of a business Accounting Management accounting Financial accounting Financial audit Business entities Cooperative Corporation Limited liability company Partnership Sole proprietorship State-owned enterprise Corporate governance Annual general meeting Board of directors Supervisory board Advisory board Audit committee Corporate law Commercial law Constitutional documents Contract Corporate crime Corporate liability Insolvency law International trade law Mergers and acquisitions Economics Commodity Pu
          Read more

          Has there ever been an instance of an active nuclear power plant within or near a war zone?

          Image
          36 3 The question Has there ever been a military combat going on around an active (running or in outage but not decommissioned) commercial nuclear power plant? Or dangerously near it? If yes, how did the plant and its personnel fare in such situation? Why I ask Let's assume for the scope of this question modern commercial nuclear power plants (CANDU, PWR, BWR of generation II plus all of gen III and newer) are usually reasonably safe to operate given that the engineering has been done right and there is a whole cohort of very well trained personnel on-site at all times, well rested and with considerable resources on their hands. Things hard to get with an armed conflict like the recent Syrian war raging around. I can't seem to find any reference or a comprehensive article about this, hence this question.
          Read more