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

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('Magento\Catalog\Model\CategoryFactory');
$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?

Answer 1

Try This :-

Visibility Ids

VISIBILITY_NOT_VISIBLE = 1;

VISIBILITY_IN_CATALOG = 2;

VISIBILITY_IN_SEARCH = 3;

VISIBILITY_BOTH = 4;

$categoryId = '12';
$productCollection = $objectManager->create('\Magento\Catalog\Model\ResourceModel\Product\CollectionFactory');
$categoryCollection = $objectManager->create('\Magento\Catalog\Model\CategoryFactory');

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

Answer 2

->addAttributeToSelect('*')
->addAttributeToFilter('visibility', \Magento\Catalog\Model\Product\Visibility::VISIBILITY_BOTH);

Try this one, may help you