Question Re: How to load cart from database? in CRM and CX Q&A

How to load cart from database?

Former Member — Tue, 26 Jun 2018 10:17:14 GMT

Hi there,

I´m overriding the DefaultSessionCartService and want to implement the following:

 // this is custom code -> returns sessionCart if there is one and null if not.
   final CartModel cart = getSessionCartWithoutCreatingOne();
 
         if (null != cart) {
             return cart;
         } else if(/*cart exists in database*/){
             //load cart from database
         }else{
            //create new cart
        }

How can I check if the cart is inside the database and how can I load it then?

Cheers! Raphael

Re: How to load cart from database?

VinayKumarS — Tue, 26 Jun 2018 10:26:00 GMT

retrieve the cart from database based on the cart id.

Re: How to load cart from database?

Former Member — Tue, 26 Jun 2018 10:32:06 GMT

Wich Classes/methods do I need for that?

Re: How to load cart from database?

Marko_salonen — Tue, 26 Jun 2018 10:57:44 GMT

How do you know with cart to read? Cart code from cookie or from session? You could take a look in CartRestorationFilter how it is done.

Re: How to load cart from database?

Former Member — Wed, 27 Jun 2018 14:02:21 GMT

All right.

if someone is still interrested, here is how I got it done:

    final CartModel cart = getSessionCartWithoutCreatingOne();
         if (null != cart) return cart;
 
         final CustomerModel customer = (CustomerModel) userService.getCurrentUser();
         final BaseSiteModel paramBaseSiteModel = baseSiteService.getCurrentBaseSite();
         List<CartModel> cartsForSiteAndUser = commerceCartService.getCartsForSiteAndUser(paramBaseSiteModel, customer);
 
 return cartsForSiteAndUser.isEmpty() ? cartFactory.createCart() : cartsForSiteAndUser.get(0);

hope this helps 😉

Re: How to load cart from database?

Marko_salonen — Wed, 27 Jun 2018 14:17:24 GMT

Why would you call userService twice? Why not final CustomerModel currentCustomer = (CustomerModel)userService.getCurrentUser(); And if you look at getCartsForSiteAndUser method you see it takes a UserModel as argument so getCurrentUser call is enough

You should as well have the null check before you start to get the users because you then save some calls to database. And how do you handle if the user wants to have a specifc cart that it has saved? Be aware that for anonymous user this call can be heavy if the cart cleaning job has not been executed.

Re: How to load cart from database?

Former Member — Wed, 27 Jun 2018 15:14:05 GMT

Good point - Thanks! I dont know why I did it that way but I´ll do the refactoring and update the codesnippet tomorrow.

In this shop the user is only supposed to have one cart so thats why the ct (0) should be just fine.

Re: How to load cart from database?

Marko_salonen — Wed, 27 Jun 2018 15:22:57 GMT

Refactoring is always good :)

Re: How to load cart from database?

andyfletcher — Fri, 29 Jun 2018 12:00:34 GMT

I think you're looking for the method hasSessionCart() method

 if (cartService.hasSessionCart()) {
     return cartService.getSessionCart();
 }