Abandoned Shopping Cart Email Reminder

[dysfunctional]

I am finishing up a drop-in mailbeez module that will utilize the features of mailbeez (tracking, opt outs, etc.).

No ETA yet, but its in process.

Hi Limitless, I'm extremely interested in such a module since I'm a massive Mailbeez fan. Curious if you ever got anywhere with this?

Best wishes

Peter

[harry2cool]

I'm not sure, but too me that sounds like a bug. We will take a look and see. Thanks!

Yes, I was searching the forum for this very issue.

If someone goes away without logging off, just closes the browser the email is not sent.

Also we have installed auto login modules where the customer gets logged in automatically when he comes back after some time , so he never gets logged off.


When we used the other module where we manually sent the emails, we used to get replies everytime we sent emails, this time we are very very few replies because the emails are not reaching them for this very reason.

Please let me know what can we do.

[robertluer]

This module has been great for me using Zencart 1.5.1 however it looks like something needs updating for Zencart 1.5.4

When installed in 1.5.4 an error message is generated when a customer tries to login again or create an account. Looks like something needs changing in the header_php files in includes/modules/pages/login and includes/modules/pages/create_account_success folders. I restored the original 1.5.4 header_php files and the error message disappeared so I think it is the header_php.php files that are the problem.

I am using the Responsive all business template but don't think this relates to the issue.
My test site is at canadaflagshop.com/demo
Can you help?
Robert

[travbacon]

using 1.54. our server is set in another time zone. so we set the time zone adding the command for our time zone in the php.ini.

now we are getting this message every minutes as an error

strtotime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone.

any clues how we can fix this in the coding?

cart_reminder_cron.php on line 101

i think if we remove the time zone setting in our php.ini file it goes away but the problem is now the orders that come in do not match our time zone.

THanks.

[ianhg]

Using version zen cart 1.5.4 and COWOA version 2.4
Does anyone know if cart reminder will work with COWOA or will it only work with customers who have actually created an account?
Thanks

[jld]

Hi,
I am still running Zen Cart version V1.3.9h will this module work on that version? If not can someone recommend something else that will work please.

Johanne

[marcopolo]

I'm currently using Recover Cart sales because it gives reporting on what sales were recovered due to emails sent out. I just installed the Cart Reminder Module as well and would like to have them work together. I think all that has to be done is a modification to cart_reminder_cron.php this file will need to set customer as contacted in rover cart module.

The code from recover cart module that does this I believe is located in file admin/recover_cart_sales.php

The part of the file/code that seems to set customers as contacted is:

// Set Contacted Begin
if ($_GET['action'] == 'setconacted') {
    $customer = $db->Execute("SELECT customers_firstname, customers_lastname
                                                        FROM " . TABLE_CUSTOMERS . "
                                                        WHERE customers_id ='" . (int)$_GET['customer_id'] . "' LIMIT 1");
    // See if a record for this customer already exists; if not create one and if so update it
    $donequery = $db->Execute("SELECT * FROM ". TABLE_SCART ." WHERE customers_id = '" . (int)$_GET['customer_id'] . "'");
    if ($donequery->RecordCount() == 0)
        $db->Execute("INSERT INTO " . TABLE_SCART . " (customers_id, dateadded, datemodified) VALUES ('" . (int)$_GET['customer_id'] . "', '" . date('Ymd') . "', '" . date('Ymd') . "')");
    else
        $db->Execute("UPDATE " . TABLE_SCART . " SET datemodified = '" . date('Ymd') . "' WHERE customers_id = " . (int)$_GET['customer_id']);
    $messageStack->add(MESSAGE_STACK_CUSTOMER . $customer->fields['customers_firstname'] . ' ' . $customer->fields['customers_lastname'] . ' (ID ' . $_GET['customer_id'] . ')' . MESSAGE_STACK_SETCONACTED, 'success');
}
// Set Contacted End 

I tried adding the following to cart_reminder_cron.php:

require('includes/application_top.php');
require(DIR_WS_CLASSES . 'currencies.php');
    $customer = $db->Execute("SELECT customers_firstname, customers_lastname
                                                        FROM " . TABLE_CUSTOMERS . "
                                                        WHERE customers_id ='" . (int)$_GET['customer_id'] . "' LIMIT 1");
    // See if a record for this customer already exists; if not create one and if so update it
    $donequery = $db->Execute("SELECT * FROM ". TABLE_SCART ." WHERE customers_id = '" . (int)$_GET['customer_id'] . "'");
    if ($donequery->RecordCount() == 0)
        $db->Execute("INSERT INTO " . TABLE_SCART . " (customers_id, dateadded, datemodified) VALUES ('" . (int)$_GET['customer_id'] . "', '" . date('Ymd') . "', '" . date('Ymd') . "')");
    else
        $db->Execute("UPDATE " . TABLE_SCART . " SET datemodified = '" . date('Ymd') . "' WHERE customers_id = " . (int)$_GET['customer_id']); 

but it is not working? Anyone know why?

[spawnie69]

Hi everyone,
I just installed this mod onto to my 1.54 cart.
Does this look ok for my cron job?

0 * * * * cd /homeX/XXXXXXXX/public_html/; php cart_reminder_cron.php > /dev/null

I have it setup at the defualt setting. I have a shopping cart filled up then logged out. Hours later still no email received.

any advice is much appreciated.

[spawnie69]

Hi everyone,
I just installed this mod onto to my 1.54 cart.
Does this look ok for my cron job?

0 * * * * cd /homeX/XXXXXXXX/public_html/; php cart_reminder_cron.php > /dev/null

I have it setup at the defualt setting. I have a shopping cart filled up then logged out. Hours later still no email received.

any advice is much appreciated.

Answered my own question with research. I have bluehost and the following setting is the key:
0 * * * * php /home/username/public_html/cart_reminder_cron.php

YIPPIE!!

[spawnie69]

Answered my own question with research. I have bluehost and the following setting is the key:
0 * * * * php /home/username/public_html/cart_reminder_cron.php

YIPPIE!!

Ok, this worked once and only once. I receive emails that the cron ran but never get anymore email reminders. Is the email sent only once?
I have it set it up for sending every hour. So I assume everyone with a filled cart who has signed out will receive an email every hour until they do something about it. Is this correct?
This module has been very frustrating, I keep trying different commands thinking I did something wrong but receive no emails reminding me of my cart.