Email Alert to the registered users with Abandoned Baskets

This forum is where we'll mirror posts that are of value to the community so they may be more easily found.
User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:

Email Alert to the registered users with Abandoned Baskets

Post by mazhar » Tue Nov 04, 2008 10:20 am

It is possible to send the registered users Email alert for their Abandoned basket. I modified the Daily Abandoned Baskets report to incorporate this functionality. In order to use this feature first you need to create a new Email Template with name BasketAlert. You can create an Email template other then this name but for that you have to update the report so that it can load that template. Provide the necessary information in template. You can use two NVelocity parameters in the Email template and these are user and basket. For example the message part of my test template was

Code: Select all

UserName: $user.UserName
<br />
Item Count: $basket.Items.Count
After creating the BasketAlert Email template, download and extract the attachment. Then replace your existing Website\Admin\Reports\DailyAbandonedBaskets.aspx file with this newer one.

Please take a backup of your existing Website\Admin\Reports\DailyAbandonedBaskets.aspx file first.
Attachments
AbondenedBasketsAlert[7.0.3].zip
Updated Package for 7.0.3

Can also send Email to an anonymous customer if he/she has a valid Email Id.
(4.08 KiB) Downloaded 514 times
AbondenedBasketsAlert.zip
Package for 7.0.0
(3.53 KiB) Downloaded 482 times
AbandonedBasketAlert.gif
(6.24 KiB) Downloaded 29598 times

User avatar
William_firefold
Commander (CMDR)
Commander (CMDR)
Posts: 186
Joined: Fri Aug 01, 2008 8:38 am

Re: Email Alert to the registered users with Abandoned Baskets

Post by William_firefold » Tue Nov 04, 2008 2:16 pm

Awesome! Thanks for your help.
Is the "To Address:" still "customer" or is it "user" now?

User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:

Re: Email Alert to the registered users with Abandoned Baskets

Post by mazhar » Wed Nov 05, 2008 4:13 am

That's a valid point. I think we should make a small enhancement to the report. You can specify the customer keyword in the ToAddress of the Email Template at EditEmailTempalte page. Now made a small modification in the report and add a new customer parameter as well and comment out the code line which is setting the ToAddress manually through code as below

Code: Select all

if (emailTemplates.Count > 0)
        {
            emailTemplates[0].Parameters.Add("store", Token.Instance.Store);
            emailTemplates[0].Parameters.Add("user", basket.User);

            // Add another parameter so that user data could be accessed with customer keyword
            emailTemplates[0].Parameters.Add("customer", basket.User);

            emailTemplates[0].Parameters.Add("basket", basket);

            //Comment out the below line, no need for it after adding the customer parameter 
            //emailTemplates[0].ToAddress = basket.User.UserName;

            emailTemplates[0].Send();
        }

User avatar
WylieE
Captain (CAPT)
Captain (CAPT)
Posts: 281
Joined: Tue Mar 25, 2008 8:26 am
Location: Puyallup, WA
Contact:

Re: Email Alert to the registered users with Abandoned Baskets

Post by WylieE » Thu Feb 26, 2009 4:29 pm

We are looking at the mucho $$$ sitting on our abandoned baskets report and wanting to capture a portion of that. For those that are already emailing their customers, would you mind sharing the text of your emails to the (potential) customer?

We want to be sure our (unexpected) emails to the customer are respectful and encourage them to return. Thanks!
Eric Wylie
Warmoth Guitar Products, Inc.
http://www.warmoth.com

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: Email Alert to the registered users with Abandoned Baskets

Post by jmestep » Thu Feb 26, 2009 4:37 pm

When we did it, we would give the customer a coupon code for $xx off. We told them it was good for the next xx hours, but in reality it would have been good later but doing it that way saved us from having to create a lot of coupon codes. We did set it to 1 usage per customer. We had a fair amount of people use it.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

User avatar
WylieE
Captain (CAPT)
Captain (CAPT)
Posts: 281
Joined: Tue Mar 25, 2008 8:26 am
Location: Puyallup, WA
Contact:

Re: Email Alert to the registered users with Abandoned Baskets

Post by WylieE » Fri Feb 27, 2009 12:59 pm

Do you only send the one email or do you ever send out follow-up emails? I've seen a number of sites recommending one email as soon as possible after the basket is abandoned and a second email about two days later.

By any chance did you request feedback in your email? (We noticed you did not complete checkout. Was it something we did??) If so, did it prove to be of any value?

Thanks!
Eric Wylie
Warmoth Guitar Products, Inc.
http://www.warmoth.com

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: Email Alert to the registered users with Abandoned Baskets

Post by jmestep » Fri Feb 27, 2009 2:58 pm

We sent only one email and we didn't request feedback. One time the boss wanted an exit site survey so I set it up, then nobody looked at the results!
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

