Recover Cart [Support Thread]

DrByte:

Hmmm ... I did some more digging, and I see now that it's trying to combine the name<email> into one parameter, but would be better letting the application do that properly.
I wonder if the following rewrite to that section may be helpful:

    $custname = $basket->fields['fname']." ".$basket->fields['lname'];
    $outEmailAddr = '"' . $custname . '" <' . $basket->fields['email'] . '>';

[strike] if( zen_not_null(RCS_EMAIL_COPIES_TO) )[/strike]
[strike] $outEmailAddr .= ', ' . RCS_EMAIL_COPIES_TO;[/strike]

    $html_msg['EMAIL_MESSAGE_HTML'] = nl2br($email) . zen_db_prepare_input($_POST['message_html']);
    $email = strip_tags($email . "\n\n" . zen_db_prepare_input($_POST['message']));
    $from = zen_db_prepare_input($_POST['from']); // STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS
    $subject = zen_db_prepare_input($_POST['subject']); // EMAIL_TEXT_SUBJECT

zen_mail('', $outEmailAddr, $subject, $email, '', $from, $html_msg);

> to
> ```
        $custname = $basket->fields['fname']." ".$basket->fields['lname'];        $outEmailAddr = '"' . $custname . '" <' . $basket->fields['email'] . '>';
        $html_msg['EMAIL_MESSAGE_HTML'] = nl2br($email) . zen_db_prepare_input($_POST['message_html']);
        $email = strip_tags($email . "\n\n" . zen_db_prepare_input($_POST['message']));
        $from = zen_db_prepare_input($_POST['from']); // STORE_OWNER . ' <' . STORE_OWNER_EMAIL_ADDRESS . '>'
        $subject = zen_db_prepare_input($_POST['subject']); // EMAIL_TEXT_SUBJECT
        zen_mail($custname, $basket->fields['email'], $subject, $email, STORE_NAME, STORE_OWNER_EMAIL_ADDRESS, $html_msg);
        if (zen_not_null(RCS_EMAIL_COPIES_TO)) {
          zen_mail('', RCS_EMAIL_COPIES_TO, $subject, $email, STORE_NAME, STORE_OWNER_EMAIL_ADDRESS, $html_msg);
        }

That worked.

I'm having the weirdest error happen. This module has worked great for years and now it's giving the error "WARNING: An Error occurred, please refresh the page and try again." Is there any reason this would randomly happen? No changes has been made to the site as far as I'm aware. We just did out quarterly PCI compliance, surely that doesn't have anything to do with it.

CSGODeimos:

I'm having the weirdest error happen. This module has worked great for years and now it's giving the error "WARNING: An Error occurred, please refresh the page and try again." Is there any reason this would randomly happen? No changes has been made to the site as far as I'm aware. We just did out quarterly PCI compliance, surely that doesn't have anything to do with it.

Check your error logs folder. What version of PHP are you using?

jeking:

Check your error logs folder. What version of PHP are you using?

Turns out a PCI scanner created a customer and did something weird which caused the module to fail. We deleted their customer account and it's back to normal.

Is this module actually compatible with 1.5.5e? I haven't been able to install the sql patch. I can't install it from admin patches because I get a 500 Internal error and I can't install it from phpadmin because it says:

#1048 - Column 'configuration_group_id' cannot be null

I haven't seen any real solution to the problem here, has anyone installed it successfully on 1.5.5e?

Add. Info:
PHP Version: 5.6.30 (Zend: 2.6.0)
Database: MySQL 5.6.35

Did you do a Copy & Paste or upload file?

If a previous install attempt went bad then suggest you upload the "uninstall.sql" file (and hopefully there is one) to remove any partial install of the module. Disregard any error msgs. from the uninstall. Then use the upload sql method and start fresh. If you still get an error msg. then contact your Hoster as odds are a Server Firewall rule is blocking your attempt and they can white-list the rule for your Hosting account.

Website Rob:

Did you do a Copy & Paste or upload file?

If a previous install attempt went bad then suggest you upload the "uninstall.sql" file (and hopefully there is one) to remove any partial install of the module. Disregard any error msgs. from the uninstall. Then use the upload sql method and start fresh. If you still get an error msg. then contact your Hoster as odds are a Server Firewall rule is blocking your attempt and they can white-list the rule for your Hosting account.

Copy+Paste

WOW! :ohmy: We are always told not to do uploads.

Thanks!

Things changed somewhere around the 1.5.5 and up versions so that the DB_PREFIX was properly included in an sql file upload, and it now works the way it should.

Now, as per the readme file (and I remember long time ago I installed this mod on a 1.3.9 store) the Tools > Recover Cart Sales doesn't appear. I only have the Configuration > Configure RCS, a Customers > Abandoned Carts and a Reports > Recover Cart Sales Report

I'm missing a page. :mellow:

Nevermind, I figured it out!

For ZC v1.5 and up one must use RCS v4.0.1 which includes an "upgrade.sql". Didn't read the whole upgrade process though.

The latest upgrade on the Plugins section says:

Moved the list of Abandoned Carts to the Customers menu instead of the Tools menu.
Fixed some inconsistencies in language strings and table headings.

Wasn't aware current version is 4.0.3 and suggest you follow whatever the Readme states.

Hi, I downloaded the plugin and I am indeed seeing quite a few entries and I love being able to see them.

When I go to "Customers" tab and click the "Abandoned Cart" link, it seems to be displaying everything, but is there a way to display it by date? Here is an excerpt of what I'm getting:
1 09/19/2017
2 08/28/2017
3 09/19/2017
4 09/20/2017
5 08/23/2017
6 08/27/2017
7 09/02/2017
8 09/12/2017
9 09/22/2017

There does not seem to be any order except the number under "Uncontacted" which, right now, are all checked.

This would make WAY more sense to me if it was in DATE order with the latest (newest) stuff on top.

Is there some configuration or something that will allow what I need?

Thanks,

Ray

Never noticed the previous question...

Change

ORDER BY cb.customers_id ASC, cb.customers_basket_date_added DESC");

to

ORDER BY cb.customers_basket_date_added DESC");

I apologize if this has been answered already. I searched but did not find the same issue. Everything works great except the product links sent in the email are incomplete. They only show the URL after the main domain. Thank you for any assistance.

For example
1 x USB Rechargeable Beanie Headlight, Black

/magnification-lighting/flashlights/usb-rechargeable-beanie-headlight-black

I have the same problem **ideasgirl **was posting about. I had installed a copy of this years ago on an old 1.3?? cart. Since then, I've updated my cart by starting with a completely new file set/template and upgraded the database. I'm trying to reinstall this mod, but am missing the Customers> Abandoned Carts menu. Also, when I try to populate Reports>Recovered Sales Results no abandoned carts are shown. Nice to think I'm that successful, but I'm sure it's not true!

Any thoughts?

Just downloaded/installed with my 1.5.4 version store. The Abandoned Cart Report displays correctly, however, when I attempt to send an email nothing happens. And, I found this in the error logs

[25-Aug-2019 21:20:06 UTC] PHP Fatal error: Call to undefined function zen_get_info_page() in /home/www/myStore/includes/classes/usu.php on line 324

Where does this function live? Did it get moved or renamed maybe?

Here is the code referenced in the error message....

// Add the cPath to the start of the parameters if present
		if(is_string($cPath)) array_unshift($p, 'cPath=' . $cPath);

		$this->log('Parsing Parameters for ' . $page);
		$this->log(var_export($p, true));

		$container = array();
		foreach ($p as $index => $valuepair){
			$p2 = @explode('=', $valuepair);

			switch ($p2[0]){
				case 'products_id':
					// Make sure if uprid is passed it is converted to the correct pid
					$p2[1] = zen_get_prid($p2[1]);

					switch(true) {
						// Handle product urls (check page against handler)
						case ($page == zen_get_info_page($p2[1])): //LINE 324

							// If a cPath was present we need to determine the immediate parent cid
							$cID = null;
							if(array_key_exists('cPath', $container)) {
								$cID = strrpos($container['cPath'], '_');
								if($cID !== false)
								{
									$cID = substr($container['cPath'], $cID+1);
								}
								else {
									$cID = $container['cPath'];
								}

								if(USU_CATEGORY_DIR != 'off' || USU_CPATH != 'auto') {
									unset($container['cPath']);
								}
							}
							$url = $this->make_url($page, $this->get_product_name($p2[1], $cID), $p2[0], $p2[1], USU_END, $separator);
							break;

This seems like a good tool to attempt to close the sale with an abandoned cart, but not if it can't generate and send emails.

Thanks for any help you can offer.

FYI - I get the same result when installing on a 1.5.5 version store as well.

catsma_97504:

[25-Aug-2019 21:20:06 UTC] PHP Fatal error: Call to undefined function zen_get_info_page() in /home/www/myStore/includes/classes/usu.php on line 324

This file is from another plugin, not RCS. You might try posting in that thread:
https://www.zen-cart.com/showthread.php?199064-Ultimate-SEO-2-200-Support-Thread

Hey Guys,

I am using recover_cart_sales.php v4.00.00a 2012/04/23, but I want to upgrade to the newest version. Is there steps that I can take to make sure I do the upgrade correctly?

I am use zen cart version 1.5.5a.

what is in the new versions that is different then the version I have. Is the email better? Does it send it out automatically or do you still have to press the send button?

how can i make this work with v 1.56