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

[mc12345678]

That would certainly provide a list of individuals that have purchased product, though it would not contain the list of individuals that have created an account and not completed a purchase. Something to consider or at least being aware of.

Can think of a few ways that some custom coding can obtain that information as lat9 is suggesting though turning that phpMyAdmin information into a query to display/print/download.

In lieu of that steve's recommendation certainly seems viable. Not having used the module I wonder how it works with say free items or non-shipped items considering it's primary target. I've also tried to look for some existing plugins but have not come up with anything better.

[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`

[cwd]

I will give both of these a try. Thanks guys for your help.