Simple Product to Virtual Product Change?












1















If we have created a simple product in Magento but it was supposed to be a virtual product, is that a simple fix on the back end?



We created a large number of courses that do not require shipping and have no physical product. Would a simple query to correct this and rewrite be possible?










share|improve this question







New contributor




jodelynne is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

























    1















    If we have created a simple product in Magento but it was supposed to be a virtual product, is that a simple fix on the back end?



    We created a large number of courses that do not require shipping and have no physical product. Would a simple query to correct this and rewrite be possible?










    share|improve this question







    New contributor




    jodelynne is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.























      1












      1








      1








      If we have created a simple product in Magento but it was supposed to be a virtual product, is that a simple fix on the back end?



      We created a large number of courses that do not require shipping and have no physical product. Would a simple query to correct this and rewrite be possible?










      share|improve this question







      New contributor




      jodelynne is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.












      If we have created a simple product in Magento but it was supposed to be a virtual product, is that a simple fix on the back end?



      We created a large number of courses that do not require shipping and have no physical product. Would a simple query to correct this and rewrite be possible?







      configurable-product






      share|improve this question







      New contributor




      jodelynne is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.











      share|improve this question







      New contributor




      jodelynne is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      share|improve this question




      share|improve this question






      New contributor




      jodelynne is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked 9 hours ago









      jodelynnejodelynne

      61




      61




      New contributor




      jodelynne is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      jodelynne is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      jodelynne is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






















          2 Answers
          2






          active

          oldest

          votes


















          0














          Not on the backend, Magento wont allow you to change it from backend. Instead,



          Run this command on DB



          UPDATE catalog_product_entity SET type_id='virtual' WHERE entity_id=xxx


          Where xxx is the product id



          Query is same for both Magento 1 and Magento 2






          share|improve this answer

































            0














            Just edit the product in admin and set This item has no weight and save.



            https://nimb.ws/8vm7dc



            It is automatically changed to virtual product.






            share|improve this answer























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


              }
              });






              jodelynne is a new contributor. Be nice, and check out our Code of Conduct.










              draft saved

              draft discarded


















              StackExchange.ready(
              function () {
              StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f261038%2fsimple-product-to-virtual-product-change%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









              0














              Not on the backend, Magento wont allow you to change it from backend. Instead,



              Run this command on DB



              UPDATE catalog_product_entity SET type_id='virtual' WHERE entity_id=xxx


              Where xxx is the product id



              Query is same for both Magento 1 and Magento 2






              share|improve this answer






























                0














                Not on the backend, Magento wont allow you to change it from backend. Instead,



                Run this command on DB



                UPDATE catalog_product_entity SET type_id='virtual' WHERE entity_id=xxx


                Where xxx is the product id



                Query is same for both Magento 1 and Magento 2






                share|improve this answer




























                  0












                  0








                  0







                  Not on the backend, Magento wont allow you to change it from backend. Instead,



                  Run this command on DB



                  UPDATE catalog_product_entity SET type_id='virtual' WHERE entity_id=xxx


                  Where xxx is the product id



                  Query is same for both Magento 1 and Magento 2






                  share|improve this answer















                  Not on the backend, Magento wont allow you to change it from backend. Instead,



                  Run this command on DB



                  UPDATE catalog_product_entity SET type_id='virtual' WHERE entity_id=xxx


                  Where xxx is the product id



                  Query is same for both Magento 1 and Magento 2







                  share|improve this answer














                  share|improve this answer



                  share|improve this answer








                  edited 8 hours ago

























                  answered 8 hours ago









                  Shoaib MunirShoaib Munir

                  436214




                  436214

























                      0














                      Just edit the product in admin and set This item has no weight and save.



                      https://nimb.ws/8vm7dc



                      It is automatically changed to virtual product.






                      share|improve this answer




























                        0














                        Just edit the product in admin and set This item has no weight and save.



                        https://nimb.ws/8vm7dc



                        It is automatically changed to virtual product.






                        share|improve this answer


























                          0












                          0








                          0







                          Just edit the product in admin and set This item has no weight and save.



                          https://nimb.ws/8vm7dc



                          It is automatically changed to virtual product.






                          share|improve this answer













                          Just edit the product in admin and set This item has no weight and save.



                          https://nimb.ws/8vm7dc



                          It is automatically changed to virtual product.







                          share|improve this answer












                          share|improve this answer



                          share|improve this answer










                          answered 8 hours ago









                          Bilal UseanBilal Usean

                          4,61123486




                          4,61123486






















                              jodelynne is a new contributor. Be nice, and check out our Code of Conduct.










                              draft saved

                              draft discarded


















                              jodelynne is a new contributor. Be nice, and check out our Code of Conduct.













                              jodelynne is a new contributor. Be nice, and check out our Code of Conduct.












                              jodelynne is a new contributor. Be nice, and check out our Code of Conduct.
















                              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.




                              draft saved


                              draft discarded














                              StackExchange.ready(
                              function () {
                              StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f261038%2fsimple-product-to-virtual-product-change%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

                              Polycentropodidae

                              Magento 2 Error message: Invalid state change requested

                              Paulmy