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 936 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 936 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 »