cancel
Showing results for 
Search instead for 
Did you mean: 

last 5 orders in dashboard not showing the name of guest customers

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

last 5 orders in dashboard not showing the name of guest customers

I have upgraded my magento website from 1.7 to 1.9  and now on dashboard page i don't see name of customers in last 5 orders section, how ever i have tried one fix , which on use shows the customer name but the link on the orders change and it leads to an order that does not exists ..

 

below is the fix that i tried 

 

but it changes the link too which does not work..

 

below is the solution that i tried 

 

I have coded for this
In Mage/Adminhtml/Block/Dashboard/Orders/Grid.php about line '51' replace "->joinCustomerName('customer')"  with ->joinCustomerBName('customer')
and  in Mage/Reports/Model/Resource/Order/Collection.php

 add a function
 public function joinCustomerBName($alias = 'name')
    {
        $fields      = array('t2.firstname', 't2.lastname');
        $fieldConcat = $this->getConnection()->getConcatSql($fields, ' ');
        $this->getSelect()
        ->join(array('t2' => 'sales_flat_order_address'),'main_table.billing_address_id = t2.entity_id')->columns(array($alias => $fieldConcat));
       

        return $this;
    }

 

Now i need a solution which does not changes the link and only displays the name for guest customers too, any help would be appreciated.