How to show more than 5 items in Recently Viewed Products in Magento

How to show more than 5 items in Recently Viewed Products in Magento

July 20, 2026 · Illustrated author avatarBy Stefan Bogdanescu
How to show more than 5 items in Recently Viewed Products in Magento

Increasing the Limit of Recently Viewed Products in Magento

As an experienced e-commerce developer, I often encounter questions about customizing the default behavior of Magento. One common issue is adjusting the limit for recently viewed products, which by default only shows the last five items.

Understanding the Default Behavior

The Recently Viewed Products feature is handled by a standard template located at template/reports/product_viewed.phtml. The function responsible for fetching these products is $this->getRecentlyViewedProducts().

By default, this function uses a limit of 5 to retrieve only the most recent items. This is a useful setting in many cases, but you might want to increase this number depending on your store’s specific requirements.

How to Increase the Limit

To show more than five recently viewed products, we need to modify the code that retrieves these items. Here’s a step-by-step guide:

  1. First, navigate to the app/code/core/Mage/Reports/Model/Product/Viewed.php file in your Magento installation directory.

  2. Locate the function getRecentlyViewedProducts(). It should look something like this:

public function getRecentlyViewedProducts()
{
    $adapter = $this->_getReadAdapter();
    $select = $adapter->select()->from(array('pv' => $this->getMainTable()))
        ->join(
            array('c' => 'catalog_product_entity'),
            'pv.product_id = c.entity_id',
            array('name', 'image')
        )->where('pv.customer_id = ?', (int)$customerId)
        ->limit(5);
    return $adapter->fetchAll($select);
}
  1. To increase the limit, simply change the limit() method call at the end of the query. For example, to show the last seven products:
public function getRecentlyViewedProducts()
{
    // ... (the rest of your code)

    ->limit(7);  // Change this line

    return $adapter->fetchAll($select);
}

Best Practices for Adjusting Limits

While it’s possible to increase the limit like this, you should be cautious about setting it too high. Showing a very large number of recently viewed products can make your site slower and less user-friendly.

A more sustainable approach is to consider using a caching mechanism to store these items in memory or on disk between requests. This way, you can show as many items as you like without significantly impacting performance.

For detailed guidance on implementing caching in Magento, I recommend checking out our article Improving Magento Performance with Advanced Caching Techniques.

Conclusion

Increasing the limit of recently viewed products is a straightforward process that involves modifying a single line of code. However, it’s important to do this judiciously and consider alternative solutions like caching for optimal results.

Remember, your goal should always be to provide a fast, efficient user experience while customizing Magento’s default features according to your business needs.

Catalog Database Themes Configuration

Our network