Delete all user with no order VirtueMart 3.2.2

[otaks]

HI, how i can delete all user with no order?

[pinochico]

with custom mysql in DB?

[otaks]

You can help?

[Studio 42]

I created a plugin for my customer'and my shop) but it's not available in my shop for now.
The view display a column with number of orders and you can filter "with orders" or not
You have a delete button to mass remove Joomla accounts, or to activate trusted customers.

[otaks]

HI, you can send your plugin?

[Studio 42]

It's now in myshop here https://shop.st42.fr/en/tools/user-order-stats.htm

[Jörgen]

@patrick

Great plugin, thanks, just bought it.

Jörgen @ Kreativ Fotografi

[jenkinhill]

@patrick  I bought it too. A real timesaver!

[Studio 42]

Jörgen and jenkinhill, i update the plugin.
Sometime the order counter can be bad in the old release, because i used the virtuemart_vmusers table and the user id was not set in  otaks shop database.
I think that the problem is only in hes case, but i prefer it work for all cases.
I corrected the search problem too(only in some Vm release) so now it should work in most Vm releases.
You can get the new file directly or using the Joomla updates.
Do not hesitate, if you need some more features, i only implemented what i and my customers needed.