Forums / Managing Customers and Orders / Searching IP addresses

Searching IP addresses

Locked

Results 1 to 2 of 2

This thread is locked. New replies are disabled.

29 Aug 2007, 9:21 AM

gabenn2

Zen Follower

Join Date:: Feb 2007
Posts:: 109
Plugin Contributions:: 0

Searching IP addresses

Is there a way to do an IP address search on a customer if you know the IP address. I want to see if this person has ever purchased from my store using a different name and I would rather not go through thousands of customers.

Thanks in advance :)

30 Aug 2007, 4:57 AM

wolfsz

Zen Follower

Join Date:: Mar 2006
Location:: Australia
Posts:: 286
Plugin Contributions:: 3

Re: Searching IP addresses

Hi there
don't forget that the same customer could be using a different IP address too.
To do the search you want use phpmyadmin or similar click on the SQL tab and enter the query:
select * from zen_orders where ip_address = "16.113.188.202";