How to get products name and sku and url key using sql query in magento 2?

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP





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







up vote
1
down vote

favorite













How to get products name and sku and url key using sql query in magento 2 ?







magento2 database sql programmatically







share|improve this question





























    up vote
    1
    down vote

    favorite













    How to get products name and sku and url key using sql query in magento 2 ?







    magento2 database sql programmatically







    share|improve this question

























      up vote
      1
      down vote

      favorite









      up vote
      1
      down vote

      favorite












      How to get products name and sku and url key using sql query in magento 2 ?







      magento2 database sql programmatically







      share|improve this question
















      How to get products name and sku and url key using sql query in magento 2 ?







      magento2 database sql programmatically




      magento2 database sql programmatically






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited 1 hour ago

























      asked 1 hour ago









      hitesh balpande

      1508




      1508




















          2 Answers
          2






          active

          oldest

          votes

















          up vote
          2
          down vote



          accepted










          SQL QUERY:



          SELECT nametable.value, 
           nametable.store_id, 
           catalog_product_entity.sku 
          FROM `catalog_product_entity_varchar` AS nametable 
           LEFT JOIN catalog_product_entity 
           ON nametable.entity_id = catalog_product_entity.entity_id 
          WHERE nametable.attribute_id = (SELECT attribute_id 
           FROM `eav_attribute` 
           WHERE `entity_type_id` = 4 
           AND `attribute_code` LIKE 'name')


          As mentioned like Shashank Kumrawat, Sku value is store at catalog_product_entity and name field value store at catalog_product_entity_varchar




          As Magento support multi-store data, So for single SKU, multiple row
          can be exits.catalog_product_entity_varchar have store id field.If you >> want specific store name then just nametable.store_id = StoreId







          share|improve this answer





























            up vote
            1
            down vote













            You can use directly sql queries in magento2 as shown on this link -



            using object manager (not recommended)




            https://webkul.com/blog/magento2-write-custom-mysql-query/




            Without object manager (recommended)




            How to call Direct SQL Queries and join to collection In Magento2




            To get SKU, you need to use table catalog_product_entity



            and to get product name, need to use table catalog_product_entity_varchar






            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',
              convertImagesToLinks: false,
              noModals: false,
              showLowRepImageUploadWarning: true,
              reputationToPostImages: null,
              bindNavPrevention: true,
              postfix: "",
              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%2f248007%2fhow-to-get-products-name-and-sku-and-url-key-using-sql-query-in-magento-2%23new-answer', 'question_page');

              );

              Post as a guest

















              2 Answers
              2






              active

              oldest

              votes








              2 Answers
              2






              active

              oldest

              votes









              active

              oldest

              votes






              active

              oldest

              votes








              up vote
              2
              down vote



              accepted










              SQL QUERY:



              SELECT nametable.value, 
               nametable.store_id, 
               catalog_product_entity.sku 
              FROM `catalog_product_entity_varchar` AS nametable 
               LEFT JOIN catalog_product_entity 
               ON nametable.entity_id = catalog_product_entity.entity_id 
              WHERE nametable.attribute_id = (SELECT attribute_id 
               FROM `eav_attribute` 
               WHERE `entity_type_id` = 4 
               AND `attribute_code` LIKE 'name')


              As mentioned like Shashank Kumrawat, Sku value is store at catalog_product_entity and name field value store at catalog_product_entity_varchar




              As Magento support multi-store data, So for single SKU, multiple row
              can be exits.catalog_product_entity_varchar have store id field.If you >> want specific store name then just nametable.store_id = StoreId







              share|improve this answer


























                up vote
                2
                down vote



                accepted










                SQL QUERY:



                SELECT nametable.value, 
                 nametable.store_id, 
                 catalog_product_entity.sku 
                FROM `catalog_product_entity_varchar` AS nametable 
                 LEFT JOIN catalog_product_entity 
                 ON nametable.entity_id = catalog_product_entity.entity_id 
                WHERE nametable.attribute_id = (SELECT attribute_id 
                 FROM `eav_attribute` 
                 WHERE `entity_type_id` = 4 
                 AND `attribute_code` LIKE 'name')


                As mentioned like Shashank Kumrawat, Sku value is store at catalog_product_entity and name field value store at catalog_product_entity_varchar




                As Magento support multi-store data, So for single SKU, multiple row
                can be exits.catalog_product_entity_varchar have store id field.If you >> want specific store name then just nametable.store_id = StoreId







                share|improve this answer
























                  up vote
                  2
                  down vote



                  accepted







                  up vote
                  2
                  down vote



                  accepted






                  SQL QUERY:



                  SELECT nametable.value, 
                   nametable.store_id, 
                   catalog_product_entity.sku 
                  FROM `catalog_product_entity_varchar` AS nametable 
                   LEFT JOIN catalog_product_entity 
                   ON nametable.entity_id = catalog_product_entity.entity_id 
                  WHERE nametable.attribute_id = (SELECT attribute_id 
                   FROM `eav_attribute` 
                   WHERE `entity_type_id` = 4 
                   AND `attribute_code` LIKE 'name')


                  As mentioned like Shashank Kumrawat, Sku value is store at catalog_product_entity and name field value store at catalog_product_entity_varchar




                  As Magento support multi-store data, So for single SKU, multiple row
                  can be exits.catalog_product_entity_varchar have store id field.If you >> want specific store name then just nametable.store_id = StoreId







                  share|improve this answer














                  SQL QUERY:



                  SELECT nametable.value, 
                   nametable.store_id, 
                   catalog_product_entity.sku 
                  FROM `catalog_product_entity_varchar` AS nametable 
                   LEFT JOIN catalog_product_entity 
                   ON nametable.entity_id = catalog_product_entity.entity_id 
                  WHERE nametable.attribute_id = (SELECT attribute_id 
                   FROM `eav_attribute` 
                   WHERE `entity_type_id` = 4 
                   AND `attribute_code` LIKE 'name')


                  As mentioned like Shashank Kumrawat, Sku value is store at catalog_product_entity and name field value store at catalog_product_entity_varchar




                  As Magento support multi-store data, So for single SKU, multiple row
                  can be exits.catalog_product_entity_varchar have store id field.If you >> want specific store name then just nametable.store_id = StoreId








                  share|improve this answer














                  share|improve this answer



                  share|improve this answer








                  edited 49 mins ago

























                  answered 55 mins ago









                  Amit Bera♦

                  55.3k1368162




                  55.3k1368162






















                      up vote
                      1
                      down vote













                      You can use directly sql queries in magento2 as shown on this link -



                      using object manager (not recommended)




                      https://webkul.com/blog/magento2-write-custom-mysql-query/




                      Without object manager (recommended)




                      How to call Direct SQL Queries and join to collection In Magento2




                      To get SKU, you need to use table catalog_product_entity



                      and to get product name, need to use table catalog_product_entity_varchar






                      share|improve this answer
























                        up vote
                        1
                        down vote













                        You can use directly sql queries in magento2 as shown on this link -



                        using object manager (not recommended)




                        https://webkul.com/blog/magento2-write-custom-mysql-query/




                        Without object manager (recommended)




                        How to call Direct SQL Queries and join to collection In Magento2




                        To get SKU, you need to use table catalog_product_entity



                        and to get product name, need to use table catalog_product_entity_varchar






                        share|improve this answer






















                          up vote
                          1
                          down vote










                          up vote
                          1
                          down vote









                          You can use directly sql queries in magento2 as shown on this link -



                          using object manager (not recommended)




                          https://webkul.com/blog/magento2-write-custom-mysql-query/




                          Without object manager (recommended)




                          How to call Direct SQL Queries and join to collection In Magento2




                          To get SKU, you need to use table catalog_product_entity



                          and to get product name, need to use table catalog_product_entity_varchar






                          share|improve this answer












                          You can use directly sql queries in magento2 as shown on this link -



                          using object manager (not recommended)




                          https://webkul.com/blog/magento2-write-custom-mysql-query/




                          Without object manager (recommended)




                          How to call Direct SQL Queries and join to collection In Magento2




                          To get SKU, you need to use table catalog_product_entity



                          and to get product name, need to use table catalog_product_entity_varchar







                          share|improve this answer












                          share|improve this answer



                          share|improve this answer










                          answered 1 hour ago









                          Shashank Kumrawat

                          1,1441238




                          1,1441238



























                               

                              draft saved


                              draft discarded















































                               


                              draft saved


                              draft discarded














                              StackExchange.ready(
                              function ()
                              StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f248007%2fhow-to-get-products-name-and-sku-and-url-key-using-sql-query-in-magento-2%23new-answer', 'question_page');

                              );

                              Post as a guest
































































                              Comments

                              Post a Comment

                              Popular posts from this blog

                              White Anglo-Saxon Protestant

                              Image
                              White Anglo-Saxon Protestants ( WASPs ) are a social group of wealthy and well-connected white Americans, of Protestant and predominantly British ancestry, who trace their ancestry to the American colonial period. Until at least the 1960s, this group has dominated American society and culture and dominated in the leadership of the Whig and Republican parties. They usually are very well placed in major financial, business, legal and academic institutions and had close to a monopoly of elite society due to intermarriage and nepotism. [1] During the latter half of the twentieth century, outsider ethnic and racial groups grew in influence and WASP dominance weakened. Americans are increasingly criticizing the WASP hegemony and disparaging WASPs as the epitome of "the Establishment". The Random House Unabridged Dictionary (1998) says the term is "Sometimes Disparaging and Offensive". [2] [3] The term WASP is often used as a pejorative to classify their historical dom...
                              Read more

                              BuddyTV

                              BuddyTV Owner David Niu, Andy Liu Created by Various contributors Website www.buddytv.com Launched July 31, 2007 Current status Offline BuddyTV was an entertainment-based website based in Seattle, Washington, which generated content about television programs and sporting events. The website published information about celebrity and related entertainment news through a series of articles, entertainment profiles, actor biographies and user forums. [1] On 31 December 2014, Smart TV manufacturer VIZIO acquired BuddyTV's parent Advanced Media Research Group, Inc., in order to expand content and service offerings. [2] The site was shut down on 22 May 2018. [3] Contents 1 History 2 Business model 3 Impact 4 See also 5 References 6 External links History BuddyTV was co-founded in 2005 by Andy Liu and David Niu. The pair graduated from the University of Pennsylvania with a Master of Business Administration. They sold their previous company, NetConversions, to aQuantive in 2004...
                              Read more

                              Conflict (narrative)

                              Image
                              Conflict in narrative comes in many forms. "Man versus man", such as is depicted here in the battle between King Arthur and Mordred, is particularly common in traditional literature, fairy tales and myths. [1] In works of narrative, conflict is the challenge main characters need to solve to achieve their goals. Traditionally, conflict is a major literary element that creates challenges in a story by adding uncertainty to if the goal would be achieved. A narrative is not limited to a single conflict. While conflicts may not always resolve in narrative, the resolution of a conflict creates closure or fulfillment, which may or may not occur at a story's end. Contents 1 Basic nature 2 Classification 2.1 Man against man 2.2 Man against nature 2.3 Man against self 2.4 Man against society 3 History 4 See also 5 References 6 External links Basic nature Conflict in literature refers to the different drives of the characters or forces involved. Conflict may be internal o...
                              Read more