How to get the products for a particular category?

Sandeep_Pandey · January 21, 2016, 11:19am

I have to load product collection from particular category, i have used below code but not worked for me

 $collection = $this->_collection
                ->addMinimalPrice()
                ->addFinalPrice()
                ->addTaxPercents()
                ->addStoreFilter()
                ->addAttributeToSelect('name')
                ->addAttributeToSelect('image')
                ->addAttributeToFilter('price', array('gt' => 0))
                ->addAttributeToFilter('is_saleable', 1, 'left')
                ->addAttributeToSort('created_at', 'desc')
                ->addAttributeToFilter('category_ids',array('finset'=>'7'));

dmitrii_fediuk · January 24, 2016, 6:50am

Use the \Magento\Catalog\Model\Category::getProductCollection() method:

github.com

magento/magento2/blob/43e3fd79/app/code/Magento/Catalog/Model/Category.php#L458-L471


/**
 * Get category products collection
 *
 * @return \Magento\Framework\Data\Collection\AbstractDb
 */
public function getProductCollection()
{
    $collection = $this->_productCollectionFactory->create()->setStoreId(
        $this->getStoreId()
    )->addCategoryFilter(
        $this
    );
    return $collection;
}

Usage examples

github.com

magento/magento2/blob/43e3fd79/app/code/Magento/Catalog/Model/CategoryLinkManagement.php#L75-L92


$category = $this->categoryRepository->get($categoryId);


/** @var \Magento\Catalog\Model\ResourceModel\Product\Collection $products */
$products = $category->getProductCollection();
$products->addFieldToSelect('position');


/** @var \Magento\Catalog\Api\Data\CategoryProductLinkInterface[] $links */
$links = [];


/** @var \Magento\Catalog\Model\Product $product */
foreach ($products->getItems() as $product) {
    /** @var \Magento\Catalog\Api\Data\CategoryProductLinkInterface $link */
    $link = $this->productLinkFactory->create();
    $link->setSku($product->getSku())
        ->setPosition($product->getData('cat_index_position'))
        ->setCategoryId($category->getId());
    $links[] = $link;
}

github.com

magento/magento2/blob/43e3fd79/app/code/Magento/CatalogUrlRewrite/Observer/UrlRewriteHandler.php#L102-L120


public function getCategoryProductsUrlRewrites(Category $category, $storeId, $saveRewriteHistory)
{
    /** @var \Magento\Catalog\Model\ResourceModel\Product\Collection $productCollection */
    $productCollection = $category->getProductCollection()
        ->addAttributeToSelect('name')
        ->addAttributeToSelect('url_key')
        ->addAttributeToSelect('url_path');
    $productUrls = [];
    foreach ($productCollection as $product) {
        if (in_array($product->getId(), $this->isSkippedProduct)) {
            continue;
        }
        $this->isSkippedProduct[] = $product->getId();
        $product->setStoreId($storeId);
        $product->setData('save_rewrites_history', $saveRewriteHistory);
        $productUrls = array_merge($productUrls, $this->productUrlRewriteGenerator->generate($product));
    }
    return $productUrls;
}