How to sort orders by city, or how to grab the clients from extact city

[kostianev]

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.

[GJC Web Design]

do it directly in the DB

SELECT * FROM `#__virtuemart_order_userinfos` WHERE `city` LIKE 'Orlando'

[kostianev]

Is it possible to be done from Administrator panel, because we don`t hvae access to the MySQL. Only in administrator area.

[GJC Web Design]

not that I know of .. the code would need to be written to extend administrator/index.php?option=com_virtuemart&view=user

[Studio 42]

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
....

[beltoforion]

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?

[Studio 42]

I only have found this https://docs.virtuemart.net/tutorials/development/84-extension-plugins.html but thz doc is really a main concept

[pinochico]

Patrick:

very old documentation Is actually or existing new?

I thin, better is looking inide another existing plugin, but I dont know in which

[Studio 42]

I dont have found a real one.
But if you inspect the admin virtuemart.php code, you know what to do.