Abandoned Cart Reports For WooCommerce

by smallfishes

Description

Discover how many abandoned carts your store has by recording when people abandon their carts and view trends over time using the built in dashboard and data pages.

How The Plugin Works

The plugin starts recording carts as soon as anyone adds an item to their cart.

The plugin will do as much as possible to associate carts with users so you can see their email address for manual follow up and recovery. Even if the plugin can’t associate the cart with an email address it will at least show the IP address of the cart on the data page.

Each cart starts in the ‘In Progress’ state on the data page. If a customer hasn’t updated their cart for 15 minutes it will then show as ‘Abandoned’. If the shopper comes back and later completes their cart it will change to ‘Recovered’ and be associated with the order.

Where Do I Get Support?

Email me or start a support request on WordPress.org. I can be reached at mike@smallfishanalytics.com.

Installation

Upload the plugin files to the /wp-content/plugins/ directory, or install the plugin through the WordPress plugins screen directly.
Activate the plugin through the ‘Plugins’ screen in WordPress
Go to SFA Abandoned Cart under WooCommerce in the left hand menu of the WordPress dashboard to see your abandoned carts

Screenshots

Abandoned Carts Dashboard
Abandoned Carts Data
Detailed Abandoned Cart Statistics
Top Recovered Products
Top Abandoned Products

Faq

How does the plugin associate carts with users?

If a cart is started by a user that’s logged into your store or logs in at any point after starting the cart the plugin will automatically associate the cart with the user account. On the data page you’ll see the entry for the cart as well as the users name and email address.

If a cart is started by an unknown user the plugin will show the IP address of the associated with the cart. This can be useful in the case that you’re using other software such as chat widgets because you can reference the IP address with the chat sessions.

If a cart is recovered by a user but that user doesn’t create and account the plugin will still create an association with the order and show the name and email address on the cart data page.

Will web crawlers create a bunch of fake carts?

The plugin uses a library to filter out common web crawlers. In the case that the library doesn’t capture the crawler the plugin also has code that is able to look for patterns that indicate a crawler starting a bunch of carts and filter those carts out.

If you think the plugin is filtering carts the wrong way reach out and we’d love to help out.

What about support and features?

We’d love to hear from you! We’re currently looking at ways to better report on abandoned carts as well as starting to work towards the ability to recover carts both via email as well as integrating with other services such as Facebook, Twitter, etc.

Reviews

Abandoned Plugin - never really developed to a good level

By yatgirl on November 11, 2024

This plugin is what I was looking for. A simple reporting plugin for lost carts.

However, it really hasnt been updated or enhanced to any extent in the 6 years since I installed it in 2018. I paid for the pro version in 2018, the pro version also hasnt been developed. In fact, you dont even get notification of any updates to the pro version. In 2023 I asked for an updated version and it took a month to get a working copy, only to find, nothing had changed with the plugin - that I could see.

The time zone in the reports is the time zone (PST) of the developer with no way to change it.

The abandoned cart table is not responsive to different screen sizes. Even in landscape mode on an 11 inch tablet, it is unreadable as the columns do not resize properly, with no way to change this.

This could be a really great little plugin. It is disappointing that this plugin never reached its basic potential and has now essentially been abandoned.

Good plugin and good support!

By schildpaddencentrum on May 21, 2023

An issue with exporting abandoned cart data was expertly resolved.

Excellent plugin / excellent++ support

By jpatricksweeney99 on April 1, 2023

We've been using Small Fish Analytics' Abandoned Cart Reports for Woocommerce for a number of years now and really depend on it. It's an extremely useful and critical tool for our sales people. We recently needed to upgrade to a new server but found some plugin and theme issues (not surprising) including a performance issue with Abandoned Cart Report for Woo. I emailed the developer of Abandoned Carts and the problem was resolved the same day!

Folks, this is a mission critical tool and we received mission critical support from Mike. Highly recommend Small Fish Analytics and the Abandoned Cart Reports plugin!

Great Plugin and Support

By davemiddles on April 1, 2023

