Magento – How to increase page view to 500 on Sales Order Grid

gridgrid-serlizationmagento-1.7sales

Mage 1.7.0.2 CE

I am having a problem updating the grid.php to increase the default limit which is currently at 200. I have edited the grid.phtml file to display 500 in the dropdown on the Sales Order Grid but I can't get it to work, it just loads the dashboard of Mage when I click on it.

So I'm pretty sure I need to edit the grid.php here:

/app/code/local/Mage/Adminhtml/Catalog/Product/Grid.php

To allow for an increase in the default limit. However when I add this:

public function __construct()
{
    parent::__construct();
    $this->setDefaultLimit(100);

It breaks Mage with a 500 error.

So I'd like to know what I need to do to override the default limit of 200, so I can increase it to 500. It's important since my employer uses the sales order grid to process orders.

Thanks~

Best Answer

Edit the grid.phtml file located:

.../app/design/adminhtml/default/default/template/widget/grid.phtml

At line 81-87:

<select name="<?php echo $this->getVarNameLimit() ?>” onchange="<?php echo $this->getId() ?>JsObject.loadByElement(this)"> 
  <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> 
</select>

Changing the above to the below for example:

<select name="<?php echo $this->getVarNameLimit() ?>” onchange="<?php echo $this->getId() ?>JsObject.loadByElement(this)"> 
  <option value="200"<?php if($this->getCollection()->getPageSize()==200): ?> selected="selected"<?php endif; ?>>200</option> 
  <option value="300"<?php if($this->getCollection()->getPageSize()==300): ?> selected="selected"<?php endif; ?>>300</option> 
  <option value="500"<?php if($this->getCollection()->getPageSize()==500): ?> selected="selected"<?php endif; ?>>500</option> 
  <option value="1000"<?php if($this->getCollection()->getPageSize()==1000): ?> selected="selected"<?php endif; ?>>1000</option> 
  <option value="2000"<?php if($this->getCollection()->getPageSize()==2000): ?> selected="selected"<?php endif; ?>>2000</option> 
</select>

Hope this helps?

Related Solutions

Magento – Rewrite OR add custom tab to the sales order view in magento

Try

Create: app/code/local/MagePal/OrderFraudDetectionTab/etc/config.xml

<?xml version="1.0"?>
<config>
    <modules>
        <MagePal_OrderFraudDetectionTab>
            <version>1.0.1</version>
        </MagePal_OrderFraudDetectionTab>
    </modules>
    <global>
        <blocks>
            <orderfrauddetectiontab>
                <class>MagePal_OrderFraudDetectionTab_Block</class>
            </orderfrauddetectiontab>
        </blocks>
    </global>       
    <adminhtml>
       <layout>
            <updates>
                <orderfrauddetectiontab>
                    <file>magpal_orderfrauddetectiontab.xml</file>
                </orderfrauddetectiontab>
            </updates>
        </layout>
    </adminhtml>
</config>

Create: app/code/local/MagePal/OrderFraudDetectionTab/Block/Adminhtml/Order/View/Tab/FraudDetection.php

<?php
class MagePal_OrderFraudDetectionTab_Block_Adminhtml_Order_View_Tab_FraudDetection
    extends Mage_Adminhtml_Block_Template
    implements Mage_Adminhtml_Block_Widget_Tab_Interface
{    
    //change _constuct to _construct()
    public function _construct()
    {
        parent::_construct();
        $this->setTemplate('magpal/orderfrauddetectiontab/order/view/tab/frauddetection.phtml');
    }

    public function getTabLabel() {
        return $this->__('Fraud Detection');
    }

    public function getTabTitle() {
        return $this->__('Fraud Detection');
    }

    public function canShowTab() {
        return true;
    }

    public function isHidden() {
        return false;
    }

    public function getOrder(){
        return Mage::registry('current_order');
    }
} 
?>

Create: app/design/adminhtml/default/default/template/magpal/orderfrauddetectiontab/order/view/tab/frauddetection.phtml

<?php echo 'add your html/php code here'; ?>

Create: app/design/adminhtml/default/default/layout/magpal_orderfrauddetectiontab.xml

<?xml version="1.0"?>
<layout>
    <adminhtml_sales_order_view>
        <reference name="sales_order_tabs">
            <action method="addTab">
                <name>order_view_tab_orderfrauddetectiontab</name>
                 <block>orderfrauddetectiontab/adminhtml_order_view_tab_frauddetection</block>
            </action>
        </reference>
</adminhtml_sales_order_view>
</layout>

Create: app/etc/modules/MagePal_OrderFraudDetectionTab.xml

<?xml version="1.0"?>
<config>
     <modules>
        <MagePal_OrderFraudDetectionTab>
            <active>true</active>
            <codePool>local</codePool>
        </MagePal_OrderFraudDetectionTab>
    </modules>
</config>

Magento – magento Add Coupon code at sales order grid

As Magento save coupon code on Sales_flat_Order table so you need to MySQL join with Sales_flat_order table

Add sales_flat_order table to collection.In magento, sales_flat_order and sales_flat_order_grid table related with Flat Grid order table entity_id and sales_flat_order table entity_id.

$select = $collection->getSelect();
$select->joinLeft(array('order' => Mage::getModel('core/resource')->getTableName('sales/order')), 'order.entity_id=main_table.entity_id',
array('coupon_code' => 'coupon_code'))

Rewrite class then add columns to show Coupon:

<?php
/**
* Sales Order Class
*
* @author Amit Bera
*/
class Amit_CustomOrderGrid_Block_Adminhtml_Sales_Order_Grid extends Mage_Adminhtml_Block_Sales_Order_Grid
{

   protected function _prepareColumns()
    {

      $this->addColumn('coupon_code', array(
          'header'    => Mage::helper('sales')->__('Color Name'),
          'align'     =>'left',
          'width'     => '50px',
          'index'     => 'coupon_code',
    'filter_index' => 'order.coupon_code'
    ));


        parent::_prepareColumns();
        return Mage_Adminhtml_Block_Widget_Grid::_prepareColumns();

    }
    protected function _prepareCollection()
    {
        $collection = Mage::getResourceModel($this->_getCollectionClass());
    $collection->getSelect()->joinLeft(array('order' => Mage::getModel('core/resource')->getTableName('sales/order')),
        'order.entity_id=main_table.entity_id',array('coupon_code' => 'coupon_code'))
        $this->setCollection($collection);
       // return parent::_prepareCollection();
       return Mage_Adminhtml_Block_Widget_Grid::_prepareCollection();
    }
}
?>

Best Answer

Related Solutions

Magento – Rewrite OR add custom tab to the sales order view in magento

Magento – magento Add Coupon code at sales order grid

Rewrite class then add columns to show Coupon:

Related Topic