Cart Item records were inactive on sc_cart_item

Alex307
Kilo Guru

‎04-24-2024 10:03 AM

I had an edge case where a user added two items to their cart, then later tried to remove them using the Clear Cart button. Somehow this resulted in the records on 'sc_cart_item' just deactivating instead of deleting, so the Cart header menu was still displaying that they had two items, but when they clicked on it the sc_cart page displayed that their cart was empty.

Does anyone know how this could have happened?

0 Helpfuls
  • 381 Views
1 REPLY 1

Bert_c1
Kilo Patron

‎04-24-2024 10:44 AM - edited ‎04-24-2024 11:00 AM

Hi,

 

The 'cart' field on the sc_cart_item table is a Reference to the "Shopping Cart" table. The 'Reference cascade rule' for that has 'Delete' (use the Advanced view on the dictionary record to see that.  That could be the reason.

 

Cascade delete rules

 

However, the example I gave results in cart items being deleted when a cart is delete.

 

Review the UI action named "Clear cart" in the instance. I don't see that OOB.

 

Seems you can impersonate the user and test. You can also create a Support case, the TSE's can review log entries if you provide details on the user and time the event occurred.

0 Helpfuls