Creating Order Item Grid in Magento

Creating Order Item Grid in Magento

By : Brenden Polkinghorn
Date : November 24 2020, 03:41 PM
this one helps. You should get the sales/order_item_collection and then join the sales/order table instead.
Your problem is that you are displaying order information per item on the order. Instead you should be getting the item information specifically and blending some order info in with a join.
code :

Share : facebook icon twitter icon
Magento - How to add Ship to information to order grid in Magento

Magento - How to add Ship to information to order grid in Magento

By : Soumyashree Jena
Date : March 29 2020, 07:55 AM
wish help you to fix your issue Revised Answer (Due to two problematic errors)
I'm rewriting this answer in a more friendly, step by step way to hopefully help someone else out.
code :
protected function _getCollectionClass()
    return 'sales/order_grid_collection';
protected function _getCollectionClass()
    //return 'sales/order_grid_collection';
    return 'sales/order_collection';
$collection->getSelect()->columns(new Zend_Db_Expr("CONCAT(s2.firstname, ' ',s2.lastname) AS billing_name"));
    $collection->getSelect()->columns(new Zend_Db_Expr("CONCAT(s1.firstname, ' ',s1.lastname) AS shipping_name"));
 protected function _prepareCollection()
    $collection = Mage::getResourceModel($this->_getCollectionClass());

    $collection->getSelect()->joinLeft(array('sfog' => 'sales_flat_order_grid'),'main_table.entity_id = sfog.entity_id',array('sfog.shipping_name','sfog.billing_name'));
    $collection->getSelect()->joinLeft(array('sfoa'=>'sales_flat_order_address'),'main_table.entity_id = sfoa.parent_id AND sfoa.address_type="shipping"',array('sfoa.street','sfoa.city','sfoa.region','sfoa.postcode','sfoa.telephone'));


    return parent::_prepareCollection();
