Search Customers by State

[cwd]

Is there a way or a plug-in that will allow the admin of a zen cart to do a search of how many customers are in each state, and list all the customers in that state?

[lat9]

Not that I'm aware of ... what's the problem you're trying to solve?

[cwd]

I just have a customer that would like to be able to see what customers they have in any given state. The reason for this is because when they go to that state for a conference they can let them know that they will be in their area.

[lat9]

How are you with phpMyAdmin?

[cwd]

Not bad. But is there a plug-in out there that I can install for them. This way they can do this in the admin area. They know nothing about php.

[stevesh]

This apparently allows the transfer of order information to a spreadsheet:

http://www.zen-cart.com/downloads.php?do=file&id=406

[lat9]

Not bad. But is there a plug-in out there that I can install for them. This way they can do this in the admin area. They know nothing about php.

If you can live with phpMyAdmin (or come up with a little plugin that will work in the admin), the following SQL will retrieve the distinct states of purchasing customers:

SELECT distinct customers_state FROM `orders`