List of customers in a group

[Littlepants]

How can I see a list of all customers in a particular group please? (version 1/7/6/8) 

[w3bsolutions]

On the control panel you can only see the first 100, by clicking on the group details. If you want to see all of them you will have to run an SQL query, such as:

SELECT c.`id_customer` AS `id_customer`, `id_gender`, `firstname`, `lastname`, c.`email` AS `email`, `birthday`, `date_add`, c.`active` AS `active` , a.id_group 
FROM `ps_customer_group` a 
LEFT JOIN `ps_customer` c ON (a.`id_customer` = c.`id_customer`) 
WHERE 1 AND a.`id_group` = [your_group_id] AND c.`deleted` != 1 
ORDER BY id_group ASC 

replace [your_group_id] by the ID of the group you want. 

You can run the query in the control panel under Advanced Parameters > Database > Add new SQL query. You can then view the results on-screen or export them. 

[jgrodriguez.dev]

Hi @w3bsolutions tahnk you in advance for you answer , work for me! (two years later!)