I downloaded this plugin a year or so ago and never opened it. I just left it to collect data for me. About a week ago I tried opening it for the first time and it would just send me to an error page.

I made a thread on the support forum and I was promptly contacted by the author with a solution.

The plugin now opens properly, and all my data (from the time I downloaded it) was recorded, even during the time I couldn't open the app.

Awesome plugin, awesome support!

Excellent all around, responsive developer

By rbstern on December 2, 2022

Using this plugin for a busy e-commerce site that typically has thousands of abandoned carts per month. There was a PHP 8.x compatability issue in one of the features, and the performance was lagging for the large number of abandoned cart records we were dealing with. Brought these issues to the developer's attention. He was very open to our feedback, jumped right on the identified issues, solved the bug and tuned up the code to handle larger stores. Great communication along the way, even over a holiday weekend. It can be tough to find quality plugins supported by dedicated developers. Not the case here. Outstanding support for an essential e-commerce plugin.

Was Useful - Now Useless

By broomfish on September 21, 2022

I started with the free version which gave useful information, but quickly upgraded to the paid version to get the extra functions. Using the paid version i was able to see a lot of my abandoned carts were being created in China, which isnt visible in the free version (I only sell to NZ & AUS), so i was able to use the delete function to remove them and get accurate stats to work from. Well worth the US$15. 21/09/2022 Unfortunalty the money_format function was deprecated in a recent php update so the reports are useless now and no replies to requests to fix it on the support email so i wont be renewing the paid version when it is next due.

A must for anyone selling with WordPress

By orangeco on September 2, 2022

I was looking for a lightweight standalone plugin that gave me accurate abandoned cart data. Every other plugin I tried also wanted to try and convert these carts and add-in other functionality, which I don't need as I use Klaviyo to do that for me. However, this plugin from SFA keeps things simple and gives me the data I need. I can see what's being abandoned in just a couple of clicks and sort by Cart, date, quantity or total value. I upgraded to the paid version and Mike, the developer, has been very responsive to my questions. If you sell using WooCommerce, this plugin should be in your Top 5.

Works well most of the time

By phantasmix on May 26, 2020

I like everything except for the fact that it doesn't seem to capture all abandoned carts. Not sure how/why that happens. This is how I know: I spent a few hours watching google analytics real time report and I see people adding stuff and viewing the "basket" page, and then leaving, yet SFA page does not get updated. Using the Premium version of this plugin.

Performance issues, bad table design

By negrusti on February 6, 2020

Major MySQL performance hog from queries like SELECT * FROM wp_sfa_abandoned_carts WHERE customer_key= ? AND cart_is_recovered = ? AND order_id IS NULL LIMIT ? as the table has no proper indexes:

explain wp_sfa_abandoned_carts;
+-----------------------+---------------+------+-----+---------+----------------+
| Field                 | Type          | Null | Key | Default | Extra          |
+-----------------------+---------------+------+-----+---------+----------------+
| id                    | int(11)       | NO   | PRI | NULL    | auto_increment |
| customer_key          | char(32)      | NO   |     | NULL    |                |
| cart_contents         | longtext      | NO   |     | NULL    |                |
| cart_expiry           | bigint(20)    | NO   |     | NULL    |                |
| cart_is_recovered     | tinyint(1)    | NO   |     | NULL    |                |
| ip_address            | char(32)      | YES  |     | NULL    |                |
| item_count            | int(11)       | NO   |     | NULL    |                |
| order_id              | int(11)       | YES  |     | NULL    |                |
| viewed_checkout       | tinyint(1)    | NO   |     | 0       |                |
| show_on_funnel_report | tinyint(1)    | NO   |     | 0       |                |
| cart_total            | decimal(15,2) | YES  |     | NULL    |                |
+-----------------------+---------------+------+-----+---------+----------------+

Just what we needed

By mmyers821 on November 5, 2018

Adding an "abandoned cart" plugin to our online store was an afterthought, but sure glad we did. Our customer base is narrow and we already know most of them, so if they have a problem online we can contact them to assist with their order. We've also become aware of individuals using our site to apparently "test" credit cards. We're not sure why, but the attempts have been continuous and often result in cards over limit, invalid, etc. With the knowledge acquired from the abandoned cart plugin we were able to block the IP of the offender. They can probably get around that, but maybe they will go play somewhere else. This plugin is simple, intuitive, worked right away, and has been completely stress free.

