My question is how could we add another column in the report that would show the user's email address. This way, you would know if there is an email address attached to the abandoned basket to know whether it's even worth sending the alert. I know the email is obviously available, but try as I might, I can get it to work. I can put the UserId in the grid, but I'm not good enough at ASP.NET/C# (yet) to get to the email address.
Also, I think it would be good if there was a way to add a check box that would be checked when the alert has been sent so you would know that you have already sent an alert to that customer.
Code: Select all
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<style>
*
{
margin:0;
padding:0;
text-align:center;
color:#000;
font-weight:bolder
}
body
{
}
ul, li
{
list-style:none;
text-indent:-9999em;
font-size:0
}
table
{
margin-bottom:25px
}
.emailWrapper
{
width:600px;
background:transparent url(http://www.euroluxantiques.com/App_Themes/EuroLux/images/BG/bg_Burlap.jpg) repeat
}
.important
{
font-size:14px;
color:red;
display:block;
margin:10px 0
}
p.center
{
text-align:justify
}
.basketTable, .basketTable td
{
border:solid 1px #ccc
}
.Email p
{
margin-bottom:10px;
text-align:left;
padding:5px
}
table.Header
{
width:588px
}
table.Email, table.Header
{
padding: 5px;
margin: 0px
}
table.Email th
{
background-color:#ccc
}
table.Email th, table.Email td
{
font-weight: bold;
font-size: 12px;
font-family: Arial, Verdana, Sans-Serif;
font-weight:bold;
text-decoration: none;
padding: 5px;
}
table.Email td
{
font-weight: normal;
background-color: #ffffff;
text-align: left;
padding: 3px;
}
/** Navigation Start **/
#navigation {
height:29px;
background:url(http://www.euroluxantiques.com/App_Themes/EuroLux/images/Headers/nav_LetterEmail.jpg) left top no-repeat;
/*padding-left:67px*/
}
#navigation ul li, #navigation ul li a {
height:29px;
display:block;
float:left;
width:auto
}
#navigation ul li a {
text-indent:-9999em;
overflow:hidden;
outline-style:none
}
#navigation ul li a:hover, #navigation ul li a:active {
background-repeat:no-repeat;
background-image:url(http://www.euroluxantiques.com/App_Themes/EuroLux/images/Headers/nav_LetterEmail.jpg)
}
#navigation ul li#nav-home, #navigation ul li#nav-home a {
width:100px
}
#navigation ul li#nav-home a:hover, #navigation ul li#nav-home a:active {
background-position:0px -29px
}
#navigation ul li#nav-search, #navigation ul li#nav-search a {
width:118px
}
#navigation ul li#nav-search a:hover, #navigation ul li#nav-search a:active {
background-position:-100px -29px;
}
#navigation ul li#nav-testimonials, #navigation ul li#nav-testimonials a {
width:189px
}
#navigation ul li#nav-testimonials a:hover, #navigation ul li#nav-testimonials a:active {
background-position:-218px -29px
}
#navigation ul li#nav-checkout, #navigation ul li#nav-checkout a {
width:181px
}
#navigation ul li#nav-checkout a:hover, #navigation ul li#nav-checkout a:active {
background-position:-407px -29px
}
/** Navigation End **/
</style>
</head>
<body>
<p>
</p>
<div class="emailWrapper">
<table class="Header">
<tr>
<td>
<img src="http://www.euroluxantiques.com/App_Themes/EuroLux/Images/Headers/Header_bg_Email.jpg">
</td></tr>
<td>
<div id="navigation">
<ul>
<li id="nav-home"><a href="http://www.euroluxantiques.com/Default.aspx">Home</a></li>
<li id="nav-search"><a href="http://www.euroluxantiques.com/AdvancedSearch.aspx">Search</a></li>
<li id="nav-testimonials"><a href="http://www.euroluxantiques.com/CustomerTestimonials.aspx">Customer Testimonials</a></li>
<li id="nav-checkout"><a href="http://www.euroluxantiques.com/Basket.aspx">Your Basket</a></li>
</ul>
</div>
</td></tr>
</table>
<table class="Email">
<tr>
<td colspan="2" class="Email">
Dear $customer.PrimaryAddress.FirstName,
<p><span class="important center">We noticed you did not complete your purchase at $store.Name.</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 items:</p>
<!-- *************************** -->
<!-- Do not change code between these two comments. If you need something changed contact Freeze Frame Graphics -->
<table class="basketTable" border="0" cellpadding="5" cellspacing="0" width="100%">
<tr>
<th>Item</th>
<th>Description</th>
<th>Quantity</th>
<th>Sales Price</th>
</tr>
<tbody>
#foreach($basketItem in $basket.Items)
<tr>
<td>$basketItem.Sku</td>
<td>$basketItem.Name</td>
<td>$basketItem.Quantity</td>
<td>$basketItem.Price.ToString("ulc")</td>
</tr>
#end
</tbody>
</table>
<!--*************************** -->
<!-- End of Do Not Change Code -->
<p>Simply <a href="http://www.euroluxantiques.com/Basket.aspx">click here</a> to finish placing your order and we'll ship those wonderful items to you as soon as possible.</p>
<p>If you encounter any further issues in completing your order, please feel free to call us at <span class="important">803-276-4001</span> and we will be happy to help you.
We look forward to seeing you again at $store.Name!</p>
<p>
Best Wishes,<br />
Aimee & Greg @ $store.Name
</p>
</td>
</tr>
</table>
</div>
</body>
</html>