Magento – Export CSV file from order grid

csvexportsales-order

I wanna export CSV from sales -> orders grid with only selected lines and not all commands like with the default button.

If there's a solution for that ?

Thank you for advance

Best Answer

So what happens when the order csv is run is the following.

The action Mage_Adminhtml_Sales_OrderController::exportCsvAction is called,
This creates a grid block with $this->getLayout()->createBlock('adminhtml/sales_order_grid');,
This grid is then used to fill the csv in Mage_Adminhtml_Block_Widget_Grid::_exportIterateCollection

What you could do is rewrite the admin controller or make your own controller and then use this in the admin section. Then instead of simply getting a complete sales order grid you can build the grid with the correct collection including the filters selected by the user.

Related Solutions

Magento – Add mass action in order grid to export

Example for extended magento order grid:

Magento 1.9 – How to Remove Columns from Admin Grid Export

Got it, if set is_system true for a column, it will not be exported.So

    $this->addColumn('customer_name', array(
        'header' => Mage::helper('sales')->__('Customer'),
        'index' => 'email_address1',
        'width' => '60',
        'type' => 'text',
        'is_system' => true,
        'filter_index' => 'email_address1'
    ));

    $this->addColumn('customer_name_ordered', array(
        'header' => Mage::helper('sales')->__('Customer'),
        'index' => 'email_address2',
        'column_css_class'=>'no-display',
        'header_css_class'=>'no-display',
        'width' => '60',
        'type' => 'text',
        'filter_index' => 'email_address2'
    ));

Now column with email_address1 will not be exported.

Best Answer

Related Solutions

Magento – Add mass action in order grid to export

Magento 1.9 – How to Remove Columns from Admin Grid Export

Related Topic