Recover Cart [Support Thread]

bi11i:

You're right and I should have used different terminology. I guess what I was after was displaying the URL's in the email as the link using the title of the product, rather than just displaying the URL itself.

displaying this: Mimosa hostilis (Jurema) Brazilian Purple Pink Inner Root Bark - Powdered

rather than this: https://www.phytoextractum.com/index.php?main_page=product_info&products_id=141:77ff19653324db0868353221feb6b9ad

OK, now I understand you.

well, so now that we are in an understanding, is there an easy way for me to make this happen, at least on my own end? thanks and i appreciate your help!

ak6000:

Thanks for your reply DecoStyle. Per your recommendation, I checked the cache folder and find out the 'scart' db table did not exist.

Since I was upgraded from v1.3.9 I used the Upgrade sql patch, but apparently I needed to use Install instead!

So I used the install-ZC-v-1-5.sql and everything is working.

I am having the same issue, however, I did not upgrade from 1.3.9, and I am trying to run the Install-ZC-v-1-5.sql.
[I did copy over my database from 1.3.8, but did not have this mod installed - I did have Keepcart, in case that was related.]

I get the same error, but here is my log:

PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1 :: CREATE TABLE zen_scart ( 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 '', PRIMARY KEY (scartid), UNIQUE KEY customers_id (customers_id), UNIQUE KEY scartid (scartid) ) TYPE=MyISAM; in /home/spartan1/public_html/shop/includes/classes/db/mysql/query_factory.php on line 101

I notice that the SQL says "CREATE TABLE scart", where the log says "CREATE TABLE zen_scart".
I dont know if that is somehow a problem.

Any ideas as to the problem here?

Should I try to run the Upgrade sql?

"TYPE=MyISAM" should be "ENGINE=MyISAM" in modern versions of MySQL.

bi11i:

well, so now that we are in an understanding, is there an easy way for me to make this happen, at least on my own end? thanks and i appreciate your help!
find

$mline .= '   <blockquote><a href="' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. $basket->fields['products_id']) . '">' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. $basket->fields['products_id']) . "</a></blockquote>\n\n";

replace by

$mline .= '   <blockquote><a href="' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. $basket->fields['products_id']) . '">' . $products->fields['name'] . "</a></blockquote>\n\n";

New case you have problems with the plain-text mail.

a_berezin:

find

$mline .= ' <blockquote><a href="' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. $basket->fields['products_id']) . '">' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. $basket->fields['products_id']) . "</a></blockquote>\n\n";

> replace by
> ```php
$mline .= '   <blockquote><a href="' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. $basket->fields['products_id']) . '">' . $products->fields['name'] . "</a></blockquote>\n\n";

thanks, that's awesome and looks much better. would there be an easy way to

1. turn off plain-text mails?
2. change the email content to remove the duplicate content

1 x Mimosa hostilis (Jurema) Purple Pink Root Bark - Powdered
Mimosa hostilis (Jurema) Purple Pink Root Bark - Powdered

thanks for being so helpful.

did you ever get this working? running this as a cron every x days at x time would be pretty sweet.

tmdelia:

Does anyone have a working CRON script for this? I had one, but it just quit working. And I can't for the life of me remember where it came from.

Here's my Cron:

cd "/home/fakedir/public_html/fakeadmin/" php -f ./rcs_cron.php -- rcs_cron=1

Using fakedir and fakeadmin to be safe, but I assure you, the paths are correct.

Here is the script I have in the admin folder:

<?php /** RECOVER CART SALES -- AUTOMATED SCRIPT FOR CRON PROCESSING * * Proper use: * ----------- * php -f ./rcs_cron.php -- rcs-cron=1 [tdate=x] * * where [tdate=x] is an optional parameter, with x being the number of days (history) you wish to process for. * * NOTE: it's expected that you will run this script from inside the admin folder. * (ie: chdir to admin folder, then run this script) */ // process command-line vars into GET vars: if ($argc > 0) { for ($i=1; $i<$argc; $i++) { $it = split("=", $argv[$i]); $_GET[$it[0]] = $it[1]; } } // Check whether has been started with required parameters: if (!isset($_GET['rcs_cron'])) { echo "\n Recover Cart Sales (RCS) \n Automated processing script\n ===========================\n Proper use:\n -----------\n php -f ./rcs_cron.php -- rcs-cron=1 [tdate=x]\n\n where [tdate=x] is an optional parameter, with x being the number of days (history) you wish to process for.\n NOTE: it's expected that you will run this script from inside the admin folder.\n\n\n"; exit(); } // set some prerequisites: define('RCS_CRON_USERID', 100); $tdate = (isset($_GET['tdate'])) ? $_GET['tdate'] : ''; // load the Zen Cart core: require('includes/application_top.php'); require(DIR_WS_LANGUAGES . $_SESSION['language'] . '/' . FILENAME_MAIL . '.php'); require(DIR_WS_LANGUAGES . $_SESSION['language'] . '/recover_cart_sales.php'); require(DIR_WS_CLASSES . 'currencies.php'); $currencies = new currencies(); // begin RCS processing: echo 'RCS processing for date range: past ' . ($tdate != '' ? $tdate : RCS_BASE_DAYS) . ' days.' . "\n"; doUnattendedRCS($tdate); echo 'Finished.' . "\n\n"; ``` > > I also found this bit of code in my fakeadmin/includes/init_includes/overrides/init_admin_auth.php and don't know if it is what is causing the prob: > > ``` if (!isset($_SESSION['admin_id']) && $_GET['rcs_cron'] == 1 && defined('RCS_CRON_USERID')) { $_SESSION['admin_id'] = RCS_CRON_USERID; $bypass_additional_auth = true; } ```