Brewhaus
Vice Admiral (VADM)
Vice Admiral (VADM)
Posts: 878
Joined: Sat Jan 19, 2008 4:30 pm

Re: Email Alert to the registered users with Abandoned Baskets

Post by Brewhaus » Sun Apr 05, 2009 7:12 pm

I would be very interested in the text being used for these e-mails, as well, as this is a sensitive area. On one hand it shows good customer service, but on the other it could make some people feel almost like they are being watched when in our store. I have some ideas on this, but would love to see what others have found to work.

Second question- where specifically should we place the updated code to incorporate the user name 'customer'?
Rick Morris
Brewhaus (America) Inc.
Hot Sauce Depot

User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:

Re: Email Alert to the registered users with Abandoned Baskets

Post by mazhar » Mon Apr 06, 2009 2:56 am

You can access user name in Email template like

Code: Select all

$customer.UserName

Brewhaus
Vice Admiral (VADM)
Vice Admiral (VADM)
Posts: 878
Joined: Sat Jan 19, 2008 4:30 pm

Re: Email Alert to the registered users with Abandoned Baskets

Post by Brewhaus » Mon Apr 06, 2009 5:47 pm

What I meant was in response to your post:
That's a valid point. I think we should make a small enhancement to the report. You can specify the customer keyword in the ToAddress of the Email Template at EditEmailTempalte page. Now made a small modification in the report and add a new customer parameter as well and comment out the code line which is setting the ToAddress manually through code as below

Code: Select all

if (emailTemplates.Count > 0)
        {
            emailTemplates[0].Parameters.Add("store", Token.Instance.Store);
            emailTemplates[0].Parameters.Add("user", basket.User);

            // Add another parameter so that user data could be accessed with customer keyword
            emailTemplates[0].Parameters.Add("customer", basket.User);

            emailTemplates[0].Parameters.Add("basket", basket);

            //Comment out the below line, no need for it after adding the customer parameter 
            //emailTemplates[0].ToAddress = basket.User.UserName;

            emailTemplates[0].Send();
        }
Where exactly would this be placed in the AbandonedBasketsAlert file? I have not looked at the file yet, so this may be obvious.

Also, will this file be overwritten in an upgrade?
Rick Morris
Brewhaus (America) Inc.
Hot Sauce Depot

User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:

Re: Email Alert to the registered users with Abandoned Baskets

Post by mazhar » Tue Apr 07, 2009 7:41 am

All you need to locate following if statement in packaged file

Code: Select all

if (emailTemplates.Count > 0)
        {
          ...................
.........................
        }
and update it as described in above post.

Secondly yes this is an enhancement in an AbleCommerce file so future upgrade may overwrite it.

Brewhaus
Vice Admiral (VADM)
Vice Admiral (VADM)
Posts: 878
Joined: Sat Jan 19, 2008 4:30 pm

Re: Email Alert to the registered users with Abandoned Baskets

Post by Brewhaus » Mon Apr 20, 2009 5:06 pm

After upgrading to 7.0.2 we replaced the DailyAbandonedBaskets file with the file running under 7.0. Will this work fine, or do we need to make any changes to the file?
Rick Morris
Brewhaus (America) Inc.
Hot Sauce Depot

User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:

Re: Email Alert to the registered users with Abandoned Baskets

Post by mazhar » Tue Apr 21, 2009 2:41 am

It would be better to merge changes into new version of file.

Brewhaus
Vice Admiral (VADM)
Vice Admiral (VADM)
Posts: 878
Joined: Sat Jan 19, 2008 4:30 pm

Re: Email Alert to the registered users with Abandoned Baskets

Post by Brewhaus » Tue Apr 21, 2009 6:54 am

What changes should be made to the old file to bring it up to 7.0.2?

We also use our 7.0 Default.aspx file in the main folder. This was a very basic file, so I assume that it should be fine?
Rick Morris
Brewhaus (America) Inc.
Hot Sauce Depot

ZLA
Commodore (COMO)
Commodore (COMO)
Posts: 496
Joined: Fri Mar 13, 2009 2:55 pm

Re: Email Alert to the registered users with Abandoned Baskets

Post by ZLA » Thu Aug 13, 2009 9:24 am

Brewhaus wrote:What changes should be made to the old file to bring it up to 7.0.2?

We also use our 7.0 Default.aspx file in the main folder. This was a very basic file, so I assume that it should be fine?
Brewhaus or AC, does the the old file still work in 7.0.2?

User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:

Re: Email Alert to the registered users with Abandoned Baskets

Post by mazhar » Mon Aug 17, 2009 8:10 am

Download the report version available for 7.0.3 and test it for your 7.0.2 store. You can also take a diff to find out any differences.

