Results 1 to 9 of 9

Hybrid View

  1. #1
    Join Date
    Nov 2005
    Location
    Coldwater Michigan
    Posts
    51
    Plugin Contributions
    0

    help question Search Customers by State

    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?

  2. #2
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    13,871
    Plugin Contributions
    96

    Default Re: Search Customers by State

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

  3. #3
    Join Date
    Nov 2005
    Location
    Coldwater Michigan
    Posts
    51
    Plugin Contributions
    0

    Default Re: Search Customers by State

    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.

  4. #4
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    13,871
    Plugin Contributions
    96

    Default Re: Search Customers by State

    How are you with phpMyAdmin?

  5. #5
    Join Date
    Nov 2005
    Location
    Coldwater Michigan
    Posts
    51
    Plugin Contributions
    0

    Default Re: Search Customers by State

    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.

  6. #6
    Join Date
    Feb 2005
    Location
    Lansing, Michigan USA
    Posts
    20,021
    Plugin Contributions
    3

    Default Re: Search Customers by State

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

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

  7. #7
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    13,871
    Plugin Contributions
    96

    Default Re: Search Customers by State

    Quote Originally Posted by cwd View Post
    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:
    Code:
    SELECT distinct customers_state FROM `orders`

 

 

Similar Threads

  1. Making spacific items not avaialble to outside state customers
    By lilguppy in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 11 Feb 2010, 06:47 PM
  2. Need list of customers only in specific state
    By dcfxking in forum General Questions
    Replies: 4
    Last Post: 21 May 2008, 04:36 PM
  3. No taxes for out of state customers
    By JayC in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 4
    Last Post: 15 May 2008, 11:26 PM
  4. Where is Customers State/Provice field
    By shocker in forum General Questions
    Replies: 1
    Last Post: 9 Mar 2008, 09:22 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg