SOLVED - I upgraded my store to 8 and installed reCAPTCHA Free v1.1.3 - by PrestaHero
I can see the ip address of guests in BO - stats - visitor ids screen. But when i go to ps_connection in the db the ip_address column is garbled?
or (even better) does anyone know of a sql query that will cross check a customer order with their ip address. Ive got a non paying customer and i'd like to pull their ip address.
Thanks