Sales Order Grid is not working when filtering using any field in magento admin

Hello Friends, I know that many developers face this issue when they adding any new custom field to sales order grid. I have also suffered with this issue and i found the solution for that. Please read the following step to fix this issue.

1. Go to app/code/core/Mage/Adminhtml/Block/Sales/Order/Grid.php

2. Add the following code to the field which causes the issue.
'filter_index'=>'main_table.increment_id',

3. Save that file.

Note: This is example for only one field if you suffer with the same issue with many fields then you have to add this code as per the field index name.
Pritesh Pritesh

Pritesh Pethani

Request a Quote!!

Share your concept and we will return to you within 24 hours. Let us work out the best software solution for you!

Let's Start
Whatspp