3/31/20 - I no longer use Opencart, so it's unlikely I'll continue to maintain this extension. You are free to continue using it or fork it, if you wish to take ownership of maintenance. If you do, please adhere to the license.
- OCMOD install
- No technical skill required
- No configuration; it works it's magic behind the scenes
Shop owners that utilize one page checkout extensions on the Open Cart platform will find a lot of "ghost orders" or "missing orders" in their system; such records aren't immediately an issue, until you begin utilizing an extension such as Abandoned Carts Recovery
-- then you start to realize the scale of which these unnecessary entries cover your system.
How to Spot Them
While utilizing something like Abandoned Carts, you'll see a lot of "duplicate" records for a user's IP address, that aren't tied to anything else, begin to surface. This is because one page checkout extensions load asynchronously for field validation to retain the "one page" seamlessness.
A 'template' is created anytime a user lands on the checkout page and waits for user interaction. If the user leaves to continue shopping, another record will be created once they return. Even if the user bails and never enters any information; the template record is still created and waits for user input.
You can also spot them by going into a database management tool like phpmyadmin and sorting your orders table alphabetically by first or lastname.
Why they May be An Issue
If you have a busy store, these records can build tremendous bloat in your database. Chances are, they will never be called upon so think of it as having thousands, if not millions - of redundant products in your shopping cart system.
Benefits to Getting Rid of Them
How to Use It
- The size of your database will shrink; when you do your nightly or weekly backups, the time it takes to compress and get a local copy of the database will shrink drastically.
- Less is more; the less (useless) records a system has, the less resource usage and work it has to do to sift through and find what it's looking for. Improvements would be most noticeable on large and busy stores.
Because this extension modifies your database, PLEASE backup your database before you install it. Although it's been tested, you'll want a backup of your shop's database in the event something goes wrong (other extensions colliding are a distinct possibility).
There is no configuration. Install the extension, refresh your modifications cache and log out (then log back in).
The extension will begin it's clean up duties behind the scenes.
The deletions are set to only delete records that are at least 1 day old and must also meet the criteria of both a blank first & last name (which is indicative that the record was created by the one page checkout addon); to ensure no other statuses or potentially legitimate transactions get caught.
The extension will continue to look for new deletions anytime an admin creates a new login session; no interaction is ever required.
If you would like to view the source of this extension, see it on Github
To submit bugs or enhancement requests, please open an issue on Github