VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: otaks on September 14, 2020, 09:03:41 AM

Title: Delete all user with no order VirtueMart 3.2.2
Post by: otaks on September 14, 2020, 09:03:41 AM
HI, how i can delete all user with no order?
Title: Re: Delete all user with no order VirtueMart 3.2.2
Post by: pinochico on September 14, 2020, 10:17:40 AM
with custom mysql in DB?
Title: Re: Delete all user with no order VirtueMart 3.2.2
Post by: otaks on September 14, 2020, 10:48:10 AM
You can help?
Title: Re: Delete all user with no order VirtueMart 3.2.2
Post by: Studio 42 on September 14, 2020, 14:19:57 PM
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.
Title: Re: Delete all user with no order VirtueMart 3.2.2
Post by: otaks on September 14, 2020, 14:42:06 PM
HI, you can send your plugin?
Title: Re: Delete all user with no order VirtueMart 3.2.2
Post by: Studio 42 on September 15, 2020, 11:46:35 AM
It's now in myshop here https://shop.st42.fr/en/tools/user-order-stats.htm
Title: Re: Delete all user with no order VirtueMart 3.2.2
Post by: Jörgen on September 15, 2020, 12:26:05 PM
@patrick

Great plugin, thanks, just bought it.

Jörgen @ Kreativ Fotografi
Title: Re: Delete all user with no order VirtueMart 3.2.2
Post by: jenkinhill on September 15, 2020, 13:49:15 PM
@patrick  I bought it too. A real timesaver!
Title: Re: Delete all user with no order VirtueMart 3.2.2
Post by: Studio 42 on September 16, 2020, 14:42:41 PM
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.