How to show group on orders list



  • If you want to see the customer group on orders list
    (from ps forum)

    change
    / httpdocs / controllers / admin / AdminOrdersController.php
    or create override

    find this

    CONCAT(LEFT(c.`firstname`, 1), \'. \', c.`lastname`) AS `customer`,
    

    and change to

    CONCAT(LEFT(c.`firstname`, 1), \'. \', c.`lastname`, \' (\', gr.`name`, \')\') AS `customer`,
    

    after

    LEFT JOIN `'._DB_PREFIX_.'customer` c ON (c.`id_customer` = a.`id_customer`)
    

    add

    LEFT JOIN `'._DB_PREFIX_.'group_lang` gr ON (gr.`id_group` = c.`id_default_group` AND gr.`id_lang`= '.(int)$this->context->language->id.')
    

    before
    0_1517517636320_6a2aa48e-198e-4c39-9eca-60102f8a4991-grafik.png


    after
    0_1517517658728_910a0db6-ff03-4259-87c6-5d9f4d078838-grafik.png


 

Looks like your connection to thirty bees forum was lost, please wait while we try to reconnect.