jikey:

um i hav same problem ... :S

I am also having the problem with emails not getting sent
Any help anyone.
Does someone maybe have a zipped copy of the good one on their hard drive somewhere?

hmm, found a copy on my hard drive called recovercart.zip it doesnt have any install notes or instructuons in the zip. was wondering if this might be the one that we need that works.
Was downloaded back in march 2007.....

If its not right let me know, so that no one else gets their hopes up

gabbytwin:

hmm, found a copy on my hard drive called recovercart.zip it doesnt have any install notes or instructuons in the zip. was wondering if this might be the one that we need that works.
Was downloaded back in march 2007.....

If its not right let me know, so that no one else gets their hopes up

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

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.

:smile: Thanks gabbytwin,

just tested the mod u posted.
works perfectly.

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

poldy

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

jikey:

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

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

gabbytwin:

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

Woodymon:

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.

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 ;-)

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

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?main_page=product_contrib_info&cPath=40_41&products_id=100

I think I have found a bug in this mod. I have tried the same scenario in both the so called 2.01 version and also in Woody's newly posted 3.0 version.

Scenario:
Customer logs in and creates a cart and then abandon's.
Admin runs recover cart mod and sends customer email.
Mod marks customer as contacted and enters info into the scart table.
Some time later the same customer comes back and logs in but empties the cart and makes a new one and again leaves the cart.
Admin runs mod again and this time the new cart shows up but appears with the new content and the mod shows the customer as already being contacted. The contact date even shows as being before the new cart was created!

I have also tried this same scenario but with the cart being deleted from the admin side of the mod but since the cart is deleted and the scart data isn't the customer always appears to be already contacted!

Einstin:

I think I have found a bug in this mod. I have tried the same scenario in both the so called 2.01 version and also in Woody's newly posted 3.0 version.
Just to be clear, v.3.0 is not my mod. It was last updated by Andrew, whom is no longer around. I just reuploaded with a readme attached abnd a new version number (as there was confusion with previous mod versions/version numbers).

Hopefully a developer with knowledge in resolving above issues can help fix.

Woody

Woodymon:

Just to be clear, v.3.0 is not my mod. It was last updated by Andrew, whom is no longer around. I just reuploaded with a readme attached abnd a new version number (as there was confusion with previous mod versions/version numbers).

Hopefully a developer with knowledge in resolving above issues can help fix.

Woody

Sorry Woody, I knew you were just reposting and adding info to it. Guess I should have worded that slightly different.

:oops:

Einstin:

Sorry Woody, I knew you were just reposting and adding info to it. Guess I should have worded that slightly different.
That's ok. I just didn't want anyone to think I was pretending to be a "developer". :wink2:

I can hack the code but not much more than that.

BTW I just sent out a solid block of RCS messages today with the v3.0 mod.

Here is a bit of a review...

I see now that I forgot to include some instructions on customizing the email RCS sends out.

Without going into it too deep right now you have to edit a few of the defines in /YOUR_admin/includes/languages/english/recover_cart_sales.php.

And very importantly I discovered missing apostrophe's and quotations near the end of the EMAIL_TEXT_BODY_FOOTER define.

Last line should be:

 
'improve the ' . STORE_NAME . ' website. ' . "\n\n" . 'Sincerely,' . "\n\n");

Also in the body of your message content be sure to 'escape' any apostrophe's or quote marks.

As suggested in the readme, be sure to test sending one RCS message to yourself before sending out messages in bulk. If the RCS page does not refresh correctly look in your webserver error log to identify the line number where you may have a bad edit.

If I have time I will upload a copy of my customized defines in this file.

Also I observed some peculiar but not damaging behaviors with the RCS mod when sending out too many messages at one time. The max appears to be around 200 messages. When it max's out the RCS page does not refresh correctly (blank page). But no worry, just refresh the browser and all is well. You will observe 200 messages were sent out and the rest will still show uncontacted. So just click the send mail button again to send out the remaining "uncontacted" entries. So this issue is not a big deal at all. And sending 200 messages at a time is a lot and it is good the mod limits the message volume. Some webhost providers may not be fond of you sending out so many emails at one time so best to distribute sending them over time.

Another issue I noted (as stated in readme) is the "contacted" dates displayed in the RCS page (from the Tools menu ) are incorrect. For example the messages I sent today display the contacted date shows 12/08/2036 not 08/13/2007. So I suspect a database data type issue or some strange offset is being applied. Also similar date issues effects "dated added to SC" and "RC email sent" date columns in the RCS report. I'll take a look at both the code and the database tomorrow and see if I can locate issue. If someone has some hints or is able to correct the code before can get to it please do post your proposed solutions :wink2"

Also I noticed a few "orphaned" entries in the uncontacted/contacted listing (Tools menu) without a customer attached. I can easily delete these entries, and when I do the stack message at the top of the page confirms the deletion and indeed shows the item to be connected to a valid account including customer ID and name. So not sure why the account name is not displaying properly on the uncontacted/contacted listing.

And finally a wishlist item is to be able to sort the uncontacted/contacted listing and also sort the listings on the report.

Also it appears the mod was updated by Andrew to support sending HTML email. But I did not test that feature. Call me oldskool but the shops I like to work on support text mail only. Makes for much easier support if you know what I mean

So all and all the updated RCS mod is a very good utility for your toolbox and the feature additions Andrew coded into the mod this last spring were very helpful. Thanks Andrew, wherever you may be.

Woody

Follow-up on the strange behavior observed with latest version of Recover Cart Sales mod...

I discovered the "orphaned" entries on /admin//recover_cart_sales.php, those entires which I previously reported had no customer account attached, are entries for customers where a cart/sale was "recovered".

After a recovered cart sale is made it appears the current version of the mod (latest from Andrew and uploaded by me) is corrupting the associated entry on the above page and then also is not posting the recovered sale to the report on /admin/stats_recover_cart_sales.php

Older versions of the mod which I ran on Zen Cart 1.37 did not show this behavior.

May be related to other "date" issues I previously posted to this thread. And to Einstin's post above. If anyone has ideas to correct please post.

However this issue does not reduce the usefulness of the mod in delivering "help" messages to customers with abandoned carts. As previous, I observed a positive response (sales and thank yous) from sending my latest RCS message to customers.

Woody

Hello, I just upgraded from the old version or recover cart sales to the new version of recover cart sales version and I am using zen cart 1.3.7 and PHP Version 5.05 and MySQL Version 5.0.27 and I am getting the following error message:

Warning: strtotime() [function.strtotime]: Called with an empty time parameter. in /home/MYUSERNAME/public_html/admin/recover_cart_sales.php on line 381

Besides all the errors it appears that the program is working since under all the errors I see all the customers and their abandoned carts.

The error message goes away after I contact the customer, so the error only shows on uncontacted customers.

I hope someone can please help me.

Thank you.

I have two sites using Recover Cart 3 {BTW: BRAVO for this mod} installed yesterday. Both sites have identical mods & upgrades.
ZenCart 1.3.7 with patches
MySQL 5.?
Php 4.??

One www.liberty-flag.com works Perfectly, Thank You!

Second site www.bulklights.com sends duplicate identical eMails

Any idea where this is coming from or how to fix it?

Thanks again for the nice mod.
JOhn ><>