Backend - Add group in customers list

[jacksfregio]

Hi,

What files in default backened theme I have to modify to show the group which a customer belong to in customers list in backend? Thanks

[rocky]

Create override/controllers/admin/AdminCustomersController.php with the following:

<?php

class AdminCustomersController extends AdminCustomersControllerCore
{
    public function __construct()
    {
        parent::__construct();
        
        $this->_select .= ', g.`name` as group_name';
        $this->_join .= '
            LEFT JOIN `'._DB_PREFIX_.'customer_group` cg ON (a.`id_customer` = cg.`id_customer`)
            LEFT JOIN `'._DB_PREFIX_.'group_lang` g ON (cg.`id_group` = g.`id_group` AND g.`id_lang` = '.
            (int)$this->context->language->id.')';
        
        $this->fields_list['group_name'] = array('title' => $this->l('Group'));   
    }
}

This will add a new "Group" column to the Customers tab. Don't forgot to go to Advanced Parameters > Performance and click "Clear cache".

[freelanx]

I am very interested on this. Do anyone have a solution like this for Prestashop 1.7?

 

Thanks a lot

[beepow]

I get a 500 error on ps 1.6.1.14 😕