Recover Cart [Support Thread]

[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.

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!

[Woodymon]

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

[Einstin]

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.

[Woodymon]

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".

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

[Woodymon]

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

[xlr82quik]

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.

[Stuff4Toys]

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

[Stuff4Toys]

Second site www.bulklights.com sends duplicate identical eMails

Duh - My fault!

New problem:
The Recover Cart Report, in the header for the "Amount" Column has this!

Amount
Warning: Invalid argument supplied for foreach() in /Path_To_Admin/stats_recover_cart_sales.php on line 153

I looked at line 151-154 and it has:

<?php
//echo '<pre>';var_export($cust_array);echo '</pre>';
           foreach($cust_array as $cust) {
?>

Don't have a clue what I am looking at. Any help? The Recover Cart is working, withing 3 hours of sending out eMails, I gor one customer back already.
JOhn ><>

[100asa]

I've the same problem.

[camay123]

Samne thing here. This happens when I use the recover cart under reports. When I use the one under tools, I get no error.

Duh - My fault!

New problem:
The Recover Cart Report, in the header for the "Amount" Column has this!

Amount
Warning: Invalid argument supplied for foreach() in /Path_To_Admin/stats_recover_cart_sales.php on line 153

I looked at line 151-154 and it has:

<?php
//echo '<pre>';var_export($cust_array);echo '</pre>';
           foreach($cust_array as $cust) {
?>

Don't have a clue what I am looking at. Any help? The Recover Cart is working, withing 3 hours of sending out eMails, I gor one customer back already.
JOhn ><>