VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: kostianev on April 17, 2020, 16:45:43 PM

Title: How to sort orders by city, or how to grab the clients from extact city
Post by: kostianev on April 17, 2020, 16:45:43 PM
Hello,

I want to sort orders by City, or to take only Users/Clients from exact match city?
How can I do this? Is it possible?

I need their details, like emails, telephone and etc. from the order details.
Title: Re: How to sort orders by city, or how to grab the clients from extact city
Post by: GJC Web Design on April 17, 2020, 16:58:23 PM
do it directly in the DB

SELECT * FROM `#__virtuemart_order_userinfos` WHERE `city` LIKE 'Orlando'
Title: Re: How to sort orders by city, or how to grab the clients from extact city
Post by: kostianev on April 17, 2020, 18:36:20 PM
Is it possible to be done from Administrator panel, because we don`t hvae access to the MySQL. Only in administrator area.
Title: Re: How to sort orders by city, or how to grab the clients from extact city
Post by: GJC Web Design on April 17, 2020, 19:38:14 PM
not that I know of .. the code would need to be written to extend administrator/index.php?option=com_virtuemart&view=user
Title: Re: How to sort orders by city, or how to grab the clients from extact city
Post by: Studio 42 on April 17, 2020, 23:14:16 PM
You can write a vmextended plugin to display a view in the back-end.
I use this many times for my customers. Eg
- To show registred user that never ordered products.
- To send emails to manufacturers when stock is low
- To display saved Vm carts
- To do specific CSV export
....
Title: Re: How to sort orders by city, or how to grab the clients from extact city
Post by: beltoforion on April 19, 2020, 18:13:13 PM
Quote from: Studio 42 on April 17, 2020, 23:14:16 PM
You can write a vmextended plugin to display a view in the back-end.
I use this many times for my customers. Eg
- To show registred user that never ordered products.
- To send emails to manufacturers when stock is low
- To display saved Vm carts
- To do specific CSV export
....

do you recommend any tutorial on creating plugins?
Title: Re: How to sort orders by city, or how to grab the clients from extact city
Post by: Studio 42 on April 19, 2020, 18:53:35 PM
I only have found this https://docs.virtuemart.net/tutorials/development/84-extension-plugins.html but thz doc is really a main concept
Title: Re: How to sort orders by city, or how to grab the clients from extact city
Post by: pinochico on April 19, 2020, 19:15:35 PM
Patrick:

very old documentation :) Is actually or existing new?

I thin, better is looking inide another existing plugin, but I dont know in which
Title: Re: How to sort orders by city, or how to grab the clients from extact city
Post by: Studio 42 on April 19, 2020, 23:34:37 PM
I dont have found a real one.
But if you inspect the admin virtuemart.php code, you know what to do.