"Last visit" column on Customer page does not seem to be working

[Haziq]

Hi,

It seems as though the last visit column on the customer page does not update whenever the customer visited the website. The last visit seems to show the time and date the customer registered an account. Is there a fix for this? I'm not sure if it's related, but I tried reinstalling the 'Data mining for statistics' module, but the issue still persists. 

[Mikeey]

Have you compared that the dates doesn't match in database ps_connections?

[Haziq]

On 8/3/2021 at 3:02 PM, Mikeey said:

Have you compared that the dates doesn't match in database ps_connections?

Hi, what do i compare it with? There seems to be more than 100k connections, despite only having about 200 customers registered.

[Mikeey]

Well, in your picture you have 2 dates that are the same. Are you sure that some customer has visited the shop more than once? After the first time when registration was made..

Chose a customer from your picture and compare the last visit date with ps_connections.. check If there is a newer post in ps_connection, for that customer.

connections are all the visitors for the shop, even unregistered and registered customers that doesn’t login. There should be a lot of connections 
 

[Haziq]

Some customers definitely visited the shop more than once, if I were to compare their last visit to their orders placed. (e.g. their last visit was shown is last week, but they placed an order today)