Abandoned Shopping Cart Email Reminder

Thx dr. Byte, but that didn't work. Called godaddy and they recommended getting rid of the php -f and going direct, this occurred, so, getting deeper...

/home/content/69/11416569/html/cart_reminder_cron.php: line 1: ?php
: No such file or directory
/home/content/69/11416569/html/cart_reminder_cron.php: line 2:
: command not found
/home/content/69/11416569/html/cart_reminder_cron.php: line 3: /**
: No such file or directory
/home/content/69/11416569/html/cart_reminder_cron.php: line 4: backup: command not found
/home/content/69/11416569/html/cart_reminder_cron.php: line 5: backup: command not found
/home/content/69/11416569/html/cart_reminder_cron.php: line 6: backup: command not found
/home/content/69/11416569/html/cart_reminder_cron.php: line 7: backup: command not found
/home/content/69/11416569/html/cart_reminder_cron.php: line 8: backup: command not found
/home/content/69/11416569/html/cart_reminder_cron.php: line 9: backup: command not found
/home/content/69/11416569/html/cart_reminder_cron.php: line 10: backup: command not found
/home/content/69/11416569/html/cart_reminder_cron.php: line 11: backup: command not found
/home/content/69/11416569/html/cart_reminder_cron.php: line 12: */
: No such file or directory
/home/content/69/11416569/html/cart_reminder_cron.php: line 13:
: command not found
/home/content/69/11416569/html/cart_reminder_cron.php: line 14: /bin: is a directory
/home/content/69/11416569/html/cart_reminder_cron.php: line 15:
: command not found
/home/content/69/11416569/html/cart_reminder_cron.php: line 16: =: command not found
/home/content/69/11416569/html/cart_reminder_cron.php: line 16:
: command not found
/home/content/69/11416569/html/cart_reminder_cron.php: line 17:
: command not found
/home/content/69/11416569/html/cart_reminder_cron.php: line 45: syntax error near unexpected token (' /home/content/69/11416569/html/cart_reminder_cron.php: line 45: / Step 1: Remove all items in cart_reminder table that don't have an associated cart (where the users aren't logged in) */
'

What now? They recommended doing /web/cgi-bin/php5_3 as prefix

Does anyone know will this work with Ver 1.50?

Trademagic:

The code I placed in cron is 0 ****cd/home/content/69/11416569/html/; php cart_reminder_cron.php > /dev/null

Hi Trademagic,

I believe the problem is that you removed a bunch of spaces. You need to have a space after each * and after "cd". Try formatting it like this:

0 * * * * cd /home/content/69/11416569/html/; php cart_reminder_cron.php > /dev/null

dsimon55:

Does anyone know will this work with Ver 1.50?

Yes, it should.

gonsman:

Hi Trademagic,

I believe the problem is that you removed a bunch of spaces. You need to have a space after each * and after "cd". Try formatting it like this:

0 * * * * cd /home/content/69/11416569/html/; php cart_reminder_cron.php > /dev/null

Thanks Gonsman, but when I do that, I get this

/bin/sh: 0: command not found
/bin/sh: php: command not found

I have had it send the letter twice, but with way different code. Needing the right way to do it, and willing to try anything. Also, if someone could give me the correct format for changing the zen cart logo and replacing it with my logo, in the letter generated, it would be appreciated.

Marc

Trademagic:

Thanks Gonsman, but when I do that, I get this

/bin/sh: 0: command not found
/bin/sh: php: command not found

I have had it send the letter twice, but with way different code. Needing the right way to do it, and willing to try anything. Also, if someone could give me the correct format for changing the zen cart logo and replacing it with my logo, in the letter generated, it would be appreciated.

Marc

In GoDaddy, does it ask you for the day, month, hour and minute in a different field? If so, you may need to remove the first part of the cron job and only provide the command: cd /home/content/69/11416569/html/; php cart_reminder_cron.php > /dev/null

It also sounds like GoDaddy does not support the alias php so you need the full path the PHP executable. Something like cd /home/content/69/11416569/html/; /usr/bin/php cart_reminder_cron.php > /dev/null

It does ask for those items separately, so will try the codes and see which works.

1st one returned this

/bin/sh: pp: command not found

2nd returned this

/bin/sh: /usr/bin/php: No such file or directory

sending exact results so you can see what it takes and didn't take more clearly.

I appreciate every bit of your tracking this down. perhaps the next iteration...

Marc

Trademagic:

It does ask for those items separately, so will try the codes and see which works.

1st one returned this

/bin/sh: pp: command not found

2nd returned this

/bin/sh: /usr/bin/php: No such file or directory

sending exact results so you can see what it takes and didn't take more clearly.

I appreciate every bit of your tracking this down. perhaps the next iteration...

Marc

According to GoDaddy, the PHP path is /web/cgi-bin/php5 (see http://support.godaddy.com/help/article/3483/what-is-a-cron-job)

If this is the case, the command would be cd /home/content/69/11416569/html/; /web/cgi-bin/php5 cart_reminder_cron.php > /dev/null

neither of those worked and I sent a post which I tried to append to. Perhaps you saw it, I can repost the info.

First try was /bin/sh: php: command not found

second was /bin/sh: /usr/bin/php: No such file or directory

I appreciate every bit of your tracking this down. perhaps the next iteration...

if I remove the cd from the front of the equation i get this

/bim/sh: /home/content/69/11416569/html: is a directory
/bin/sh: php: command not found

Trademagic:

neither of those worked and I sent a post which I tried to append to. Perhaps you saw it, I can repost the info.

First try was /bin/sh: php: command not found

second was /bin/sh: /usr/bin/php: No such file or directory

I appreciate every bit of your tracking this down. perhaps the next iteration...

if I remove the cd from the front of the equation i get this

/bim/sh: /home/content/69/11416569/html: is a directory
/bin/sh: php: command not found

Please see my previous post.

You are a genius compared to many, supergenius compared to me....

It worked. Thank you. Now, how do I get the cart reminder email to show my logo rather than their logo? Just don't know whether html works, and suspect it doesn't.

It worked, perfectly. How may I edit the html email at email_template_cart_reminder.html to put my logo at the top rather than the zencart logo?

My sincere and major thanks. This has been an issue for 2 weeks for me...

Trademagic:

You are a genius compared to many, supergenius compared to me....

It worked. Thank you. Now, how do I get the cart reminder email to show my logo rather than their logo? Just don't know whether html works, and suspect it doesn't.

To change the logo, you can edit the HTML to reference a different image or change the one at https://www.YOURWEBSITE.com/YOURSTOREFOLDER/email/header.jpg

Anyone knows why {SHOPPING_CART} is showing duplicate items?

We noticed you added some items to your shopping cart, but did not check out. If you experienced any trouble with our site or during checkout, we would be more than happy to help out. In addition, if you have any questions or concerns about our products or any of our policies, please let us know so we can address them promptly. It is our goal to ensure you have the best possible shopping experience, so please don't hesitate to reach out.

To send us an email, you can REPLY to this message or visit our contact page at http://xxxxxxxxxxxx.com/shop/index.php?main_page=contact_us

If you would like to speak with someone, please give us a call at 00.00.00.00.

For your convenience, we have listed the items currently in your cart below:

Wire Form - 7407 4” to 5”
Quantity: 1
http://xxxxxxxxxxxx.com/shop/index.php?main_page=product_info&products_id=23

Wire Form - 7407 4” to 5”
Quantity: 1
http://xxxxxxxxxxxx.com/shop/index.php?main_page=product_info&products_id=23

If you are ready to checkout, please login to your account at http://xxxxxxxxxxxx.com/shop/index.php?main_page=login and proceed to checkout.

If you don't remember your password, you can reset it here: http://euphoriaerotica.com/shop/index.php?main_page=password_forgotten

Thank you,

Hello,

I get this error every day, many times a day. Has anyone seen this before or know what could be the issue?

[01-Sep-2013 09:54:01 America/New_York] PHP Warning:  mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/mysite/public_html/cart_reminder_cron.php on line 35

This is what line 35 looks like:

$row = mysql_fetch_assoc($result);

Hi,

I installed this add on, I don't encounter any installation error.
I checked the DB tables as well.
When I test, by login into user account, it doesn't create an entry in xxx_cart_reminder table. The table always empty.
I suppose, it should execute the add_cart_reminder() and create an entry in that table upon user login, but it didn't insert any entry. I feel strange.

\includes\modules\page\login\header_php.php

	if (defined('CART_REMINDER') && CART_REMINDER == true){
		   
		include_once(DIR_WS_LANGUAGES . $_SESSION['language'] . '/' . 'cart_reminder.php');  //
		/* Check to make sure customer isn't already in the table */

		$sql = "SELECT * FROM " . TABLE_CART_REMINDER . "  WHERE customer_id = :customersID";

		$sql = $db->bindVars($sql, ':customersID',  $_SESSION['customer_id'], 'integer');
	
		$result = $db->Execute($sql);
		if($result->RecordCount() == 0){
			add_cart_reminder();
		
		}
        }

Thoughts ?

Regards,
Sky

skywalker826:

Hi,

I installed this add on, I don't encounter any installation error.
I checked the DB tables as well.
When I test, by login into user account, it doesn't create an entry in xxx_cart_reminder table. The table always empty.
I suppose, it should execute the add_cart_reminder() and create an entry in that table upon user login, but it didn't insert any entry. I feel strange.

\includes\modules\page\login\header_php.php

if (defined('CART_REMINDER') && CART_REMINDER == true){
	   
	include_once(DIR_WS_LANGUAGES . $_SESSION['language'] . '/' . 'cart_reminder.php');  //
	/* Check to make sure customer isn't already in the table */

	$sql = "SELECT * FROM " . TABLE_CART_REMINDER . "  WHERE customer_id = :customersID";

	$sql = $db->bindVars($sql, ':customersID',  $_SESSION['customer_id'], 'integer');

	$result = $db->Execute($sql);
	if($result->RecordCount() == 0){
		add_cart_reminder();
	
	}
    }

> 
> Thoughts ?
> 
> 
> Regards,
> Sky


Just an update. Issue has been resolved with some workaround.

I'm trying to setup the cron job and must be doing something wrong.
I use HostGator for my server
my latest attempt is:
php /home/andilyn/public_html/php cart_reminder_cron.php
which sends my admin an email of:
Status: 404 Not Found
Content-type: text/html
No input file specified.

cd /home/andilyn/public_html/cherrypitcrafts.com/; php cart_reminder_cron.php > /dev/null
which sent out this email to my admin:
/bin/sh: /home/andilyn/public_html/cherrypitcrafts.com: is a directory
Status: 404 Not Found
Content-type: text/html
No input file specified.

Anyone have any clues?

Is there a problem having two autoresponder programs at the same time. I received an error and have Autoresponder+ off and cart reminder which is on. Can one use both for their different purposes, or is this a problem for zencart?

Could someone tell me exactly HOW an entry is supposed to be created in the zen_cart_reminder table?

I logged in as a test user, and I added a couple items to my cart. I then hit logoff, and went to this table. However, it did NOT create an entry for my test account. Any idea why?

NOTE: I do see ONE entry in there for another user, so apparently the program does work and it does add entries in there. But I have no idea HOW it does it, or what TRIGGERS it.

Can someone let me know so I can at least replicate it working with my test account?