$this->addColumn('billing_name', array(
        'header' => Mage::helper('sales')->__('Bill to Name'),
        'index' => 'billing_name',
        'filter_index' => 'sfog.billing_name',
$this->addColumn('customer_email', array(
            'header' => Mage::helper('sales')->__('Customer Email'),
            'index' => 'customer_email',
            'filter_index' => 'sfo.customer_email',
            'width' => '50px',
Magento pull product attributes into Adminhtml order item grid

Magento pull product attributes into Adminhtml order item grid

By : shaoheng
Date : March 29 2020, 07:55 AM
seems to work fine I'm creating a custom module for a specific function in the admin of Magento. Within the Adminhtml grid, I am pulling in line order items, but also need to pull in data specific to each product as it currently stands in the database. , You're going to have to figure out the tables to use in the join.
code :
$collection->getSelect()->join('sales_flat_order_item', '`sales_flat_order_item`.order_id=`main_table`.entity_id AND `sales_flat_order_item`.parent_item_id IS NULL  ', null);

$collection->getSelect()->join('catalog_product_entity_varchar', '`catalog_product_entity_varchar`.attribute_id=144 AND `catalog_product_entity_varchar`.entity_id = `sales_flat_order_item`.`product_id`', array('models'  => new Zend_Db_Expr('group_concat(`catalog_product_entity_varchar`.value SEPARATOR ",")')))
Magento - Add zip code / postcode to the order grid in Magento 1.6.2

Magento - Add zip code / postcode to the order grid in Magento 1.6.2

By : Paulinho Senna
Date : March 29 2020, 07:55 AM
Does that help I am trying to get the order grid to display the postcode/ zip code of the of the customer. , Before return parent::_prepareCollection(); You should create a join:
code :
    'main_table.entity_id = billing.parent_id AND billing.address_type="billing"',array('billing.postcode AS bp'));
    'main_table.entity_id = shipping.parent_id AND shipping.address_type="shipping"',array('shipping.postcode AS sp'));
$this->addColumn('bp', array(
        'header' => Mage::helper('sales')->__('Billing Postcode'),
        'index' => 'bp',
        'width' => '60px',
        'filter_index'  => 'billing.postcode'
How to edit and update the Item Status of an Order Item in an order in magento

How to edit and update the Item Status of an Order Item in an order in magento

By : user3301013
Date : March 29 2020, 07:55 AM
will help you Order item don't have a separate field - status. To understand how to determine status you can see method Mage_Sales_Model_Order_Item :: getStatusId
code :
 * Retrieve item status identifier
 * @return int
public function getStatusId()
    $backordered = (float)$this->getQtyBackordered();
    if (!$backordered && $this->getHasChildren()) {
        $backordered = (float)$this->_getQtyChildrenBackordered();
    $canceled    = (float)$this->getQtyCanceled();
    $invoiced    = (float)$this->getQtyInvoiced();
    $ordered     = (float)$this->getQtyOrdered();
    $refunded    = (float)$this->getQtyRefunded();
    $shipped     = (float)$this->getQtyShipped();

    $actuallyOrdered = $ordered - $canceled - $refunded;

    if (!$invoiced && !$shipped && !$refunded && !$canceled && !$backordered) {
        return self::STATUS_PENDING;
    if ($shipped && $invoiced && ($actuallyOrdered == $shipped)) {
        return self::STATUS_SHIPPED;

    if ($invoiced && !$shipped && ($actuallyOrdered == $invoiced)) {
        return self::STATUS_INVOICED;

    if ($backordered && ($actuallyOrdered == $backordered) ) {
        return self::STATUS_BACKORDERED;

    if ($refunded && $ordered == $refunded) {
        return self::STATUS_REFUNDED;

    if ($canceled && $ordered == $canceled) {
        return self::STATUS_CANCELED;

    if (max($shipped, $invoiced) < $actuallyOrdered) {
        return self::STATUS_PARTIAL;

    return self::STATUS_MIXED;
 * Retrieve order item statuses array
 * @return array
public static function getStatuses()
    if (is_null(self::$_statuses)) {
        self::$_statuses = array(
            //self::STATUS_PENDING        => Mage::helper('sales')->__('Pending'),
            self::STATUS_PENDING        => Mage::helper('sales')->__('Ordered'),
            self::STATUS_SHIPPED        => Mage::helper('sales')->__('Shipped'),
            self::STATUS_INVOICED       => Mage::helper('sales')->__('Invoiced'),
            self::STATUS_BACKORDERED    => Mage::helper('sales')->__('Backordered'),
            self::STATUS_RETURNED       => Mage::helper('sales')->__('Returned'),
            self::STATUS_REFUNDED       => Mage::helper('sales')->__('Refunded'),
            self::STATUS_CANCELED       => Mage::helper('sales')->__('Canceled'),
            self::STATUS_PARTIAL        => Mage::helper('sales')->__('Partial'),
            self::STATUS_MIXED          => Mage::helper('sales')->__('Mixed'),
    return self::$_statuses;
Adding order item to orders grid in Magento

Adding order item to orders grid in Magento

By : Vikas Sangal
Date : March 29 2020, 07:55 AM
this one helps. I am trying to add products ordered to the orders grid in admin using the Grid.php.
Related Posts Related Posts :
  • What could be causing my WhatsApp Stickers Pack not to work?
  • How Can I Reorder/Sort The Collections List in Directus?
  • Is this language generic/mighty enough to be used for a generic game AI?
  • graphite, use regular expressions to select the target, or an alternative
  • subtract functions with type real in ml
  • how to filter '(' in navision 2013
  • sending sms from a mobile browser
  • NuGet behind firewall
  • Gstreamer hangs while generating timelapse from JPEGs on Raspberry pi
  • How to retrieve total view count of large number of pages combined from the GA API
  • Websites rich with exercices or explanation for SML?
  • Is there a TempData equivalent in ServiceStack?
  • scipy-0.12.0 failing to install on mountain lion using python setup.py install
  • Looking for simplest option to render Razor cshtml pages in a console application without any web server
  • Evaluating variables at a specific time in Modelica
  • When I run the Application, only "web" engine is running in GlassFish. "webservices" is not started
  • How To Set MIME Type Of Google Drive File
  • Remove Missing Values in Weka
  • Reloading a UICollectionView using reloadData method returns immediately before reloading data
  • carrot2 - can I cluster documents from a folder?
  • StreamSocket has no Close Implementation in C#
  • Rails, Foundation 4, Respond.js not working properly in IE8
  • How can i create imagesurface from cairo xlib's Graphics Context using cairo and x11 Api's?
  • CKEditor "overflow: scroll" on parent causes toolbar to freeze at initial position
  • Differences between components and controls in ENYO
  • Photoshop making isometric?
  • Does Intel IPP 8.0 support in-place operations?
  • What is Object dictionary in CANOpen?
  • Example of orbBasic Indexed User Variables
  • convert to ABSOLUTE in logback
  • How to conditionally download file using p:fileDownload
  • Error on pod install
  • Set HTTP GET Parameters in Finagle
  • different attack that uses sql injection
  • How can I change my xampp username not as 'root'
  • AMQP Content header payload structure
  • Apache POI formula evaluation not working for Excel IF
  • How can I trace RESTEasy's dispatch?
  • Map Freezes on iOS 7 with Google Maps SDK 1.4
  • Comparing lists, is the subset list within the first list
  • Non-ascii character highlight in Sublime Text 2
  • Installing Magit in Aquamacs
  • Receiving error - System.Net.Mail.SmtpException: 4.3.2 try again later
  • Coreaudio render callback in monotouch
  • The command 'yarn --v' also initiates 'yarn install' and installs packages automatically. Why is this happening?
  • save multiple matches in a list (grep or awk)
  • Can a number register be used in a groff request?
  • Mapping FAQ with RASA for large dataset (2000+)
  • Fragment not receiving LiveData updates after remove + add
  • FitText.js makes text bigger rather than smaller
  • ARM - Implementing stack with load/store multiple register values
  • How to check if a ChromeCast Session is already in progress
  • ngForm inside a Carousel Slide in UI Bootstrap not working
  • Clearing attributes in Tritium
  • "vagrant up" failing: Vagrant VM failed to remain in the running state
  • ftsearch returning empty docs
  • What are the advantages of setting "hive.exec.parallel" to false in Hive ?
  • Creating a root certificate in FiddlerCore
  • How to access app.config in a blueprint?
  • DB2 RECORDSET table name converted to uppercase
  • shadow
    Privacy Policy - Terms - Contact Us © ourworld-yourmove.org