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

[MichaelEZ]

well just look at your access log - and look for spec url of that product - there u can "catch" them all 😄 But if they use VPN/proxy.. 

[datakick]

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>

 

[datakick]

Or you can use my datakick data export and import module 🙂 Just a shameless plug

[The Pellet Guy]

20 hours ago, datakick said:

Or you can use my datakick data export and import module 🙂 Just a shameless plug

Nothing wrong with shameless plugs 🙂 as i get more into this cart software im sure I will be an investor, 

Thanks for all the help guys  

 

[led24ee]

There is module "order ip log". This creates a new table where is cart number and IP. I use this.