Changelog

2.6.4

Declare support for WordPress 6.1
Declare support for WooCommerce 7.1
Update crawler detection library

2.6.3

Declare support for WordPress 6.0
Declare support for WooCommerce 6.6

2.6.2

Declare support for WordPress 5.5
Declare support for WooCommerce 4.5
Update bot crawler detection software
Fix PHP warning

2.6.1

Declare support for WordPress 5.4
Declare support for WooCommerce 4.2

2.6.0

Delcare support for WordPress 5.2
Declare support for WooCommerce 3.6

2.5.1

Declare support for WordPress 5
Declare support for WooCommerce 3.5
Fix a bug with money_format not being available on Windows hosts
Added additional null check to fix a reported bug
Updated crawler detection code

2.5.0

Added a warning if there are too many carts being returned by the reports

2.4.1

Declare support for WooCommerce version 3.4

2.4.0

Stored cart totals on the cart line for better report performance
Updated crawler detection code

2.3.0

Remove extensions tab

2.2.1

User Request: Changed permissions to allow WooCommerce store managers access to view the reports

2.2.0

Removed the top abandoned and recovered carts tables from the main dashboard
Renamed the data tab to carts
Added a new products tab to show data on abandoned products
Improved styling of the tabs
Improved plugin security

2.1.11

Added a field to the abandoned cart table to determine which carts to show on the funnel report.

2.1.10

Code to track when carts view the checkout

2.1.9

Fix for fields being disabled on the checkout.

2.1.8

Tested and declared support for WordPress 4.8
Added code to track when users view the checkout fields in preparation for adding a funnel report extension
Adjusted the styling a bit to give a white background on the report tabs

2.1.7

Fixed a user reported notice where the date comparison for tables wasn’t using the raw cart expiry time

2.1.6

Refactoring much of the reporting code to prepare for new features.

2.1.5

Quick bug fix for a user reported issue in the report area of the plugin. Thanks bdoga!

2.1.4

Better support for showing meta data about products with variations
Limit the top tables on the dashboard to only 10 items in each
Add extensions tab to the plugin

2.1.3

One more quick fix for a PHP debug notice a user reported.

2.1.2

Quick fix for a PHP debug notice a user reported.

2.1.1

Modify plugin install code to follow best practices.

2.1.0

WooCommerce 3.0 is now supported with backwards compatibility.

2.0.3

The plugin now associates carts with known users when they’re logged in.
The plugin now associates carts with completed orders so you can see who the recovered cart belonged too.
Increased the number of rows on the data page up to 30.
Added new columns on the data page to show the IP or customer name. Email fields are now links.

= 2.0.2=
* Fixed another bug where the wrong currency symbol was showing in the chart

2.0.1

Fixed a bug where the wrong currency symbol was showing in the chart

2.0.0

Released charts on the main page

1.5.0

Moved the plugin from a top level menu under WooCommerce
Added helpful links from the plugins page to get the report data and also email for support
Changed the layout of the plugin to utilize tabs for the report and a premium / help page
Updated crawler detection with latest code

1.4.2

Remove hard coded table name. Doh!

1.4.1

Make sure default report view orders carts from newest to oldest

1.4

Trying to better filter bots. If multiple carts from the same IP are added within 10 seconds the all carts for that IP are now flagged as spam
Updated crawler detection with latest code

1.3

IP address logging
Better querying of data to exclude crawlers that make it passed the crawler detection code
Added button to delete data from the report
Updated crawler detection with latest code

1.2

Cart report no longer shows $0.00 carts
Fixed a minor CSS bug
Refactored code into classes
Updated crawler detection with latest code

1.1

Added sortable grid columns to the report table
Added total cart and amount counters to the report page
Included taxes in the cart reports
Removed text cruft from the report page and replaced with a simple “email us” link
Updated crawler detection with latest code

1.0

Initial Release