Recover Cart [Support Thread]

[bi11i]

1. Why you need seo url in the emails? Search engines do not look at them. You're not surprised by the lack of seo url in the remaining emails of admin - newsletters, notifications, status changes notice, individual emails, etc.

2. The problem of using user Friendly URL in the admin - is a global problem and solved it must be by a seo url developer.

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:77ff19653324db0868353221feb6b9a d

[a_berezin]

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:77ff19653324db0868353221feb6b9a d

OK, now I understand you.

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

[Spartan]

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?

[DrByte]

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

[a_berezin]

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.

[bi11i]

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

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.

[bi11i]

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

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;

  }

[Limitless]

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.p...34#post1144934

[bi11i]

nice. thanks!