Downloads

Downloads

To download support materials, please select your product from the list below. You will automatically be shown all downloads for that product, including extensions, brochures, sales presenters and technotes.

  • 1. Select your section, category and chosen product.
  • 2. Click on the Manual, brochure, sales presenter or technote of your choice.
  • 3. Take careful note of any applicable instructions, especially for extensions.
  • 4. Download the file to your hard drive.
Knowledge Base

Knowledge Base

Increase Number of Records in Magento Admin Grid

Date Created: 21 Apr 2016
Last Updated: 17 Feb 2019

To increase the number of records displayed in the backend grid (used for cases of too many records), we can edit in the template grid.phtml (App/design/adminhtml/default/default/template/widget/grid.phtml. Currently, the maximum number is only 200 records.

 

Solution 1 (recommended)

Step 1: Create a folder: app/design/adminhtml/default/

Step 2: Create the folder template in app/design/adminhtml/default/custom_name

Step 3: Create the folder widget in app/design/adminhtml/default/custom_name/template

Step 4: Copy file grid.phtml from app/design/adminhtml/default/default/template/widget/grid.phtml to app/design/adminhtml/default/custom_name/template/widget

Step 5:  Add the following code right after the code string (line 82 --> line86) of the file grid.phtml

<option value="20"<?php if($this->getCollection()->getPageSize()= =20): ?> selected="selected"<?php endif; ?>>20</option>
<option value="30"<?php if($this->getCollection()->getPageSize()==30): ?> selected="selected"<?php endif; ?>>30</option>
<option value="50"<?php if($this->getCollection()->getPageSize()==50): ?> selected="selected"<?php endif; ?>>50</option>
<option value="100"<?php if($this->getCollection()->getPageSize()==100): ?> selected="selected"<?php endif; ?>>100</option>
<option value="200"<?php if($this->getCollection()->getPageSize()==200): ?> selected="selected"<?php endif; ?>>200</option>
value: ( if display  up to 500 records)
<option value="500"<?php if($this->getCollection()->getPageSize()==500): ?> selected="selected"<?php endif; ?>>500</option>

Step 6: In filelocal.xml (app/etc/local.xml), add the following lines:

<config>
         <stores>
                  <admin>
                               <design>
                                        <theme>
                                                 <default>custom_name</default>
                                        </theme>
                              </design>
                  </admin>
         </stores>
</config>

 --> Now you can check maximum number of records displayed IN backend grid again to see the changes you've made.

 

Solution 2

(not recommended because this way makes some changes in Magento default file so these changes will be lost if we upgrade Magento version)

In file grid.phtml in app/design/adminhtml/default/default/template/widget/grid.phtml, add the following code right after the code string (line 82 --> line 86)

<option value="20"<?php if($this->getCollection()->getPageSize()==20): ?> selected="selected"<?php endif; ?>>20</option>
<option value="30"<?php if($this->getCollection()->getPageSize()==30): ?> selected="selected"<?php endif; ?>>30</option>
<option value="50"<?php if($this->getCollection()->getPageSize()==50): ?> selected="selected"<?php endif; ?>>50</option>
<option value="100"<?php if($this->getCollection()->getPageSize()==100): ?> selected="selected"<?php endif; ?>>100</option>
<option value="200"<?php if($this->getCollection()->getPageSize()==200): ?> selected="selected"<?php endif; ?>>200</option>
value: ( if display up to 500 records )
<option value="500"<?php if($this->getCollection()->getPageSize()==500): ?> selected="selected"<?php endif; ?>>500</option>

 --> Recheck the number of records can be displayed in backend grid

Support Enquiry

Support Enquiry

If you have a question or require technical support for a Magespacex hosting or extensions you have purchased, please fill out the form below and a member of our support team will contact you shortly.

  • * Required Fields

Warranty