Get all simple products of a category including not visible individually products - Magento 2





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







1















I need to get all simple products of a category. By using the following code, I'm getting only products which has visibility of Catalog, Search but not Not Visible Individually products.



$categoryId = 12;
$categoryFactory = $objectManager->create('MagentoCatalogModelCategoryFactory');
$category = $categoryFactory->create()
->load($categoryId)
->getProductCollection()
->addAttributeToSelect('*')
->addAttributeToFilter('type_id', 'simple');


I need all simple products regardless of its visibility. How can I achieve this?










share|improve this question





























    1















    I need to get all simple products of a category. By using the following code, I'm getting only products which has visibility of Catalog, Search but not Not Visible Individually products.



    $categoryId = 12;
    $categoryFactory = $objectManager->create('MagentoCatalogModelCategoryFactory');
    $category = $categoryFactory->create()
    ->load($categoryId)
    ->getProductCollection()
    ->addAttributeToSelect('*')
    ->addAttributeToFilter('type_id', 'simple');


    I need all simple products regardless of its visibility. How can I achieve this?










    share|improve this question

























      1












      1








      1








      I need to get all simple products of a category. By using the following code, I'm getting only products which has visibility of Catalog, Search but not Not Visible Individually products.



      $categoryId = 12;
      $categoryFactory = $objectManager->create('MagentoCatalogModelCategoryFactory');
      $category = $categoryFactory->create()
      ->load($categoryId)
      ->getProductCollection()
      ->addAttributeToSelect('*')
      ->addAttributeToFilter('type_id', 'simple');


      I need all simple products regardless of its visibility. How can I achieve this?










      share|improve this question














      I need to get all simple products of a category. By using the following code, I'm getting only products which has visibility of Catalog, Search but not Not Visible Individually products.



      $categoryId = 12;
      $categoryFactory = $objectManager->create('MagentoCatalogModelCategoryFactory');
      $category = $categoryFactory->create()
      ->load($categoryId)
      ->getProductCollection()
      ->addAttributeToSelect('*')
      ->addAttributeToFilter('type_id', 'simple');


      I need all simple products regardless of its visibility. How can I achieve this?







      magento2 product category collection






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked 14 hours ago









      Vinoth SVinoth S

      598




      598






















          2 Answers
          2






          active

          oldest

          votes


















          0














          ->addAttributeToSelect('*')
          ->addAttributeToFilter('visibility', MagentoCatalogModelProductVisibility::VISIBILITY_BOTH);


          Try this one, may help you






          share|improve this answer
























          • No change in result. Getting on visible products.

            – Vinoth S
            13 hours ago



















          0














          Try This :-



          $categoryId = '12';
          $productCollection = $objectManager->create('MagentoCatalogModelResourceModelProductCollectionFactory');
          $categoryCollection = $objectManager->create('MagentoCatalogModelCategoryFactory');

          $category = $categoryCollection->create()->load($categoryId);
          $collection = $productCollection->create()
          ->addAttributeToSelect('*');
          ->addCategoryFilter($category);
          ->addAttributeToFilter('visibility', array('eq' => array(id1,id2))); //you can pass id as per your requirement


          Reference Link :-



          Get product collection by category id on phtml file magento2






          share|improve this answer


























          • I said I need both "Catalog, Search" and "Not Visible Individually" simple products. But you are applying filter to get only "Catalog, Search" products.

            – Vinoth S
            13 hours ago











          • check updated answer

            – Ronak Rathod
            11 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%2f268962%2fget-all-simple-products-of-a-category-including-not-visible-individually-product%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














          ->addAttributeToSelect('*')
          ->addAttributeToFilter('visibility', MagentoCatalogModelProductVisibility::VISIBILITY_BOTH);


          Try this one, may help you






          share|improve this answer
























          • No change in result. Getting on visible products.

            – Vinoth S
            13 hours ago
















          0














          ->addAttributeToSelect('*')
          ->addAttributeToFilter('visibility', MagentoCatalogModelProductVisibility::VISIBILITY_BOTH);


          Try this one, may help you






          share|improve this answer
























          • No change in result. Getting on visible products.

            – Vinoth S
            13 hours ago














          0












          0








          0







          ->addAttributeToSelect('*')
          ->addAttributeToFilter('visibility', MagentoCatalogModelProductVisibility::VISIBILITY_BOTH);


          Try this one, may help you






          share|improve this answer













          ->addAttributeToSelect('*')
          ->addAttributeToFilter('visibility', MagentoCatalogModelProductVisibility::VISIBILITY_BOTH);


          Try this one, may help you







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered 13 hours ago









          jafar pinjarjafar pinjar

          772414




          772414













          • No change in result. Getting on visible products.

            – Vinoth S
            13 hours ago



















          • No change in result. Getting on visible products.

            – Vinoth S
            13 hours ago

















          No change in result. Getting on visible products.

          – Vinoth S
          13 hours ago





          No change in result. Getting on visible products.

          – Vinoth S
          13 hours ago













          0














          Try This :-



          $categoryId = '12';
          $productCollection = $objectManager->create('MagentoCatalogModelResourceModelProductCollectionFactory');
          $categoryCollection = $objectManager->create('MagentoCatalogModelCategoryFactory');

          $category = $categoryCollection->create()->load($categoryId);
          $collection = $productCollection->create()
          ->addAttributeToSelect('*');
          ->addCategoryFilter($category);
          ->addAttributeToFilter('visibility', array('eq' => array(id1,id2))); //you can pass id as per your requirement


          Reference Link :-



          Get product collection by category id on phtml file magento2






          share|improve this answer


























          • I said I need both "Catalog, Search" and "Not Visible Individually" simple products. But you are applying filter to get only "Catalog, Search" products.

            – Vinoth S
            13 hours ago











          • check updated answer

            – Ronak Rathod
            11 hours ago
















          0














          Try This :-



          $categoryId = '12';
          $productCollection = $objectManager->create('MagentoCatalogModelResourceModelProductCollectionFactory');
          $categoryCollection = $objectManager->create('MagentoCatalogModelCategoryFactory');

          $category = $categoryCollection->create()->load($categoryId);
          $collection = $productCollection->create()
          ->addAttributeToSelect('*');
          ->addCategoryFilter($category);
          ->addAttributeToFilter('visibility', array('eq' => array(id1,id2))); //you can pass id as per your requirement


          Reference Link :-



          Get product collection by category id on phtml file magento2






          share|improve this answer


























          • I said I need both "Catalog, Search" and "Not Visible Individually" simple products. But you are applying filter to get only "Catalog, Search" products.

            – Vinoth S
            13 hours ago











          • check updated answer

            – Ronak Rathod
            11 hours ago














          0












          0








          0







          Try This :-



          $categoryId = '12';
          $productCollection = $objectManager->create('MagentoCatalogModelResourceModelProductCollectionFactory');
          $categoryCollection = $objectManager->create('MagentoCatalogModelCategoryFactory');

          $category = $categoryCollection->create()->load($categoryId);
          $collection = $productCollection->create()
          ->addAttributeToSelect('*');
          ->addCategoryFilter($category);
          ->addAttributeToFilter('visibility', array('eq' => array(id1,id2))); //you can pass id as per your requirement


          Reference Link :-



          Get product collection by category id on phtml file magento2






          share|improve this answer















          Try This :-



          $categoryId = '12';
          $productCollection = $objectManager->create('MagentoCatalogModelResourceModelProductCollectionFactory');
          $categoryCollection = $objectManager->create('MagentoCatalogModelCategoryFactory');

          $category = $categoryCollection->create()->load($categoryId);
          $collection = $productCollection->create()
          ->addAttributeToSelect('*');
          ->addCategoryFilter($category);
          ->addAttributeToFilter('visibility', array('eq' => array(id1,id2))); //you can pass id as per your requirement


          Reference Link :-



          Get product collection by category id on phtml file magento2







          share|improve this answer














          share|improve this answer



          share|improve this answer








          edited 11 hours ago

























          answered 14 hours ago









          Ronak RathodRonak Rathod

          1,097213




          1,097213













          • I said I need both "Catalog, Search" and "Not Visible Individually" simple products. But you are applying filter to get only "Catalog, Search" products.

            – Vinoth S
            13 hours ago











          • check updated answer

            – Ronak Rathod
            11 hours ago



















          • I said I need both "Catalog, Search" and "Not Visible Individually" simple products. But you are applying filter to get only "Catalog, Search" products.

            – Vinoth S
            13 hours ago











          • check updated answer

            – Ronak Rathod
            11 hours ago

















          I said I need both "Catalog, Search" and "Not Visible Individually" simple products. But you are applying filter to get only "Catalog, Search" products.

          – Vinoth S
          13 hours ago





          I said I need both "Catalog, Search" and "Not Visible Individually" simple products. But you are applying filter to get only "Catalog, Search" products.

          – Vinoth S
          13 hours ago













          check updated answer

          – Ronak Rathod
          11 hours ago





          check updated answer

          – Ronak Rathod
          11 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.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f268962%2fget-all-simple-products-of-a-category-including-not-visible-individually-product%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

          What other Star Trek series did the main TNG cast show up in?

          Berlina muro

          Berlina aerponto