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.
euroluxantiques
Commander (CMDR)
Commander (CMDR)
Posts: 118
Joined: Sat Dec 20, 2008 11:27 pm

Re: Email Alert to the registered users with Abandoned Baskets

Post by euroluxantiques » Sat Jul 31, 2010 10:38 pm

I just implemented this on our site today. Pretty cool. I also modified the template code from Mary to fit our store. I'll attach it here, if anyone wants it.

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>
        &nbsp;</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>

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 » Wed Aug 04, 2010 11:42 am

Thanks a million Mary!
And Aimee & Greg for your version, which I used.
This looks really good.

Did you consider putting a coupon code in the email, for maybe 5 or 10 percent off?

michaewa
Ensign (ENS)
Ensign (ENS)
Posts: 20
Joined: Tue Nov 10, 2009 9:22 pm

Re: Email Alert to the registered users with Abandoned Baskets

Post by michaewa » Fri Oct 22, 2010 8:35 am

I'm a little late but found this great threat - thanks very much.

I added two buttons - one for free shipping, and one for $5 off so I can determine how much of an incentive to give them based on the size of their order.

Cheers!

amgym-jt
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 27
Joined: Mon Mar 17, 2008 12:35 pm

Re: Email Alert to the registered users with Abandoned Baskets

Post by amgym-jt » Wed Feb 02, 2011 4:46 pm

I am using AbleMods Jobs Scheduler to try and email reminders to users with Abandoned Shopping Carts. However, I can not get the items to show up in the email template that gets sent out. Following is the code of my email template. Is there something wrong with it? Also, ideally, i would like to pull the product minibasket image instead of the sku. How could i modify this code to get that result?

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() 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.american-gymnast.com/shop/App_Themes/AG-Grey/images/header_bg.gif) 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.american-gymnast.com/shop/App_Themes/AG-Grey/images/header_bg.gif)
            }
             #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>&nbsp;
            </p>
    <div class="emailWrapper">
    <table cellpadding="0" cellspacing="0" class="Header">
    <tr>
    <td><a href="http://www.american-gymnast.com/shop/Basket.aspx" target="_blank"><img src="http://www.american-gymnast.com/shop/App_Themes/AG-Grey/images/ag-basketalert-emailheader.jpg" alt="American Gymnast" width="595" height="95" /></a></td>
    </tr>
    </table>
    <table cellpadding="0" cellspacing="0" bordercolor="#666666" class="Email">
    <tr>
    <td colspan="2" class="Email">
    Dear $customer.PrimaryAddress.FirstName,


    <p><span class="important center">We noticed it's been 2 days since you left behind $basket.items.Count  items in your shopping cart at $store.Name.</span></p>
    <p> Did you encounter a problem checking out, or perhaps you got interrupted and didn't have time to finish your order. </p>
    <p>Just in case, we have saved the following items in your shopping cart:</p>
      <!-- *************************** -->
    <!-- Do not change code between these two comments.  -->
    <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.american-gymnast.com/shop/Basket.aspx" target="_blank">click here</a> to finish placing your order and we'll ship those  items to you as quickly as possible.</p>

    <p>If you encounter any further issues in completing your order, please feel free to call us Toll Free at <span class="important">1-877-789-2267</span> and we will be happy to help you.
    We look forward to seeing you again at $store.Name!</p>
    <p><em>
    Train Smart. Compete Hard!</em></p>
    <p>$store.Name </p></td>
    </tr>
    </table>
    </div>
    </body>
    </html>
This was code that I obtained from a previous post on this thread from freeze frame graphics.

euroluxantiques
Commander (CMDR)
Commander (CMDR)
Posts: 118
Joined: Sat Dec 20, 2008 11:27 pm

Re: Email Alert to the registered users with Abandoned Baskets

Post by euroluxantiques » Fri Feb 11, 2011 8:42 am

I'd like to extend this functionality a little bit because I get a lot of anonymous baskets, which I can't send follow-up emails to. Our closure rate on follow-up emails is really great, but it is a very low percentage of people who have logged in to create their baskets. Instead, I would like to do the following:

1) Create a popup on the home page that gives the visitor the option for signing up for our newsletter. (We may offer some sort of incentive to do so.)
2) If the user decides to join, send that email to our ConstantContact account (should be pretty straight-forward, as I already do this on our website) and create a cookie so we don't bother this user again with sign-up during future visits.
3) Use the email entered as the basis of the session, so that we can reduce the number of anonymous baskets.

Anybody know how to approach something like this???

mkeith1
Commander (CMDR)
Commander (CMDR)
Posts: 120
Joined: Wed Jul 25, 2007 12:46 pm
Contact:

Re: Email Alert to the registered users with Abandoned Baskets

Post by mkeith1 » Mon Apr 18, 2011 10:42 am

i'm using this code for the email

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.musicmart.com/App_Themes/Music_Green_Racer/images/logo.png">
</td></tr>
<td style="background-color: #ffffff; 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: #ffffffc; 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.musicmart.com/Default.aspx" class="tab">Home</a>&nbsp;&nbsp;&nbsp;&nbsp;
            <a href="http://www.musicmart.com/Search.aspx" class="tab">Product Finder</a>&nbsp;&nbsp;&nbsp;&nbsp;   
            <a href="http://www.musicmart.com/AdvancedSearch.aspx" class="tab">Advanced Search</a>&nbsp;&nbsp;&nbsp;&nbsp;   
            <a href="http://www.musicmart.com/ContactUs.aspx" class="tab">Contact Us</a>&nbsp;&nbsp;&nbsp;&nbsp;
                #if($customer.IsAnonymous)
               <a href="http://www.www.musicmart.com/Login.aspx" class="login">Login</a>&nbsp;&nbsp;&nbsp;&nbsp;
            #else
               <a href="http://www.musicmart.com/Logout.aspx" class="login">Logout</a>&nbsp;&nbsp;&nbsp;&nbsp;
            #end
            <a href="http://www.musicmart.com/Members/MyAccount.aspx" class="acct">Account</a>&nbsp;&nbsp;&nbsp;&nbsp;
            <a href="http://www.musicmart.com/Members/MyWishlist.aspx" class="wishlist">Wishlist</a>&nbsp;&nbsp;&nbsp;&nbsp;
            <a href="http://www.musicmart.com/Basket.aspx" class="basket">Cart</a>&nbsp;&nbsp;&nbsp;&nbsp;
            #if($customer.IsAdmin)
               <a href="http://www.musicmart.com.com/Admin/Default.aspx" class="admin">Admin</a>&nbsp;&nbsp;&nbsp;&nbsp;
            #end
</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.musicmart.com/Basket.aspx">click here</a> to finish placing your order and we'll ship these 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">1-800-545-6204, ext 721</span> and we will be happy to help you.
We look forward to seeing you again!</p>
<p>
Best Wishes,<br />
Mike Keith, Music Mart
</p>

</td>
</tr>
</table>
</div>
</body>
</html>
but when i received the BCC email the customer's name appears like this in the email:

Dear $customer.PrimaryAddress.FirstName,

We noticed you did not complete your purchase at Music Mart.
Did you encounter a problem checking out? Just in case you did, we have saved those items in your cart......
_____

is this correct?

Post Reply