ZLA
Commodore (COMO)
Commodore (COMO)
Posts: 496
Joined: Fri Mar 13, 2009 2:55 pm

Re: Email Alert to the registered users with Abandoned Baskets

Post by ZLA » Wed Sep 30, 2009 7:59 am

mazhar wrote:It is possible to send the registered users Email alert for their Abandoned basket.
What about for new users who enter their billing information but don't submit their order? Are those users also captured by these modifications?

User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:

Re: Email Alert to the registered users with Abandoned Baskets

Post by mazhar » Wed Sep 30, 2009 8:15 am

If new user has provided its Email address information then report will allow to send Email alert.

ZLA
Commodore (COMO)
Commodore (COMO)
Posts: 496
Joined: Fri Mar 13, 2009 2:55 pm

Re: Email Alert to the registered users with Abandoned Baskets

Post by ZLA » Wed Sep 30, 2009 8:51 am

Thank you.

User avatar
Maryram
Ensign (ENS)
Ensign (ENS)
Posts: 6
Joined: Wed Feb 17, 2010 2:39 pm

Re: Email Alert to the registered users with Abandoned Baskets

Post by Maryram » Wed Feb 17, 2010 3:30 pm

Hi,
This is a really good feature.
Could anyone share the text they used for the Message and Subject in the email?
Thanks

Mike718NY
Commodore (COMO)
Commodore (COMO)
Posts: 485
Joined: Wed Jun 18, 2008 5:24 pm

Re: Email Alert to the registered users with Abandoned Baskets

Post by Mike718NY » Mon Mar 08, 2010 1:54 pm

Has anyone made a good email body for this?

I'm trying to display the cart items (Qty, Name, Price) but not having any luck.

If anyone could post what they have that would be great. :)

SecretSpin
Ensign (ENS)
Ensign (ENS)
Posts: 19
Joined: Thu Oct 29, 2009 5:34 am

Re: Email Alert to the registered users with Abandoned Baskets

Post by SecretSpin » Mon Mar 08, 2010 3:26 pm

A body that pulls information would be great.

Mike718NY
Commodore (COMO)
Commodore (COMO)
Posts: 485
Joined: Wed Jun 18, 2008 5:24 pm

Re: Email Alert to the registered users with Abandoned Baskets

Post by Mike718NY » Tue May 18, 2010 2:55 pm

I would really like to implement this email alert but can't figure out
how to layout the Items in the Basket. This is the best I have so far:

Item Count: 7
User name : 257af34a-1476-445a-9f7a-a619541119b0
BASKET : Item:Devotional Black Wooden Bracelet Quantity:3 Price:1.9900 Weight:0 Item:Brown Plastic Bead Rosary Quantity:3 Price:1.9900 Weight:0 Item:Durable Cord Plastic Rosary - Black Quantity:4 Price:0.4400 Weight:0 .............
basket.User.PrimaryAddress.Email : 222@aaaa.com

Has anyone created a good email template for this?

User avatar
mfreeze
Commodore (COMO)
Commodore (COMO)
Posts: 421
Joined: Mon Jan 24, 2005 2:07 pm
Location: Washington, NJ
Contact:

Re: Email Alert to the registered users with Abandoned Baskets

Post by mfreeze » Mon Jul 26, 2010 11:00 am

Was anybody ever successful at getting the basket contents to show in the email? If so, could you share your code for doing this?

I would also like to add a link to send the user to his/her abandoned basket. Does anybody have an idea how to do this?

Thanks
Mary E Freeze

Freeze Frame Graphics
Web Hosting and Design, ASP and CFMX Development

http://www.ffgraphics.com

User avatar
mfreeze
Commodore (COMO)
Commodore (COMO)
Posts: 421
Joined: Mon Jan 24, 2005 2:07 pm
Location: Washington, NJ
Contact:

Re: Email Alert to the registered users with Abandoned Baskets

Post by mfreeze » Wed Jul 28, 2010 2:29 pm

Ok. I got a reasonable looking template with the basket contents. I didn't get a link to work because it would involve a lot of coding to pass the basket information, create a new basket, etc. But my client is happy and all we will be doing is changing text, etc.

For anybody who is interested, below is the code for my template as it exists so far. We will be tweaking this before it goes production but it's a beginning.

Code: Select all

