A user added items to her cart last night. Somehow her session was lost and this morning when she tried to check out, they were gone. She had spent several hours shopping and is quite frustrated. We have to find her cart items or lose the sale.
There is an "abandoned carts" area of the admin, but it seems to only reflect logged in users, so it is useless for me.
I am looking at the database table
report_event. Looking at entries from last night, and limiting by
event_type_id = 4 (which is
event_name = "checkout_cart_add_product" in table
report_event_types), I see two groups of entries from around the time she was shopping. Each group has the same
subject_id, which I'm thinking might connect to a user session. The object ids are all different but I don't know what they are. Are they product_ids?