Abandoned Shopping Cart Email Reminder

[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

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

[remops]

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

Having same issue could you explain your work around?

Thanks

[remops]

How can you test this? Do I have to wait the hour or what you have set before it send out a email?

[meljen]

Is this compatible with v1.5? I am asking since only 1.5.1+ seemed to be listed...

[gonsman]

It should be OK with 1.5, but I have not tested it.

[bbsbcastle]

Hello,

Love the module. Thanks for taking the time to write and support it.

I've searched the thread, and from what I've seen, my Cart Reminder is working "correctly". However, if it is, I wonder if it can be changed.

The reminder email is only being sent if the user logs out. I can create a cart, checkout, create a new account, and log out, or I can log into an existing account, put stuff in a cart and log out. Either way, I get an email. If I just "go away" without logging out (which to me is almost the definition of an abandoned cart) I don't get an email.

Is this how it's supposed to work? Is there a mod to make it send an email if the user hasn't logged out? I wouldn't mind setting the timing so it was less aggressive if you're concerned about sending a reminder while the user is still logged in.

Thanks