Recover Cart [Support Thread]

LibertyFlag:

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

I've the same problem.

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

LibertyFlag:

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:

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

Hello, Just thought I would ask my question again in hopes that someone will be able to assist, here it is:

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.

Camay, Liberty, 100asa

I'm not sure but a Zen Cart bug fix was posted this past summer related to errors such as you all are reporting. Maybe this relates to your issue (or maybe it does not). Search Bug Reports forum area on "foreach()" or something that relates to the error message.

Woody

xlr82quik:

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

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

I have observed the latest RCS mod version having issues with various datetime functions. Just before Andrew disappeared from the Zen Cart scene he added some new mod functionality but bugs were not fully vetted before he went MIA.

I have just decided to live with the issues as I do not have the coding chops to repair.

It indeed may be related to a MySQL and/or PHP version compatibility issue.

Woody

can anyone tell me how to do the patch in admin>patch mysql?

the readme instructions tells me to patch but did not specify how to patch. specific and detailed instructions would be greatly appreciated. I do not know

p.s. how to use MySQL.:frusty:

you mean to paste in and the click send (four times) for each of the following below?:

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

:no:

twi:

you mean to paste in and the click send (four times) for each of the following below?:

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

:no:

open the sql script in your text editor and then select all

copy the entire sql script

paste it into admin -> tools -> install sql patches and press the send button

Thanks
:yes:

This script requires the full processing. I love the idea of the script, but did not like how it is programmed.
Since I am no longer using this release, I have got only two corrections to the above errors.

recover_cart_sales.php
Find:

if ((time()-(RCS_EMAIL_TTL*24*60*60)) <= strtotime($basket->fields['datemodified'])) {

Replace by

if ($basket->fields['datemodified'] != '' && (time()-(RCS_EMAIL_TTL*24*60*60)) <= strtotime($basket->fields['datemodified'])) {

stats_recover_cart_sales.php
Find:

$custlist = '';

Add below

$cust_array = array();

Thanks Andrew for the patch.

To anyone else who wishes to work on improving or fixing bugs in this mod...

Just to report that after a cart is "recovered", in ZC admin under "Reports" > Recovered Sales Results", the "order date" displays correctly but the "date added to SC" and "RC email sent" are incorrect.

I added Andrew's patch but it did not appear to affect/correct this issue. Likely some other datetime functions are either translating the datetime entry incorrectly when being read from the DB or the datetime is incorrectly written to the database.

Also in ZC admin, under "Tools" > "Recover Cart Sales" I observe a few "ghost" entries, that is entries without a customer name attached. And sometimes an entry has no "Cart Total" or "Set Contacted" link or "delete" button associated with it.

Woody

Hi Woody,

Woodymon:

Just to report that after a cart is "recovered", in ZC admin under "Reports" > Recovered Sales Results", the "order date" displays correctly but the "date added to SC" and "RC email sent" are incorrect.
Screenshot please

Woodymon:

Also in ZC admin, under "Tools" > "Recover Cart Sales" I observe a few "ghost" entries, that is entries without a customer name attached. And sometimes an entry has no "Cart Total" or "Set Contacted" link or "delete" button associated with it.
This is an very-very-very old "initial" bug.
Before these records were also, but they showed no script. There are two options:

1. to hide these records
2. remove these records

I would like to suggest some features for this great mod.

• Sort carts by customers/not customers
• Select all carts
• Select all non-customer carts
• differentiate between customer who has abandonded cart with product A and who purchased product B

I really want this functionality and may even pay someone to do it but thought that I would put the ideas out here first.

Otherwise excellent mod.

redmonds:

• Sort carts by customers/not customers

• Select all non-customer carts

I can not understand anything. About what "non-customer carts" you talk? Non-customer cart long live session alive. It is not relevant to the module "Recover Cart", which work only with CUSTOMERS.
You can e-mail me.

I am getting this error at admin->Reports->Recovered Cart Sales..

Warning: Invalid argument supplied for foreach() in /var/www/vhosts/domain.com/httpdocs/cart/admin/stats_recover_cart_sales.php on line **153

Any help would be awesome!

thanks,
buck
**

Buck,

Check post #199 from Andrew. I had the same error and his suggestion fixed it for me.

Thanks Andrew!

Fixed - Did it for Me, Yeehaw!
JOhn ><>

Jim & Andrew
Thanks a lot! Worked perfectly

buck

I have installed the sql patch. Had to adjust some of the table names as my store was installed with prefix "store" so for instance, "configuration_group" is "storeconfiguration_group" in my database. Created all sorts of fun in the sql statement, but it completed successfully, so hopefully it's all right.

I've uploaded the files without error. I see a CONFIGURATION > RECOVER CART SALES area and can set options.

Here's the rub. Under TOOLS I have nothing related to recover cart.

Suggestions? Did I miss some adjustment in the sql statement?