Recover Cart [Support Thread]

[kelvyn]

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.

ADMIN>TOOLS>INSTALL SQL PATCHES - paste the code and then press SEND!
(backup first!)

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

[clydejones]

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

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

[twi]

Thanks

[a_berezin]

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

[Woodymon]

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

[a_berezin]

Hi Woody,

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

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