Abandoned Shopping Cart Email Reminder

We have created a new module that sends out email reminders for users that have abandoned their shopping carts.

gonsman:

We have created a new module that sends out email reminders for users that have abandoned their shopping carts.

The module is now available here: http://www.zen-cart.com/downloads.php?do=file&id=1589

This module automatically sends a reminder email to a registered user who has abandoned their cart. This is fully automated, and will send the email after however many hours you have set. You may also customize the email templates that are sent to the customer.

This is a great marketing module. Big Thanks to developer!

Could you please advise if there is any way to see what customers received this email? Any options to track opens, etc.
Is this only going to be sent once to the same person?

I've got everything up and running including cron job every hour but would love to be able to get some insights.

Kind Regards
Damian K.

damiankrzyz:

This is a great marketing module. Big Thanks to developer!

Could you please advise if there is any way to see what customers received this email? Any options to track opens, etc.
Is this only going to be sent once to the same person?

I've got everything up and running including cron job every hour but would love to be able to get some insights.

Kind Regards
Damian K.

Hi Damian,

Thank you for the comments. There is no tracking to see who received or opened the emails. It will only send one email unless the user logs back in and leaves items in their cart again. To make sure the cron is working, I would set the reminder hours to 1, login to the web site, add something to your cart and logout. In an hour you should get an email.

Thanks

-Sean

Hello. I have installed the mod on my zen cart install, v1.5.0. The cart_reminder_install.php runs without error. However after install, I see the new configuration section for the Shopping Cart reminder, but when I enter that section there are no options to configure.

A screen shot is available here: http://inspiredbydominic.com/store/screen.png

Please let me what I can do to diagnose the issue. Thanks!

-John

jberman:

Hello. I have installed the mod on my zen cart install, v1.5.0. The cart_reminder_install.php runs without error. However after install, I see the new configuration section for the Shopping Cart reminder, but when I enter that section there are no options to configure.

A screen shot is available here: http://inspiredbydominic.com/store/screen.png

Please let me what I can do to diagnose the issue. Thanks!

-John

Looks like you are either missing files, files corrupted during upload or of the sort. Try re-uploading all files one at a time in their proper directories and see if it fixes it.

damiankrzyz:

This is a great marketing module. Big Thanks to developer!

Could you please advise if there is any way to see what customers received this email? Any options to track opens, etc.
Is this only going to be sent once to the same person?

I've got everything up and running including cron job every hour but would love to be able to get some insights.

Kind Regards
Damian K.

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.

knuckle-101:

Looks like you are either missing files, files corrupted during upload or of the sort. Try re-uploading all files one at a time in their proper directories and see if it fixes it.

This has been attempted twice and the screen remains the same.

jberman:

This has been attempted twice and the screen remains the same.

Not sure about this one. Did you make sure the SQL was installed properly? As you see in the image it works and all I did was drop the files in their proper directories and upload the SQL . Weird indeed as far as I can tell something did not upload or it corrupted during upload or your SQL was not installed. Maybe someone with the same issue as you have can be more assistance.

[Attachment no longer available]

There were SQL errors in the cart_reminder_install.php (latest version).

On line 46:

$sql = "UPDATE `".DB_PREFIX."configuration_group` SET `sort_order` = $last_id WHERE `configuration_group_id`=";

The "configuration_group_id" variable isn't passed into the statement. I commented this out.

In addition to that, the statements that follow do not append the DB_PREFIX to the configuration table.

i.e.

$sql = "INSERT INTO configuration ...

should be

$sql = "INSERT INTO `".DB_PREFIX."configuration` ...

Thanks for all your help!

Also found a small bug in cart_reminder_cron.php, line 33.

$sql ="SELECT configuration_value FROM ".DB_PREFIX ." configuration WHERE configuration_key = 'CART_REMINDER'";

should be

$sql ="SELECT configuration_value FROM ".DB_PREFIX ."configuration WHERE configuration_key = 'CART_REMINDER'";

(I removed a space after ".DB_PREFIX .")

This script also needs the DB_PREFIX added to each statement.

jberman:

Also found a small bug in cart_reminder_cron.php, line 33.

$sql ="SELECT configuration_value FROM ".DB_PREFIX ." configuration WHERE configuration_key = 'CART_REMINDER'";

> 
> should be
> ```
$sql ="SELECT configuration_value FROM ".DB_PREFIX ."configuration WHERE configuration_key = 'CART_REMINDER'";

(I removed a space after ".DB_PREFIX .")

This script also needs the DB_PREFIX added to each statement.

I'll check this and we'll update it if need be.

Zola:

I'll check this and we'll update it if need be.

We have submitted a new version with bug fixes for db prefix issues. Please check for version 1.1 as soon as it is approved on the download page: http://www.zen-cart.com/downloads.php?do=file&id=1589

Hello!
Is there a way to change the webpage links in the email reminder from http://webpage.com/index.php?main_page=product_info&products_id=3666 to http://webpage.com/shop/index.php?main_page=product_info&products_id=3666

our store is in "shop" folder.

regards!

Gurrumino:

Hello!
Is there a way to change the webpage links in the email reminder from http://webpage.com/index.php?main_page=product_info&products_id=3666 to http://webpage.com/shop/index.php?main_page=product_info&products_id=3666

our store is in "shop" folder.

regards!

Hi Gurrumino,

I have updated the package with some changes that should address the issue of the store folder. It looks like we didn't have the define variable DIR_WS_CATALOG in the links. I have not tested this on a live site yet so please let me know if this works so I can update the package on the Zen-Cart web site: https://www.box.com/shared/static/gxdufe766nnyhtkb9xpb.zip

Thanks,

-Sean

Hello gonsman, now is working perfectly ...:smile::D

Best Regards!

Gurrumino:

Hello gonsman, now is working perfectly ...:smile::D

Best Regards!

Great! I will submit the update to the plugin page.

I noticed that the email sent by these module, the cart content is repeated, is just me? or is a little bug?

This is my first time, so please be gentle...

I have installed shopping cart reminder and been having the following email for days. It comes every hour, at the time chosen.

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

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

I think I saved this correctly on godaddy cron Job manager but don't know if I did code right. Go daddy says never seen 0 ****cd before my address info, but copied it from instructions info.

I have read all dialogue here, and checked cart reminder install to confirm changes above this were on my copy correctly. I believe this is the only thing installed affecting core files.

My site is reasonablerigging.com and the site is on the index level of the site.

Can someone tell me what to do that does not involve inflicting pain on myself...?

Many thanks,

Marc

Trademagic:

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

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

Might try this instead (assuming the path is correct):

php -f /home/content/69/11416569/html/cart_reminder_cron.php > /dev/null 

By starting with "php -f" it's saying "tell PHP to execute the file specified as the next parameter".
GoDaddy support can tell you what the correct syntax is to run PHP CLI (command-line-interface) with cron jobs on their servers.
Sometimes the -f is not needed.
Sometimes additional params are needed
Sometimes something other than the >/dev/null as a suffix might be required, depending on server configuration requirements and operating systems.