Recover Cart [Support Thread]

[Einstin]

Looks like this was one that was last modified by Andrew. I'll give it a shot today and report back.

Manually removed the old Recover Cart Sales 1.5.1 that was from the downloads section and dropped the existing scart table from the database and did a clean installation with the one from the above post. Everything worked like a charm! HTML emails are clean and the reports look good as well. Emails were successfully sent as well using 2 test shoppers.

No files were over written during the install but I noticed a backup file in the zip archive that I didn't include in the upload at

\admin\includes\extra_datafiles\recover_cart_filenames.php.bak

My current configuration is as follows;

ZenCart v1.3.7 (fresh install)
FreeBSD 6.1
PHP 5.2.2 (Zend 2.2.0)
MySQL 4.0.24
Apache 1.3.37
Email using smtp auth.

Hope this helps others get there mod working.

[poldy]

Thanks gabbytwin,

just tested the mod u posted.
works perfectly.

is there any way to put it into the download section.

poldy

[jikey]

sound greats... but must uninstalled the old 1 ?

[Einstin]

sound greats... but must uninstalled the old 1 ?

I did but mainly because I had so much trouble getting the other one to work. Also, make sure you drop the old scart table from the db. Some ftp clients also will not over write the old file if it has a newer date than the one you are trying to upload. Depends on your ftp client and how you have it set. I also used the install sql patch patch method instead of uploading the sql file.

I have also made a copy of the zip file available at
http://www.wicca-mart.com/public/recovercart.zip

[gabbytwin]

Glad the copy I had help everyone out !
I was worried it might of been the wrong one.

[Woodymon]

Glad the copy I had help everyone out !
I was worried it might of been the wrong one.

I have last known version released by Andrew which I am running on Zen Cart v.1.37. Files were updated by Andrew on Apr 30, 2007 and sql patch updated on May 03, 2007.

This version of RCS has some additional functionality not in some previous versions. Unfortunately Andrew did not update the ID strings or version numbers in his more recent RCS updates so it is not possible to identify this latest version by version number.

The mod has no readme. When I have a moment I'll create a simple readme and upload to ZC downloads area.

I might just call it version 3.0 to start fresh, and then hopefully a ZC developer out there can pick up and continue developing it.

Woody

[Einstin]

I have last known version released by Andrew which I am running on Zen Cart v.1.37. Files were updated by Andrew on Apr 30, 2007 and sql patch updated on May 03, 2007.

This version of RCS has some additional functionality not in some previous versions. Unfortunately Andrew did not update the ID strings or version numbers in his more recent RCS updates so it is not possible to identify this latest version by version number.

The mod has no readme. When I have a moment I'll create a simple readme and upload to ZC downloads area.

I might just call it version 3.0 to start fresh, and then hopefully a ZC developer out there can pick up and continue developing it.

Woody

Woody;
Can you either post that somewhere that I can get a copy or perhaps send it to me? The one I have that was apparently Andrews has the sql dated 12/18/2006.

[Woodymon]

I have just completed the readme. Please let me know if any corrections required. (I am not including the mod history here but will be in readme).

And will be repackaging the mod and uploading soon. Probably won't get listed in ZC downloads area until Monday.

Woody

----------------

Recover Cart Sales (RCS) for Zen Cart

======================
MOD VERSION: v.3.0
======================
Last updated: 05-03-07
Readme generated: 08-11-07

=================
ZEN CART VERSION:
=================
Known to run on Zen Cart v.1.37
(this mod version may run on other Zen Cart versions but untested)

=============
AUTHORS:
=============
Too many too list here. See mod history below.

=============
SUPPORT:
=============
In Zen Cart Support Forum
http://www.zen-cart.com/forum/showthread.php?t=37128

=================
DOWNLOAD:
=================
From Zen Cart support forum downloads area.
See support thread for URL.

=============
DESCRIPTION:
=============
Recover Cart Sales Tool is an admin utility for Zen Cart allowing merchants to send individual or bulk email messages to customers whom have set up a shop account and have added items to their shopping cart, but for various reasons did not complete submitting an order (known as an 'abandoned cart'). The tool also provides a report which presents the "possible" response to your email, informing you if customer followed up with a purchase from your shop. The email sent to these customers may help educate your customers and also for merchant to learn about trends and individual reasons behind abandoned carts. Use this tool diligently. Compose your email message carefully. Don't burden your customers with undesirable repeat messages. The idea here is to "recover" sales and reduce abandoned carts, not lose customers.

