Magento - Load Product Collection with Pagination

Magento - Load Product Collection with Pagination

September 22, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento - Load Product Collection with Pagination

Magento: Loading Product Collection with Pagination

In Magento, loading a product collection while applying custom filters can sometimes lead to pagination issues. Let’s dive into your specific scenario and find a solution.

Understanding the Core Issue

The main problem lies in how you’re filtering the product collection based on review IDs before passing it through the list.phtml template. By directly calling $_productCollection->load(), you’re bypassing Magento’s built-in pagination logic, which is why you’re experiencing breaking issues.

The Current Approach: What Went Wrong

Your current code snippet starts by retrieving all reviews from a specific store and then extracting their IDs into an array:

$reviewCollection = Mage::getModel('review/review')->getCollection()
    ->addStoreFilter(Mage::app()->getStore()->getId())
    ->addRateVotes()
    ->setDateOrder();

$reviewArray = array();
foreach ($reviewCollection->getItems() as $thisReview):
    array_push($reviewArray, $thisReview->getEntityPkValue());
endforeach;

Next, you’re filtering the product collection based on these review IDs and selecting all attributes:

$_productCollection = Mage::getModel('catalog/product')->getCollection()
    ->addAttributeToFilter('entity_id', array('in' => $reviewArray))
    ->addAttributeToSelect('*')
    ->setPageSize(5);

$_productCollection->load();

However, when you directly call $_productCollection->load(), Magento’s pagination system doesn’t get the chance to process the collection properly. This leads to your observed pagination breakage.

The Ideal Solution: Respecting Magento’s Pagination

To resolve this issue while keeping your custom filtering intact, I recommend using a different approach:

  1. Create a custom block with the filtered collection: Instead of calling getCollection() directly in your template, create a new block that returns the filtered collection.
class Your_Module_Block_Yourblock extends Mage_Core_Block_Template
{
    public function getProductCollection()
    {
        $reviewCollection = Mage::getModel('review/review')->getCollection()
            ->addStoreFilter(Mage::app()->getStore()->getId())
            ->addRateVotes()
            ->setDateOrder();

        $reviewArray = array();
        foreach ($reviewCollection->getItems() as $thisReview):
            array_push($reviewArray, $thisReview->getEntityPkValue());
        endforeach;

        return Mage::getModel('catalog/product')->getCollection()
            ->addAttributeToFilter('entity_id', array('in' => $reviewArray))
            ->addAttributeToSelect('*');
    }
}
  1. Include the custom block in your layout XML: Update your layout to include this new block.
<block type="your_module/yourblock" name="your_block" template="reviewsList/index.phtml"/>
  1. Use Magento’s built-in pagination in your template: In your index.phtml file, use Magento’s built-in pagination helper to display the paginated product list:
<?php $_productCollection = $this->getProductCollection(); ?>
<?php echo $_helper->paginate($_productCollection) ?>

<?php foreach ($_productCollection as $_product): ?>
    <!-- Your product rendering logic here -->
<?php endforeach; ?>

Conclusion

By following this approach, you ensure that Magento’s pagination system remains intact while still filtering your products based on review IDs. This method respects the core functionality of Magento and maintains a clean separation between business logic (in the block) and presentation logic (in the template).

Remember to replace Your_Module with your actual module name in the block class.

For more advanced techniques in customizing Magento’s product listings, consider exploring our guide on extending the catalog listing and working with product collections effectively.

Happy coding!

Catalog Themes Orders Errors

Our network