Magento 2: Load store specific product

Question

How can I get store specific products. Mysql query will also work. Can some one help me on this. Thanks.

Answer 1

You can use this

<?php

namespace Vendor\Module\Block;

class Product extends \Magento\Framework\View\Element\Template
{    
    protected $_productCollectionFactory;

    public function __construct(
        \Magento\Backend\Block\Template\Context $context,        
        \Magento\Catalog\Model\ResourceModel\Product\CollectionFactory $productCollectionFactory,        
        array $data = []
    )
    {    
        $this->_productCollectionFactory = $productCollectionFactory;    
        parent::__construct($context, $data);
    }

    public function getProductCollection()
    {
        $storeId = 1; //Store ID
        $collection = $this->_productCollectionFactory->create();
        $collection->addAttributeToSelect('*');
        $collection->addStoreFilter($storeId);        
        return $collection;
    }
}
?>  

change your Store ID.

Hope this will work!

Answer 2

Hope this might will help you.

<?php

namespace Vendor\Module\Block;

class Product extends \Magento\Framework\View\Element\Template
 {    
  protected $productFactory;

public function __construct(
    \Magento\Backend\Block\Template\Context $context,        
    \Magento\Catalog\Model\ProductFactory $productFactory,        
    array $data = []
)
{    
    $this->productFactory = $productFactory;    
    parent::__construct($context, $data);
}

public function getProduct($storeId, $productId) {
    $product = $this->productFactory->create()
                            ->setStoreId($storeId)
                            ->load($productId);
    return $product;
}

public function getProductCollection($storeId)
{
    $productCollection = $this->productFactory->create()
                                ->setStoreId($storeId)
                                ->getCollection()
                                ->addAttributeToSelect('*');
    return $productCollection;
}
}