=============
FILES:
=============
/YOUR_admin/recover_cart_sales.php
/YOUR_admin/stats_recover_cart_sales.php
/YOUR_admin/includes/boxes/extra_boxes/recover_cart_reports_dhtml.php
/YOUR_admin/includes/boxes/extra_boxes/recover_cart_tools_dhtml.php
/YOUR_admin/includes/extra_datafiles/recover_cart_filenames.php
/YOUR_admin/includes/languages/english/recover_cart_sales.php
/YOUR_admin/includes/languages/english/stats_recover_cart_sales.php
/YOUR_admin/includes/languages/english/extra_definitions/recover_cart.php

================
DATABASE CHANGE:
================
install.sql
- creates 'scart' db table
- inserts ZC Admin menu entries (see below)

UPGRADERS NOTE: The sql patch will drop the 'scart' table so all old RCS data is removed. If you want to save data be sure to backup 'scart' table before patching.

'scart' table structure:
scartid int(11) NOT NULL auto_increment,
customers_id int(11) NOT NULL default '0',
dateadded varchar(8) NOT NULL default '',
datemodified varchar(8) NOT NULL default '',

=============
INSTALL:
=============
1. Patch database via Tools > Install SQL patches
Best to paste in sql code, not upload.
Or patch via phpmyadmin.

2. Upload mod files to your Zen Cart "admin" directory (how ever you have it named).

3. Three new menus should display in ZC admin:
Configuration > Recover Cart Sales
Tools > Recover Cart Sales
Reports > Recovered Sales Results

=============
CONFIGURE:
=============
1. Configuration > Recover Cart Sales:
Configure RCS mod

Latest version (v. 3.0) settings:

Look back days
Sales Results Report days
E-Mail time to live 90
Friendly E-Mails true/false
E-Mail Copies to
Show Attributes true/false
Ignore Customers with Sessions true/false
Current Customer Color 0000FF
Uncontacted hilight color 80FFFF
Contacted hilight color FF9FA2
Matching Order Hilight 9FFF22
Skip Carts w/Matched Orders true/false
Autocheck "safe" carts to email true/false
Match orders from any date true/false
Lowest Pending sales status Pending [1]
Report Even Row Style dataTableRow
Report Odd Row Style


=============
MOD USAGE:
=============
1. Tools > Recover Cart Sales:
Search for carts to "recover" and compose/send individual/bulk email to customers

(note this page may display Recover Cart Sales "2.01"... this is incorrect - define needs update)

After configuring RCS in usage step one above:

a. Search your shop database for registered customers whom still have items in their shopping cart. (first set the number of days you want to search back)
b. Entires will appear as "uncontacted" and "previously contacted by RCS"
c. Check the customers you want to send a bulk RCS email
d. Compose the body of the bulk email you will send to customers
e. Set an appropriate subject and shop email address
f. Send email

NOTE: Before sending bulk messgae, best to create a test account, add item to shopping cart (don't order) then select ONLY your "uncontacted" email address to send you a test RCS message. Then view the message to ensure the results are as desired.


2. Reports > Recovered Sales Results:
Display report of results of RCS email (that is, did customers return to your shop and buy?)

a. Select the number of days to show.

b. Shop database will be searched and following info presented in the report:

Examined Records:
Recovered Sales:
(Possible sales from customers who abanoned carts & were notified via RCS)

For each "recovered sale" the report will display:
SCart ID
Date Added to SC
RC email sent
Customer Name
Order Date
Status
Amount


=============
MAINTENANCE:
=============
Occassionally flush out your scart db table (via phpmyadmin). Be sure to check your uncontacted/contacted list and RCS report before flushing.


========================================
COMMON KNOWN ISSUES:
========================================
• Supports sending text email only, not HTML. Sent message is based on Zen Cart email template.
• When a customer with an abandoned cart is deleted drom Zen Cart, sometimes the cart can still stick around in the database, and then RCS reports the cart data without connecting it to a customer. And then you cannot clear the item from the RCS report. Possibly only impacts upgraders (Zen Cart and/or mod). If this occurs flushing your 'scart' db table (via phpmyadmin) is recommended.
• RCS sometimes reports incorrect dates in report. If you have solutions please post to support forum.

=============
HISTORY:
=============
{snipped}

Errors are my own ;-)

[Woodymon]

Updated RCS v.3.00 (with readme) has been uploaded to the Zen Cart downloads area. Should be available in a day or so. Special thanks goes to the original developers, and to Merlin and Andrew. Please donate to the Zen Cart team. Thanks!

Woody

[Woodymon]

Did I say a day or so? How about an hour or less!

RCS 3.0 is now available for downloading at:
http://www.zen-cart.com/index.php?ma...roducts_id=100