Ecommerce software home
Shopping Cart Software Forum for Ecommerce Templates
 
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

Find us on Facebook Follow us on Twitter View our YouTube channel
Search our site
 All Forums
 Technical
 ASP (Windows server) versions
 searching for customers by state
Author « Topic »  

WaltG
Ecommerce Template Expert

USA
845 Posts

Pre-sales questions only
(More Details...)

Posted - 02/19/2019 :  08:54:28  
I tried finding a customer that the only info I remember is that he lives in California.

I tried a search on CA and 90001 but nothing returned. Is there anyway to search for state other than doing a SQL search of the database?


Walt

www.rustystumps.com
Manufacturer of fine scale model railroad kits and detail parts

Andy
ECT Moderator

95440 Posts

Posted - 02/19/2019 :  08:58:43  
Hi Walt

You can search by address or zip in the admin orders page if that helps.

Andy

Please feel free to review / rate our software

WaltG
Ecommerce Template Expert

USA
845 Posts

Pre-sales questions only
(More Details...)

Posted - 02/19/2019 :  09:01:05  
Andy,

That's where I've been searching. zip range doesn't work.

Yes, but the only info I have is what state he lives in. It's been awhile since I've had contact with him and with well over 5,000 customers in the files it's hard to remember one of them for a long time.

Walt

www.rustystumps.com
Manufacturer of fine scale model railroad kits and detail parts

Edited by - WaltG on 02/19/2019 09:03:18

Andy
ECT Moderator

95440 Posts

Posted - 02/19/2019 :  09:08:43  
I can't see another way in the admin - you could download all orders to a csv file and search in Excel perhaps?

Andy

Please feel free to review / rate our software

WaltG
Ecommerce Template Expert

USA
845 Posts

Pre-sales questions only
(More Details...)

Posted - 02/19/2019 :  09:20:00  
Thanks Andy, kind of thought that's what I'd have to do.


Walt

www.rustystumps.com
Manufacturer of fine scale model railroad kits and detail parts

midvalleydrifter001
Ecommerce Template Expert

USA
912 Posts

Posted - 02/19/2019 :  13:41:21  
Did you try searching by California instead of CA?

It works in my admin.

Patrick

WaltG
Ecommerce Template Expert

USA
845 Posts

Pre-sales questions only
(More Details...)

Posted - 02/23/2019 :  08:55:49  
Patrick, yes but it came back blank. Anyway, customer contacted me in the meantime and said the problem was solve. thanks.



Walt

www.rustystumps.com
Manufacturer of fine scale model railroad kits and detail parts

Paradise
Ecommerce Template Guru

USA
1602 Posts

Pre-sales questions only
(More Details...)

Posted - 02/23/2019 :  13:44:00  
I clicked California under state in the admin, pulled up all the orders from CA, I clicked on one, copied the zip and then searched by zip and that order came up, seems to work fine.

Mark
Responsive Design Deals Ecomm Plus - ASP 6.8
www.paradiseclothingco.com

WaltG
Ecommerce Template Expert

USA
845 Posts

Pre-sales questions only
(More Details...)

Posted - 02/24/2019 :  08:46:06  
Well, California returned empty.

CA brought back every customer with "ca" in there name. There was no State field to search on in Admin Orders on my system and I'm running v6.9.4 version.

I did a search on Address but that could also return street, town and state names with CA in them.

Walt

www.rustystumps.com
Manufacturer of fine scale model railroad kits and detail parts

midvalleydrifter001
Ecommerce Template Expert

USA
912 Posts

Posted - 02/24/2019 :  09:34:04  
Select "Search Address"

Type in: California

Paradise
Ecommerce Template Guru

USA
1602 Posts

Pre-sales questions only
(More Details...)

Posted - 02/24/2019 :  16:10:11  
State is in the drop down, it might say Payment Method, change it to state and pick the state below.

Mark
Responsive Design Deals Ecomm Plus - ASP 6.8
www.paradiseclothingco.com
  « Topic »  
Jump To:
Shopping Cart Software Forum for Ecommerce Templates © 2002-2022 ecommercetemplates.com
This page was generated in 0.03 seconds. Snitz Forums 2000