Sales Statistic By Customer Group In Prestashop 1.6

[ArcziD3]

Hello

i have to create a few different customer group, about 20-30 of different customer group,

I need to get sales statistic of those group, have you got any idea how can i do it?
is there any modules which offer sales statistic by customers group?

 

Thanks a lot,

Regards

ArcziD3

Edited March 4, 2016 by ArcziD3 (see edit history)

[jaytech]

I need this also. I'm surprised it isn't available at a core feature.

 

Does anyone have a SQL query that will do this?

[fenilft]

Hi, use this query to get sales by user group.

SELECT ga.name , sum(po.total_paid) as totalpaid FROM `ps_orders` po 
LEFT JOIN ps_customer_group pcg ON pcg.id_customer = po.id_customer
LEFT JOIN ps_group_lang ga ON ga.id_group = pcg.id_group
WHERE Date(po.date_add) between "2019-01-01" and "2019-01-31" 
GROUP BY pcg.id_group;