I just documented what I did for auto-cron on the Back in Stock Notifications.

Shouldn't take much to figure out what needs to be changed for this mod too.

http://www.zen-cart.com/showthread.php?181440-Ceon-Back-In-Stock-Notifications-3-0-0&p=1144934#post1144934

nice. thanks!

bi11i:

would there be an easy way to

1. turn off plain-text mails?
   Correct to create content for the text version separately, and separately for html-version. But these changes in the two lines do not fit.

bi11i:

would there be an easy way to
2. change the email content to remove the duplicate content

$mline .= $basket->fields['customers_basket_quantity'] . ' x ' . $products->fields['name'] . "\n";
$mline .= '   <blockquote><a href="' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. $basket->fields['products_id']) . '">' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. $basket->fields['products_id']) . "</a></blockquote>\n\n";

replace by

$mline .= $basket->fields['customers_basket_quantity'] . ' x ' . '<a href="' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. $basket->fields['products_id']) . '">' . $products->fields['name'] . '</a>' . "\n";

Hi,
I've installed this mod with no problems (sort of...more on that in a minute). The mod works, in that it picks up abandoned carts...I've amended the PHP to show friendly URLs (from Ceon) and changed the wording to suit my shop. I can send emails OK and, from this perspective, all is well. However.....
Under Configuration>Configure RCS there are NO options listed - just headings, i.e. "Title Value Action"
I ran the SQL install for ZC1.5.0 (my site was a clean 1.5 install, although now heavily modified)...and I've checked three times that all six files are where they should be. I've just compared the actual content against the original files and all is as it should be. I'm at a bit of a loss...any bright ideas - about either a) what's wrong or b) what I've done wrong?

Cheers,
Gavin

Hi,

Just installed this mod but I get an error when trying to install the sql patch. I installed v1.5 as a clean install so I did not use the upgrade patch.

Any ideas as to why I am getting an error message.

coucho:

Hi,

Just installed this mod but I get an error when trying to install the sql patch. I installed v1.5 as a clean install so I did not use the upgrade patch.

Any ideas as to why I am getting an error message.

You didn't post the error you were having so I'm assuming it's this here.
Probably the sql statement. Change the TYPE=MyISAM' to ENGINE=MyISAM and the problem may go away.

countrycharm:

You didn't post the error you were having so I'm assuming it's this here.
Probably the sql statement. Change the TYPE=MyISAM' to ENGINE=MyISAM and the problem may go away.

Yep changing TYPE to ENGINE did the trick.

Thanks!

Hi again,
I'd already changed 'TYPE' to 'ENGINE'...but I still see no configuration values!
:-(

gavwright:

Hi again,
I'd already changed 'TYPE' to 'ENGINE'...but I still see no configuration values!
:-(

Uninstall and install the sql statement again to see if that resolves your problem.

Thanks for your input - sorry if I'm being thick...but how do I uninstall, as there isn't an uninstall SQL file?

Just in case this is what you meant, I renamed all six files (I don't use Russian...) and then ran the install SQL again. I then renamed the six files to what they should be. Still no configuration values...

gavwright:

Thanks for your input - sorry if I'm being thick...but how do I uninstall, as there isn't an uninstall SQL file?

Just in case this is what you meant, I renamed all six files (I don't use Russian...) and then ran the install SQL again. I then renamed the six files to what they should be. Still no configuration values...

Run this uninstall statement I provided for you. Before you go about renaming the file you need to make sure everything installs right first.

DROP TABLE IF EXISTS scart;
DELETE FROM admin_pages WHERE page_key='config_recover_cart_sales';
DELETE FROM admin_pages WHERE page_key='recover_cart_sales';
DELETE FROM admin_pages WHERE page_key='stats_recover_cart_sales';

Check your PM

Works a treat - thanks :-)

ma.r.a:

Hi! Please:

1054 Unknown column 's.datemodified' in 'field list'
in:
[SELECT s.scartid, s.customers_id, s.dateadded, s.datemodified, c.customers_firstname, c.customers_lastname, c.customers_email_address FROM scart s LEFT JOIN customers c ON (s.customers_id = c.customers_id) WHERE dateadded >= '19700101' ORDER BY dateadded DESC]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

What's it?:(

I have this message as well, installed this mod last night on v1.3.9h. I couldn't find a reply to this query back in 2009.
What does it mean?
Does it change if there is an abandoned order?
???