Need a list of all customers who have ordered something

[defuzed]

Hi, this seemed like the best place to post this question, so here goes:

 

Like the title says i need a list of all customers who ever ordered something.

 

I realize i can get a csv of all customers and also a csv of all orders, but what i really need is a list that will list just customers that have ordered something and only list them once (so i don't have a list with the same customer in it a 100 times).

 

I haven't found such an option to filter in the backend customers tab and i'm guessing it doesn't exist ...

 

Do any of you have an idea, maybe some excel magic, to maybe remove duplicate e-mail adresses from the orders tab? 

 

[vekia]

well, without module / or modificaiton it will not be possible.

you will need to create mysql query:

SELECT c.* FROM ps_orders AS o
INNER JOIN ps_customer AS c ON o.id_customer = c.id_customer
GROUP BY c.id_customer

result of this query is a list of customers who bought something from your store

[defuzed]

hi vekia, thanks great idea, i'll try to build a module and post back

[vekia]

may i know for what purposes you want this customers list? maybe there is a bit different solution than developing module for it