I'm trying to get a list of all the products in the store using the product-collections but it doesn't respect the page and page-size params. I'm using the sample data and have 174 products in my store but irrespective of the page number and size supplied when querying the collection:

/** @var Store $store */
$store = $this->_storeManager->getStore(true);
/** @var \Magento\Catalog\Model\ResourceModel\Product\Collection $collection */
$collection = $this->getCollection($store);
$collection = $collection->addAttributeToSelect('*');

$collection = $collection->setCurPage(100);
$collection = $collection->setPageSize(1000);
$collection = $collection->load();


I've tried to output the size of the collection after querying it but the number of results are incorrect.

  • 1
    if you are running this on frontend you have to make sure that all the products are enabled in stock and assigned to the website. Otherwise, you might be reading data from the flat tables which don't contain the disabled products and the ones not associated to the current website.
    – Marius
    Commented Nov 23, 2016 at 21:16

1 Answer 1


Take a look at the definition of getSize (it's in \Magento\Framework\Data\Collection\AbstractDb). You'll see the following:

public function getSize()
    if ($this->_totalRecords === null) {
        $sql = $this->getSelectCountSql();
        $this->_totalRecords = $this->getConnection()->fetchOne($sql, $this->_bindParams);
    return intval($this->_totalRecords);

The method getSelectCountSql does exist in the original class, but if you follow it down:

public function getSelectCountSql()
    return $this->_getSelectCountSql();


protected function _getSelectCountSql($select = null, $resetLeftJoins = true)
    $countSelect = is_null($select) ? $this->_getClearSelect() : $this->_buildClearSelect($select);
    $countSelect->columns('COUNT(DISTINCT e.entity_id)');
    if ($resetLeftJoins) {
    return $countSelect;


protected function _buildClearSelect($select = null)
    if (null === $select) {
        $select = clone $this->getSelect();

    return $select;

You'll see that getSize will always reset the LIMIT and perform a MySQL query to give you the size of the full collection (assuming I didn't miss somewhere that sets _totalRecords outside of that method). Given that you've already loaded the collection, calling count($collection) should result in the right number.

  • That didn't seem to work. Calling count on the collection after I commented out all my other size methods, it still returned the same number of items. Commented Feb 3, 2016 at 14:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.