Jump to content
thirty bees forum

How to show group on orders list


Recommended Posts

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...