How to get the date a req item was added to cart after it has been submitted?

[johnnyw]

I'm trying to troubleshoot an issue that we saw crop up twice in the past 2 weeks and need your help.

We have a catalog item that was recently updated that included an extra variable (mandatory) with a modified workflow.   These 2 weeks, I saw 2 of these request items come through with that new variable not populated which caused the workflow to fail since the approval step in the workflow relies on the value of that new variable to find who the approval should go to.   So I'm wondering how the user could have submitted the request/request item without this field populated.   My guess is that he had the item in his cart prior to the variable being added and the wf updates.   However, I cannot confirm that since I don't see any record of the history of when the item was added to the cart.

I know that if I could see the item in the cart prior to him submitting it, I could look in sc_cart_item to see the item there, but after it has been submitted, I couldn't find a way to trace it back to get the "created date" from the sc_cart_item table.   Does anyone know how I can retrieve this information?

Thanks a bunch!

Regards,

Johnny

[brian_quinn · Accepted solution]

Johnny,

Try checking the sc_item_option table.   It should contain the variables that were set when the user added the item to the cart and the "Created" field is the time that the item was added to the cart.   Once the item is ordered, the "Cart item" field is emptied, but the record still exists.

Thanks

Brian

[johnnyw]

Thanks Brian.   That worked!