浏览文章

文章信息

Magento2 排除无库存状态的产品集合collection|checkout is out of stock product collection|stock_status 14261

示例:

 $collection = $productCollectionFactory->addAttributeToSelect('*')
            ->addStoreFilter($storeId)
            ->addCategoryFilter($category)
            ->addAttributeToFilter('visibility', \Magento\Catalog\Model\Product\Visibility::VISIBILITY_BOTH)
            ->addAttributeToFilter('status', \Magento\Catalog\Model\Product\Attribute\Source\Status::STATUS_ENABLED)
            ->addAttributeToSort('created_at', 'desc')
            ->setCurPage($page)
            ->setPageSize($pageSize)
            ->addMinimalPrice()
            ->addFinalPrice()
            ->joinTable('cataloginventory_stock_item', 'product_id=entity_id', ['stock_status' => 'is_in_stock'])
            ->addAttributeToSelect('stock_status')
            ->addFieldToFilter('stock_status', ['eq' => 1])
            ->load();



原创