Magento – Per page items not working in Magento 1.8.1

magento-1.8pagination

The "Per page" items dropdown in my magento website is not working at all. The default value is set to 12 items (list includes 12,24,36) , but loads all products by default. When i select 24, the page loads to the following url

'/accessories?limit=24'

but still loads all the products and no pagination appears. Could someone please point me in the right direction to fix this problem!

EDIT

The "Sort by" field is working. Only the Items per page is not.

Best Answer

I've seen something like that happen when people mix up Grid and List display modes. Basically if your Toolbar shows limits from List and you're trying to display Grid AND your chosen limit is not among Grid available limits, default is used. It happens usually with heavily modified category pages where one or another display method has been removed.

Related Solutions

Magento – Pagination and Sorting not working

Use below snippet to add pagination and sorting on your custom collection. For every custom collection listing you have to create custom toolbar pager as well.

    $itemsLimit         =   $_GET["limit"] ? $_GET["limit"] : Mage::getStoreConfig('catalog/frontend/grid_per_page');   //Set items to show per page
    $currPage               =   $_GET["p"] ? $_GET["p"] : 1;                //Set current page      
   /*   Set Pagination for Custom Loaded Collection */                              
    $toolbar = Mage::getBlockSingleton('catalog/product_list')->getToolbarBlock();
    $toolbar->setCollection($_productCollection);

    /*  Set Pager   */
    $pager = $this->getLayout()->createBlock('page/html_pager', 'custom.pager');
    $pager->setAvailableLimit(array($itemsLimit=>$itemsLimit));
    $pager->setCollection($_productCollection);
    $toolbar->setChild('product_list_toolbar_pager', $pager);
    $toolbar->setData('_current_limit', $itemsLimit);

After this, replace

$this->getToolbarHtml(); by $toolbar->toHtml();

to display bottom pager and top sorting toolbar.

For sorting order, do this before collection load:

$_productCollection->addAttributeToSort($_GET["order"], $_GET["dir"]');

I hope this resolves your problem.

Magento 1 – Fix Limiter Per Page Not Working

Try this

setCurPage() should be current page value

 if($currentCategoryId){
        $order = Mage::getSingleton('catalog/session')->getSortOrder();
        $direction = Mage::getSingleton('catalog/session')->getSortDirection();
        $display = Mage::getSingleton('catalog/session')->getDisplayMode();
        $limit = Mage::getSingleton('catalog/session')->getLimitPage();
        // Default name for page number is p

$currentPage = (int) ($this->getRequest()->getParam('p')) ? $this->getRequest()->getParam('p') : 1;

         if($order == 'name') {
            if($direction == '') {
                $direction = 'asc';
            }                
            $_productCollection = Mage::getModel('catalog/category')->load($currentCategoryId)
                 ->getProductCollection()
                 ->addAttributeToSelect('*')
                 ->addAttributeToFilter('status', 1)
                 ->addAttributeToFilter('visibility', 4)                                          
                 ->setOrder('name', $direction)//;
                 ->setPageSize($limit)
                 ->setCurPage($currentPage);

            //echo $_productCollection->getSelect();
            //$_productCollection->printLogQuery(true);
         }

         if($order == 'price') {
            if($direction == '') {
                $direction = 'asc';
            }
            $_productCollection = Mage::getModel('catalog/category')->load($currentCategoryId)
                 ->getProductCollection()
                 ->addAttributeToSelect('*')
                 ->addAttributeToFilter('status', 1)
                 ->addAttributeToFilter('visibility', 4)
                 ->setOrder('price', $direction)//;
                 ->setPageSize($limit)
                 ->setCurPage($currentPage);
         }

         if($order == 'position') {
            if($direction == '') {
                $direction = 'asc';
            }
            $_productCollection = Mage::getModel('catalog/category')->load($currentCategoryId)
                 ->getProductCollection()
                 ->addAttributeToSelect('*')
                 ->addAttributeToFilter('status', 1)
                 ->addAttributeToFilter('visibility', 4)
                 ->setOrder('position', $direction)//;
                 ->setPageSize($limit)
                 ->setCurPage($currentPage);
         }

         if($order == '') {
            if($direction == '') {
                $direction = 'asc';
            }
            $_productCollection = Mage::getModel('catalog/category')->load($currentCategoryId)
                 ->getProductCollection()
                 ->addAttributeToSelect('*')
                 ->addAttributeToFilter('status', 1)
                 ->addAttributeToFilter('visibility', 4)
                 ->setOrder('news_from_date', 'desc')
                 ->setOrder('created_at', 'desc')//;
                 ->setPageSize($limit)
                 ->setCurPage($currentPage);
        }
    }

Best Answer

Related Solutions

Magento – Pagination and Sorting not working

Magento 1 – Fix Limiter Per Page Not Working

Related Topic