Any way to delete customers with no purchases?

[micetrap]

I am currently deleting out old customer accounts without any sales. Is there an easier way to find and mass delete customers with zero purchases than doing it manually?

[Guest]

haven't seen one with the contributions but you could write some code and check for each customer's orders. Your sql could be

 

select distinct CONCAT(c.customers_lastname, ' ', c.customers_firstname) as full_name from customers c left join orders o on (o.customers_id=c.customers_id) where orders_id is null

 

you can run it with phpmyadmin to see the results.