Set Use Default Value for all categories attributes Magento 2





.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty{ margin-bottom:0;
}






up vote
6
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.!



enter image description here






magento2 category category-attribute







share|improve this question




























    up vote
    6
    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.!



    enter image description here






    magento2 category category-attribute







    share|improve this question
























      up vote
      6
      down vote

      favorite









      up vote
      6
      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.!



      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 yesterday









      Sunny Rahevar

      874112




      874112






















          2 Answers
          2






          active

          oldest

          votes

















          up vote
          5
          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;





          share|improve this answer

















          • 1




            Great!! it works for me. Thanks.. Keep it up bro
            – Sunny Rahevar
            yesterday


















          up vote
          1
          down vote













          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
            yesterday












          • Yes, you need to create PHP script for update values for all categories in Database.
            – Ronak
            yesterday











          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',
          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

























          2 Answers
          2






          active

          oldest

          votes








          2 Answers
          2






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes








          up vote
          5
          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;





          share|improve this answer

















          • 1




            Great!! it works for me. Thanks.. Keep it up bro
            – Sunny Rahevar
            yesterday















          up vote
          5
          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;





          share|improve this answer

















          • 1




            Great!! it works for me. Thanks.. Keep it up bro
            – Sunny Rahevar
            yesterday













          up vote
          5
          down vote



          accepted







          up vote
          5
          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;





          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 yesterday









          Jaimin

          996428




          996428








          • 1




            Great!! it works for me. Thanks.. Keep it up bro
            – Sunny Rahevar
            yesterday














          • 1




            Great!! it works for me. Thanks.. Keep it up bro
            – Sunny Rahevar
            yesterday








          1




          1




          Great!! it works for me. Thanks.. Keep it up bro
          – Sunny Rahevar
          yesterday




          Great!! it works for me. Thanks.. Keep it up bro
          – Sunny Rahevar
          yesterday












          up vote
          1
          down vote













          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
            yesterday












          • Yes, you need to create PHP script for update values for all categories in Database.
            – Ronak
            yesterday















          up vote
          1
          down vote













          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
            yesterday












          • Yes, you need to create PHP script for update values for all categories in Database.
            – Ronak
            yesterday













          up vote
          1
          down vote










          up vote
          1
          down vote









          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 yesterday









          Divyarajsinh

          30918




          30918












          • Can you please explain me in brief?
            – Sunny Rahevar
            yesterday












          • Yes, you need to create PHP script for update values for all categories in Database.
            – Ronak
            yesterday


















          • Can you please explain me in brief?
            – Sunny Rahevar
            yesterday












          • Yes, you need to create PHP script for update values for all categories in Database.
            – Ronak
            yesterday
















          Can you please explain me in brief?
          – Sunny Rahevar
          yesterday






          Can you please explain me in brief?
          – Sunny Rahevar
          yesterday














          Yes, you need to create PHP script for update values for all categories in Database.
          – Ronak
          yesterday




          Yes, you need to create PHP script for update values for all categories in Database.
          – Ronak
          yesterday


















          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

          List directoties down one level, excluding some named directories and files

          Image
          1 I want to send a list of all folders including one level down to a txt file. Excluding some named folders and no files. Imagine a folder structure like this. CAPS are folders. FOLDER 1 .hidden TEMP somefile ========= ========= FOLDER 2 .hidden TEMP DATA1 DATA2 somefile ======== ======== FOLDER 3 .hidden TEMP DATA1 somefile I would like to run "insert magic command here" and end up with an output that looks like below FOLDER 1 FOLDER 2 DATA1 DATA2 FOLDER 3 DATA1 bash shell-script share | improve this question edited Dec 16 at 4:15 Rui F Ribeiro ...
          Read more

          list processes belonging to a network namespace

          Image
          5 1 I am on Ubuntu 12.04, and the ip utility does not have ip netns identify <pid> option, I tried installing new iproute , but still, the option identify doesn't seem to be working!. If I were to write a script (or code) to list all processes in a network-namespace, or given a PID, show which network-namespace it belongs to, how should I proceed ? (I need info on a handful of processes, to check if they are in the right netns ) linux process network-namespaces share | improve this question edited Jun 30 '15 at 22:00 Gilles 529k 128 1060 1585 ...
          Read more

          list systemd RuntimeDirectory mounts

          Image
          3 I have a systemd service with this declaration: RuntimeDirectory=plex RuntimeDirectoryMode=750 which creates the in memory directory /run/plex . How would I list the capabilities of this mount point as I would do with mount -l ? systemd systemd-mount share | improve this question edited Jan 9 at 17:57 filbranden 7,400 2 8 37 asked Jan 9 at 17:40 adrhc adrhc 247 1 11 ...
          Read more