Empty Shopping Cart Error

[AnnMarieC]

We are experiencing an intermittent problem of an empty shopping cart when a user orders an item. When a user orders an item and then clicks back to the main page of the service catalog the item sometimes disappears from the cart. If the user tries to check out the system prints a message stating you cannot check out with an empty cart. The item was not deleted from the cart so it should still be there.

Has anyone else experienced an issue like this?

[cornflakes_01]

It is also worth noting that in some cases, upon viewing the SC_Cart table, we've noticed that the system is creating a second or third cart for the user, rather than just one, but those carts come in as empty. The current cart still exists in the system with all the item associated, but upon submitting it is trying to check out the empty cart. When the user adds items onto the cart again, it submits properly. And another interesting thing results from that, is that the cart which was orignally filled, comes back from the dead later, and returns those items to the user's cart(Zombie Carts....).

Any feedback would be appreciated.

[adiddigi]

Agreed. I was working on a similar functionality and it was going something like this :

1. You don't have a cart
2. You create a cart and add 2 items.
3.When you actually submitting , you only see one item added to your cart
4.After you submit, one more cart with the left out item stares at you. Creeeeppppy 😮 😮 😮

[mattberan]

I just got the exact same thing for a Catalog build out. Also looking for a solution. I'm wondering if a business rule to kill those zombie carts is needed...

[cornflakes_01]

Hi Matt,
We did end up using a business rule to stop this behaviour. Last I can see, Service-Now did not acknowledge it as a problem. This script has solved our problems to date, hope it helps.

Business Rule:
Table: sc_cart
when: Before Insert

Script:
//Attempted workaround for empty cart issue
checkCarts();
function checkCarts(){
var crt = new GlideRecord('sc_cart');
crt.addQuery('user', current.user);
crt.addQuery('name', 'DEFAULT');
crt.query();
if(crt.next()){
current.setAbortAction(true);
}
}