浏览文章
文章信息
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();