Page 1 of 2
Email Alert to the registered users with Abandoned Baskets
Posted: Tue Nov 04, 2008 10:20 am
by mazhar
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.
Re: Email Alert to the registered users with Abandoned Baskets
Posted: Tue Nov 04, 2008 2:16 pm
by William_firefold
Awesome! Thanks for your help.
Is the "To Address:" still "customer" or is it "user" now?
Re: Email Alert to the registered users with Abandoned Baskets
Posted: Wed Nov 05, 2008 4:13 am
by mazhar
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();
}
Re: Email Alert to the registered users with Abandoned Baskets
Posted: Thu Feb 26, 2009 4:29 pm
by WylieE
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!
Re: Email Alert to the registered users with Abandoned Baskets
Posted: Thu Feb 26, 2009 4:37 pm
by jmestep
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.
Re: Email Alert to the registered users with Abandoned Baskets
Posted: Fri Feb 27, 2009 12:59 pm
by WylieE
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!
Re: Email Alert to the registered users with Abandoned Baskets
Posted: Fri Feb 27, 2009 2:58 pm
by jmestep
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!
Re: Email Alert to the registered users with Abandoned Baskets
Posted: Sun Apr 05, 2009 7:12 pm
by Brewhaus
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'?
Re: Email Alert to the registered users with Abandoned Baskets
Posted: Mon Apr 06, 2009 2:56 am
by mazhar
You can access user name in Email template like
Re: Email Alert to the registered users with Abandoned Baskets
Posted: Mon Apr 06, 2009 5:47 pm
by Brewhaus
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?
Re: Email Alert to the registered users with Abandoned Baskets
Posted: Tue Apr 07, 2009 7:41 am
by mazhar
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.
Re: Email Alert to the registered users with Abandoned Baskets
Posted: Mon Apr 20, 2009 5:06 pm
by Brewhaus
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?
Re: Email Alert to the registered users with Abandoned Baskets
Posted: Tue Apr 21, 2009 2:41 am
by mazhar
It would be better to merge changes into new version of file.
Re: Email Alert to the registered users with Abandoned Baskets
Posted: Tue Apr 21, 2009 6:54 am
by Brewhaus
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?
Re: Email Alert to the registered users with Abandoned Baskets
Posted: Thu Aug 13, 2009 9:24 am
by ZLA
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?
Re: Email Alert to the registered users with Abandoned Baskets
Posted: Mon Aug 17, 2009 8:10 am
by mazhar
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.
Re: Email Alert to the registered users with Abandoned Baskets
Posted: Wed Sep 30, 2009 7:59 am
by ZLA
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?
Re: Email Alert to the registered users with Abandoned Baskets
Posted: Wed Sep 30, 2009 8:15 am
by mazhar
If new user has provided its Email address information then report will allow to send Email alert.
Re: Email Alert to the registered users with Abandoned Baskets
Posted: Wed Sep 30, 2009 8:51 am
by ZLA
Thank you.
Re: Email Alert to the registered users with Abandoned Baskets
Posted: Wed Feb 17, 2010 3:30 pm
by Maryram
Hi,
This is a really good feature.
Could anyone share the text they used for the Message and Subject in the email?
Thanks
Re: Email Alert to the registered users with Abandoned Baskets
Posted: Mon Mar 08, 2010 1:54 pm
by Mike718NY
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.
Re: Email Alert to the registered users with Abandoned Baskets
Posted: Mon Mar 08, 2010 3:26 pm
by SecretSpin
A body that pulls information would be great.
Re: Email Alert to the registered users with Abandoned Baskets
Posted: Tue May 18, 2010 2:55 pm
by Mike718NY
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?
Re: Email Alert to the registered users with Abandoned Baskets
Posted: Mon Jul 26, 2010 11:00 am
by mfreeze
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
Re: Email Alert to the registered users with Abandoned Baskets
Posted: Wed Jul 28, 2010 2:29 pm
by mfreeze
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>
<a href="http://www.officeplayground.com/Search.aspx" class="tab">Product Finder</a>
<a href="http://www.officeplayground.com/AdvancedSearch.aspx" class="tab">Advanced Search</a>
<a href="http://www.officeplayground.com/ContactUs.aspx" class="tab">Contact Us</a>
#if($customer.IsAnonymous)
<a href="http://www.officeplayground.com/Login.aspx" class="login">Login</a>
#else
<a href="http://www.officeplayground.com/Logout.aspx" class="login">Logout</a>
#end
<a href="http://www.officeplayground.com/Members/MyAccount.aspx" class="acct">Account</a>
<a href="http://www.officeplayground.com/Members/MyWishlist.aspx" class="wishlist">Wishlist</a>
<a href="http://www.officeplayground.com/Basket.aspx" class="basket">Cart</a>
#if($customer.IsAdmin)
<a href="http://www.officeplayground.com/Admin/Default.aspx" class="admin">Admin</a>
#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> </p>
</body>
</html>