Databases
StackOverflow2013
Postsdbo
POHow to add a column for example customer group id in Magento's Admin Order Grid
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to add a column for example customer group id in Magento's Admin Order Grid
    primarykey
    data
    text
    <p>I want an additional column in the Order(s) Grid for Admin. Assuming its Customer Group Id.</p> <p>My app/etc/modules/MyProject_Adminhtml looks like:</p> <pre><code>&lt;?xml version="1.0"?&gt; &lt;config&gt; &lt;modules&gt; &lt;MyProject_Adminhtml&gt; &lt;active&gt;true&lt;/active&gt; &lt;codePool&gt;local&lt;/codePool&gt; &lt;depends&gt; &lt;Mage_Sales /&gt; &lt;/depends&gt; &lt;/MyProject_Adminhtml&gt; &lt;/modules&gt; &lt;/config&gt; </code></pre> <p>My app/code/local/MyProject/Adminhtml/etc/config.xml looks like:</p> <pre><code>&lt;?xml version="1.0"?&gt; &lt;config&gt; &lt;modules&gt; &lt;MyProject_Adminhtml&gt; &lt;version&gt;1.0.0&lt;/version&gt; &lt;/MyProject_Adminhtml&gt; &lt;/modules&gt; &lt;global&gt; &lt;blocks&gt; &lt;adminhtml&gt; &lt;rewrite&gt; &lt;sales_order_grid&gt;MyProject_Adminhtml_Block_Sales_Order_Grid&lt;/sales_order_grid&gt; &lt;/rewrite&gt; &lt;/adminhtml&gt; &lt;/blocks&gt; &lt;/global&gt; &lt;/config&gt; </code></pre> <p>And in app/code/local/MyProject/Adminhtml/Block/Sales/Order/Grid.php I have overridden Mage_Adminhtml_Block_Sales_Order_Grid</p> <pre><code>class MyProject_Adminhtml_Block_Sales_Order_Grid extends Mage_Adminhtml_Block_Sales_Order_Grid { protected function _prepareColumns() { .... unchanged code from Mage_Adminhtml_Block_Sales_Order_Grid::_prepareColumns ... $this-&gt;addColumn('customer_group_id', array( 'header' =&gt; Mage::helper('sales')-&gt;__('Customer Group Id'), 'index' =&gt; 'customer_group_id', 'type' =&gt; 'text', )); .... unchanged code from Mage_Adminhtml_Block_Sales_Order_Grid::_prepareColumns ... } } </code></pre> <p>Is there something I am missing because I don't see anything in Order Grid. I am using Magento 1.4.1.1</p> <p>On Anda B's comment I wrote the following line:</p> <pre><code>var_dump($this-&gt;getLayout()-&gt;createBlock('MyProject_Adminhtml_Block_Sales_Order_Grid')); </code></pre> <p>in app/code/core/Mage/Adminhtml/controllers/Sales/Order/CreateController.php </p> <p>Then, I selected 'Create New Order' and Cancel the order to see the result of execution of var_dump, and I see the following: </p> <pre><code>/var/www/magento/var/report/72990635: line 10: syntax error near unexpected token `}' /var/www/magento/var/report/72990635: line 10: `#9 {main}";s:3:"url";s:80:"/index.php/admin/sales_order_create/cancel/key/0624033594dd63d9e145fc538f4c6bbb/";s:11:"script_name";s:10:"/index.php";s:4:"skin";s:5:"admin";}' </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USOzair Kafray
    1. USOzair Kafray
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COdoes that field exist on the order object or do you need to add it?
      singulars
      1. POHow to add a column for example customer group id in Magento's Admin Order Grid
      1. USJonathan Day
    2. COI had not looked for that earlier, and right now when I looked at app/code/core/Mage/Sales/Model/Order.php I couldn't find it. However my perception has been that if a field existed in DB table sales_flat_order, it would appear here. And it does exist there.
      singulars
      1. POHow to add a column for example customer group id in Magento's Admin Order Grid
      1. USOzair Kafray
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload