[Virtuemart] Customize Order List - adding extra column

-
In this post, I am going explain on how to add an extra column in Virtuemart Administrator Order List page. (Note that, in this example, I'm going to add a new address_1 column).

Note: Please refer to my previous post on "adding search keywords" for the SQL query code for the other fields that you want.

Getting Started.

In /administrator/components/com_virtuemart/html/order.order_list.php

locate this section, around line 27. Then add "address_1" into the line, as below.
//$list .= "first_name, last_name FROM #__{vm}_orders, #__{vm}_order_user_info WHERE ";
// This is the modified line.
$list .= "first_name, last_name, address_1 FROM #__{vm}_orders, #__{vm}_order_user_info WHERE ";


After that, locate this section, as usual and note that "Address_1" is already the added column.
$columns = Array(  "#" => "width=\"20\"", 
     "<input type=\"checkbox\" name=\"toggle\" value=\"\" onclick=\"checkAll(".$checklimit.")\" />" => "width=\"20\"",
     $VM_LANG->_('PHPSHOP_ORDER_LIST_ID') => '',
     $VM_LANG->_('PHPSHOP_ORDER_PRINT_NAME') => '',
     // This is you "address_1" column header,
     'Address_1' => '',
     $VM_LANG->_('PHPSHOP_ORDER_LIST_PRINT_LABEL') => '',
     $VM_LANG->_('PHPSHOP_ORDER_LIST_TRACK') => '',
     $VM_LANG->_('PHPSHOP_ORDER_LIST_VOID_LABEL') => '',
     $VM_LANG->_('PHPSHOP_CHECK_OUT_THANK_YOU_PRINT_VIEW') => '',
     $VM_LANG->_('PHPSHOP_ORDER_LIST_CDATE') => '',
     $VM_LANG->_('PHPSHOP_ORDER_LIST_MDATE') => '',
     $VM_LANG->_('PHPSHOP_ORDER_LIST_STATUS') => '',
     $VM_LANG->_('PHPSHOP_UPDATE') => '',
     $VM_LANG->_('PHPSHOP_ORDER_LIST_TOTAL') => '',
     $VM_LANG->_('E_REMOVE') => "width=\"5%\""
    );
$listObj->writeTableHeader( $columns );

As you can see, those are the column headers for the table, and the last line is the function to print out all the column headers.

Then, you will need to locate this section of code, and add $db->f('address_1'); as below:
$tmp_cell = $db->f('first_name').' '.$db->f('last_name');
 if( $perm->check('admin') && defined('_VM_IS_BACKEND')) {
  $url = $_SERVER['PHP_SELF']."?page=admin.user_form&amp;user_id=". $db->f("user_id");
  $tmp_cell = '<a href="'.$sess->url( $url ).'">'.$tmp_cell.'</a>';
 }
 
 $listObj->addCell( $tmp_cell );

 // This will print "address_1" column, which is placed afer the "Name" column
 $tmp_cell = $db->f('address_1');
 $listObj->addCell( $tmp_cell );

Note: The ordering of the the print cell function (i.e. the $listObj->addCell( $tmp_cell ); ) is important, as you wouldn't want to jumble up the different fields.

Thats all. Hope this help :)

Comments

  1. AnonymousNovember 10, 2010 at 4:43 AM

    oh my god u are amazing
    thnx
    can you add the products in this list???

    ReplyDelete
  2. UnknownNovember 11, 2010 at 4:46 AM

    or vendors in this list ?

    ReplyDelete
  3. UnknownNovember 13, 2010 at 1:03 AM

    @mezo You can add these line to include the order_item_name/vendor_id in the search:

    $list .= "vendor_id, #__{vm}_order_item.order_item_name, ";

    $list .= "JOIN #__{vm}_order_item ON #__{vm}_orders.order_id=#__{vm}_order_item.order_id WHERE ";


    and locate similar lines to the following, and add these (keyword filter) in between the lines:

    $q .= "OR order_item_name LIKE '%$keyword%' ";
    $q .= "OR order_item_name LIKE '%$keyword%' ";

    Hope it helps.

    Tell me if you find the above explanation is not clear.

    ReplyDelete
  4. Mezo AbosamyNovember 28, 2010 at 10:36 PM

    can u give me more details please
    thank you for your help

    ReplyDelete
  5. USB 3GMarch 14, 2011 at 12:56 PM

    This imformation is a great help. Try to keep your imformation. I and other people need to understand about it. Thank you !

    ReplyDelete
  6. RooomDecember 6, 2011 at 8:22 AM

    $list  = "SELECT #__{vm}_orders.order_id,order_status, #__{vm}_orders.cdate,#__{vm}_orders.mdate,order_total,order_currency,#__{vm}_orders.user_id, ";
    $list .= "first_name, last_name, vendor_name FROM #__{vm}_vendor, #__{vm}_orders, #__{vm}_order_user_info WHERE ";
    $count = "SELECT count(*) as num_rows FROM #__{vm}_orders, #__{vm}_order_user_info WHERE ";

    BAD TABLE!!!! ALL vendors insert? help my? please
    roooma@ipnet.kiev.ua

    ReplyDelete
  7. UnknownJune 6, 2012 at 2:32 AM

    I like this direction. My question is how can this be done to show a attribute. For example I have a greeting card website where a customer can choose a writing style for their message to be hand written in the card for them and I would like this style to carry over and be a column in the order list and show up in each order details. Hope that makes sense.

    Kindest Regards,
    Jeremy

    ReplyDelete
  8. UnknownJune 9, 2012 at 3:54 AM

    Bing Han, Can you help me with the below post? Thank you.

    ReplyDelete
  9. Bing HanJune 15, 2012 at 10:37 AM

    Hey, so sorry for the late reply. Was busy with project deadlines these few days.

    I guess the above guide more or less points you to the direction of adding new fields. So now you just need to display it in the order details page?

    I'll see if I can look into it (hopefully come up with a guide) next week. On a trip this weekend.

    ReplyDelete
  10. Jeremy RwsJune 26, 2012 at 3:46 AM

    Bing,


    Thank you for your help. I just want to display attribute in the Order List that way as my handwriters are going in to check the orders they can see which one is theirs without having to click into the order to see the attribute selection.


    I guess just let me know. my email is jeremy@revolutionwebstudios.com


    Thank you,
    Jeremy

    ReplyDelete
  11. MyAlleppey TourismJuly 4, 2012 at 2:17 PM

    Hi Bing Han Goh,


    My name is anoop, I am customizing the backend of virtuemart 2.06. In the order list we can see Filter Name: Go Reset Order Status: these two fields ,
    I need to add an additional fields to select the order by date . I searched all the files , but didnt found, displayDefaultViewSearch function in the vmview.php page. which page i have to edit if i have to add another filter to it . please reply . anoop@wsdtech.com

    ReplyDelete
  12. swati29September 5, 2012 at 6:38 PM

    I love that you outlined the codes for adding extra column in Virtuemart Customize Order list in such a clear, concise way.

    ReplyDelete
  13. Babyblessings PerfilSeptember 8, 2012 at 3:56 AM

    Hello BIng Han Goh,

    tnanks for the information.

    I'd like to add an extra column in Virtuemart Administrator Order List page with the product image. How can I do it?

    Thanks for the help.

    I have already the column, but I can't figure out how to show the image.

    ReplyDelete

Post a Comment

Popular posts from this blog

[Azure Websites PHP] Cross Domain request results in blank response page after Preflight HTTP OPTIONS

-
Image
THE PROBLEM I've deployed a REST API application ( CodeIgniter with Phil Sturgeon's Rest-Server library ) on Azure Websites. Although I've set the Access-Control-* header in my PHP application: header('Access-Control-Allow-Credentials: true'); header('Access-Control-Allow-Origin: *'); header('Access-Control-Allow-Methods: GET, POST, DELETE, OPTIONS'); header('Access-Control-Allow-Headers: Origin, X-Requested-With, Content-Type, Accept'); (If you need a working test file, here's the gist for the test file) But Azure Websites server doesn't return the headers in response. And thus all requests to the server failed with the error message: Origin http://example.azurewebsites.net is not allowed by Access-Control-Allow-Origin.   In order to make sure there's no problem with my application, I've deployed the same code to Appfog.com . And as expected, the application works just fine. The same application d...
Read more

[Magento] Create Contact Form with Dynamic Recipient

-
There are many ways of creating contact forms to email to multiple recipient. I'm going to describe a way that uses Javascript a the frontend to change the target recipient. Advantage of this method: Easy to add in new emails in the future. Disadvantage of this method: For those who are particularly concern email privacy, you might not want to use this method. You can modify the email checking to the backend (controller) instead. Okay enough talking, lets get started. Step 1: Set up HTML form fields I'm going to use an example of drop down select to change the email. Of course, this is fairly easy to modify with other forms as well. Open up app/design/frontend/default/<theme>/template/contacts/contacts.phtml Insert the following snippets anywhere between the <form>...</form> tag. <select name="interest" id="interest" title="<?php echo Mage::helper('contacts')->__('Please select department t...
Read more