Jump to content
thirty bees forum
  • 0

Obtaining an IP address from an abandoned cart

The Pellet Guy


As per the title 

I have a new product that many shops cannot get their hands on and every day sometimes twice a day I get a customer adds all the remaining stock of that product to the cart  then does the off  and never buys the item

the system classes them as a guest as they are not registered,  Is it possible to obtain the IP address of that user  are there any tricks I can use to capture the culprit  ( I think its another shop playing games )

Im not overly bothered as it meens im attracting the attention of my competitors but would love to know if its the same person doing this since the day I went live

Link to comment
Share on other sites

5 answers to this question

Recommended Posts

  • 0

If you have installed and enabled module 'Data mining for statistics' then IP address is already stored.

The IP address is stored in tb_connections table. You can access it using this query:

SELECT INET_NTOA(c.ip_address)
FROM tb_connections c 
INNER JOIN tb_guest g ON (c.id_guest = g.id_guest) 
INNER JOIN tb_cart cc on (cc.id_guest = g.id_guest)
WHERE cc.id_cart = <cart_id>


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...