<html>
<head>
<style type="text/css">
TABLE.Email {
width: 640px;
padding: 5px;
margin: 0px;
border: 1px solid #5872CB;
}
TABLE.Email TH {
font-weight: bold;
font-size: 12px;
color: #ffffff;
font-family: Arial, Verdana, Sans-Serif;
font-style: strong;
background-color: #304FBA;
text-align: center;
text-decoration: none;
padding: 5px;
}
TABLE.Email TD {
font-weight: normal;
font-size: 12px;
color: #000000;
font-family: Arial, Verdana, Sans-Serif;
background-color: #ffffff;
text-align: left;
text-decoration: none;
padding: 3px;
}
</style>
</head>
<body>
<table class="Email" width="600px" align="center">
<tr>
<td>
<img src="http://www.officeplayground.com/Assets/NavGraphics/opg_logo_website_noTM-3.gif">
</td></tr>
<td style="background-color: #f8981c; border-top: 1px solid #dca686; border-bottom: 0;width: 600px;text-align: left;height: 24px; width:600px; align:center;>
			<div style="float:left; background-color: #f8981c; color: #013a84; font-family: Tahoma, Arial, Verdana, Helvetica, sans-serif; font-size: 9px; line-height: 24px; text-transform: uppercase;
    font-weight: bold;
    text-decoration: none;
    text-align: center;
    width: auto;
    padding: 7px 12px 7px 12px;">
				<a href="http://www.officeplayground.com/Default.aspx" class="tab">Home</a>&nbsp;&nbsp;&nbsp;&nbsp;
				<a href="http://www.officeplayground.com/Search.aspx" class="tab">Product Finder</a>&nbsp;&nbsp;&nbsp;&nbsp;	
				<a href="http://www.officeplayground.com/AdvancedSearch.aspx" class="tab">Advanced Search</a>&nbsp;&nbsp;&nbsp;&nbsp;	
				<a href="http://www.officeplayground.com/ContactUs.aspx" class="tab">Contact Us</a>&nbsp;&nbsp;&nbsp;&nbsp;
                #if($customer.IsAnonymous)
					<a href="http://www.officeplayground.com/Login.aspx" class="login">Login</a>&nbsp;&nbsp;&nbsp;&nbsp;
				#else
					<a href="http://www.officeplayground.com/Logout.aspx" class="login">Logout</a>&nbsp;&nbsp;&nbsp;&nbsp;
				#end
				<a href="http://www.officeplayground.com/Members/MyAccount.aspx" class="acct">Account</a>&nbsp;&nbsp;&nbsp;&nbsp;
				<a href="http://www.officeplayground.com/Members/MyWishlist.aspx" class="wishlist">Wishlist</a>&nbsp;&nbsp;&nbsp;&nbsp;
				<a href="http://www.officeplayground.com/Basket.aspx" class="basket">Cart</a>&nbsp;&nbsp;&nbsp;&nbsp;
				#if($customer.IsAdmin)
					<a href="http://www.officeplayground.com/Admin/Default.aspx" class="admin">Admin</a>&nbsp;&nbsp;&nbsp;&nbsp;
				#end
</table>
<table class="Email" align="center" width="600px">
<tr>
<td colspan="2" class="Email">
Dear $firstname
<br />

<p><strong><span style="font-size:14px; color:red;">We noticed $basket.Items.Count great items were left behind in your shopping cart at $store.Name.</strong></span></p>
<p> Did you encounter a problem checking out? Just in case you did, we have saved those items in your cart.</p>
<p>Your order contained the following products.<p>
<p>
<!-- *************************** -->
<!-- Do not change code between these two comments. If you need something changed contact Freeze Frame Graphics --> 

<table border="0" cellpadding="5" cellspacing="0" width="100%">
<tr>
<td style="background:#cccccc; color:#00000; text-align: center;"><strong>SKU</strong></td>
<td style="background:#cccccc; color:#00000; text-align: center;"><strong>Description</strong></td>
<td style="background:#cccccc; color:#00000; text-align: center;"><strong>Quantity</strong></td>
<td style="background:#cccccc; color:#00000; text-align: center;"><strong>Price</strong></td>
</tr>
<tbody>
#foreach($basketItem in $basket.Items)
	<tr>
    	<td style="text-align:center;">$basketItem.Sku</td>
        <td><b>$basketItem.Name</b></td>
        <td>$basketItem.Quantity</td>
        <td>$basketItem.Price.ToString("ulc")</td>
    </tr>
#end
</tbody>
</table>
<!--*************************** -->
<!-- End of Do Not Change Code -->
</p>
<!--p><strong>Simply <a href="http://www.officeplayground.com/Basket.aspx">click here</a> to finish placing your order and we'll ship those wonderful items to you ASAP.</strong></p -->

<p>If you encounter any further issues in completing your order, please feel free to contact us at 1-800-458-1948 and one of our friendly customer service representatives will be happy to help you.
We look forward to seeing you again at $store.Name!</p>
<p>
Sincerely,
</p>

</td>
</tr>
</table>
<p>&nbsp;</p>
</body>
</html>
Mary E Freeze

Freeze Frame Graphics
Web Hosting and Design, ASP and CFMX Development

http://www.ffgraphics.com

Post Reply