Using the Abandoned Carts Report in Magento

Abandoned cart

 

When you are running an e-commerce store, inevitably you will experience shopping cart abandonment - customer adds items to their cart but leaves your site before checking out.  In fact, the average shopping cart abandonment rate is 68.63%.There are a number of reasons for this phenomenon. Customers experience unexpected costs at checkout, the checkout process is too complicated, found a better price elsewhere, etc. No matter what the reason, they all equal the same thing - lost sales.  The good news is that you can use the abandoned carts report to identify the customers in question and try to win them back!

Where do I find this gem of a report, you ask?

Log in to your Magento admin.  Click on Reports->Shopping Cart->Abandoned Carts

Abandoned cart report screenshot

The report display will show you the following:

  • Customer Name
  • Email
  • Number of Items
  • Quantity of Items
  • Subtotal
  • Applied Coupon
  • Created At
  • Updated At
  • IP Address

 

In this example you can see that "Bob Smith"  has abandoned his cart.  If we now visit Bob's Customer record, we will see exactly what was in it when he left the site.

Click Customers->"Customer Name"->Shopping Cart

 Abandoned cart report screenshot 2

 

 

Now, what to do with all of this new found data?

There are few ways to approach your abandoned cart data.

1. Analyze the amount of abandoned carts your site is experiencing then take a look at where you can make improvements.  Is the checkout process lengthy or complicated?  Should you offer a wish list for convenient "saving" of items the customer is interested in?  Is your site optimized for mobile devices?

2. Seize the opportunity to "remind" the customer that they have left something behind. Many successful online businesses use remarketing campaigns to bring the customer back to their cart and encourage the completion of the sale.  Often times the emails will include an incentive in the form of a coupon or free shipping.

3. Use the product data to learn about trends in popularity.  Are there certain products that are consistently left in carts?  Are certain products most likely to be part of a completed sale following an abandoned cart email?

 

Noggin nugget: Studies show that in 2015, $4tr of merchandise was left in abandoned online shopping carts - the largest amount of cart abandonment ever seen!3

 

 

1- Baymard Institiute, http://baymard.com/lists/cart-abandonment-rate 

2- Statista, http://www.statista.com/statistics/232285/reasons-for-online-shopping-cart-abandonment/

3- Supply Chain Brain, http://www.supplychainbrain.com/content/general-scm/quality-metrics/single-article-page/article/despite-record-e-commerce-sales-69-percent-of-online-shopping-carts-abandoned/

Integrating Google Analytics with your eCommerce S...
Can you remember life before the Internet?

Related Posts

 

Comments 3

Guest - Andy on Wednesday, 02 November 2016 16:38

I have a question - does the updated at column refers to when the abandoned cart was updated or o when the client's profile was updated?

I have a question - does the updated at column refers to when the abandoned cart was updated or o when the client's profile was updated?
Amy Gray on Thursday, 03 November 2016 10:57

Hi Andy! Good question. The "Updated At" column refers to the last time the customer edited their cart. Let's say they begin to checkout and then spend an hour or so shopping around the site. They add other items to their cart or change options in their cart, these events will trigger the "updated at" time stamp.

Hi Andy! Good question. The "Updated At" column refers to the last time the customer edited their cart. Let's say they begin to checkout and then spend an hour or so shopping around the site. They add other items to their cart or change options in their cart, these events will trigger the "updated at" time stamp.
Guest - alexmorco on Thursday, 08 February 2018 10:06

Good share Amy, I was looking for this guide and figured out the issue for fixing it with Sugar CRM, also, I am fixing issues to reduce cart abandonment, https://www.cloudways.com/blog/reduce-cart-abandonment/ , This is another helpful guide.

Good share Amy, I was looking for this guide and figured out the issue for fixing it with Sugar CRM, also, I am fixing issues to reduce cart abandonment, https://www.cloudways.com/blog/reduce-cart-abandonment/ , This is another helpful guide.
Already Registered? Login Here
Guest
Monday, 15 October 2018

Captcha Image