Developer forum

Forum » CMS - Standard features » Associating tracking information with user

Associating tracking information with user

E-mail notifications
Scott Forsyth Dynamicweb Employee
Scott Forsyth
Reply
Posted on 24/08/2021 21:29:52

I need to track down a missing cart for a user who I don't know their IP address. I know the user though. 

I'm attempting to track their visit using the TrackSession_{current} table in the database. However, I don't see a userid stored anywhere. How do I associate a user to the session? I do see that TrackingView_{current} has a TrackingViewUserId, but I'm unable to find that user in that table for today's visit. I do see that AccessUserLastLoginOn updated this morning though, so I know that it was this user who has logged in today.

My question, how do I associate the TrackSession's sessionId to the login's AccessUserId?

Thanks,

Scott

 


Replies

 
Nicolai Pedersen
Posted on 25/08/2021 09:31:35
Reply

Hi Scott

Well, the userid should be on the TrackingView table. If not, that user does not seem to have been logged in that date.

The userid is on the tracking view table and not the session table so we can see which steps are done while logged in and which are not.

You also have userid on the cart, so you should be able to find the cart on the order table.

BR Nicolai

 
Scott Forsyth Dynamicweb Employee
Scott Forsyth
Posted on 25/08/2021 18:08:47
Reply

Thanks Nicolai.

That's helpful to know that it should all be in the TrackingView table. At least I know which table to focus on.

The cart seems to have completely disappeared. There's no reference by OrderCustomerAccessUserID or OrderCustomerNumber in EcomOrders (except completed orders from the past), and AccessUser.AccessUserCartID is null for that user. 

This site requires logging in before adding to the cart, so I don't know how this user would have created an order without logging in. So it's odd that they aren't in the TrackingView table. 

Anyway, you answered my question. I'll keep digging. I'm waiting to see if I can get the IP address of the customer since I can't find it otherwise yet. Once I have the IP, I can piece a lot more together.

Scott

 

 

You must be logged in to post in the forum