Email Template for Sales Order

When a Sales order is created, mail sends to the customer, admin, and sales rep. Created 3 Email templates.

Jira code : MT – 14

Customer Mail Template

<table id="content" style="width: 976px;">
<tbody>
	<tr>
	<td style="height: 42px; width: 126px;"> </td>
	<td style="height: 42px; width: 235px;"><img alt="" src="http://shopping.netsuite.com/core/media/media.nl?id=62&c=5019428_SB1&h=d202286482b3bfa4f8a1" style="width: 250px; height: 44px;" /></td>
	<td style="height: 42px; width: 328px;"> </td>
	<td colspan="4" rowspan="1" style="height: 42px; width: 208px;">
	<div><strong>${companyinformation.mainaddress_text}</strong></div>
	<strong>${companyinformation.custrecord_jj_phone}</strong><br />
	 </td>
	</tr>
	<tr>
	<td style="height: 8px; width: 126px;"> </td>
	<td colspan="6" rowspan="1" style="width: 834px;">
	<hr style="border: solid 1.5px;color:#d6d9db;" /></td>
	</tr>
	<tr>
	<td style="height: 37px; width: 126px;"> </td>
	<td style="height: 37px; width: 235px;"><span style="font-size: 16px;"><b>Order #: </b></span>${transaction.tranId}<br />
	<span style="font-size:16px;"><strong>Order Date</strong></span>: ${transaction.tranDate}</td>
	<td style="height: 37px; width: 328px;"> </td>
	<td colspan="4" style="height: 37px; width: 208px;"> </td>
	</tr>
	<tr>
	<td style="width: 126px; height: 30px;"> </td>
	<td style="width: 196px; height: 30px; padding-left: 40px;"><strong style="background-color: rgb(255, 255, 255);">Bill To</strong><br />
	${transaction.billaddress}</td>
	<td style="width: 328px; height: 30px;"> </td>
	<td colspan="3" rowspan="1" style="width: 223px; height: 30px;"><strong style="background-color: rgb(255, 255, 255);">Ship To</strong><br />
	${transaction.shipaddress}</td>
	</tr>
	<tr>
	<td style="width: 126px; height: 10px;"> </td>
	<td colspan="5" style="width: 832px; height: 5px;">
	<hr style="border: solid 1.5px;color:#d6d9db;height: 1px;" /></td>
	</tr>
	<tr>
	<td style="width: 126px; height: 78px;"> </td>
	<td colspan="4" rowspan="1" style="width: 830px; height: 78px;"><strong><span style="font-size:14px;"><span style="3D,font-family:Verdana,Geneva,sans-serif;">          Order Summary</span></span></strong> <br />
	 
	<table border="1" bordercolor="#ccc" cellpadding="5" cellspacing="0" style="border-collapse:collapse;">
	<tbody>
	</tbody>
	</table>

	<table align="center" border="1" bordercolor="#ccc" cellpadding="5" cellspacing="0" style="width:767px;">
	<thead>
		<tr>
		<th style="width: 200px;">Item Name</th>
		<th style="width: 200px;">Quantity</th>
		<th style="width: 200px;">Rate</th>
		<th style="width: 187px;">Amount</th>
		</tr>
	</thead>
	<#list transaction.item as listItem>
	<tbody>
		<tr>
		<td style="text-align: center; width: 200px;">${listItem.item}</td>
		<td style="text-align: center; width: 200px;">${listItem.quantity}</td>
		<td style="text-align: center; width: 200px;">${listItem.rate}</td>
		<td style="text-align: center; width: 187px;">${listItem.amount}</td>
		</tr>
		</#list>
	</tbody>
	</table>
	</td>
	</tr>
	<tr>
	<td style="width: 126px; height: 69px;"> </td>
	<td colspan="3" rowspan="1" style="width: 827px; height: 68px; border: 1.5px solid rgb(51, 51, 51);">
	<table cellpadding="1" cellspacing="1" style="width: 842px;">
	<tbody>
		<tr>
		<td style="width: 300px; height: 65px;"><strong><span style="font-size:11.0pt"><span style="line-height:115%"><span style="font-family:Verdana,Geneva,sans-serif;">Please Remit Payment By</span></span></span></strong><span style="font-size:11.0pt"><span style="line-height:100%"><span style="font-family:"Calibri","sans-serif"">:<br />
		${transaction.custbody1} </span></span></span></td>
		<td style="width: 539px; height: 65px;"><br />
		<span style="font-size:11pt"><span style="line-height:90%"><span style="font-family:Verdana,Geneva,sans-serif;"><span style="font-size:13px;"><span style="background:white; padding-left: 240px;">          Subtotal:${transaction.total}</span><br />
		<span style="background:white;padding-left: 270px;">   Discount:${transaction.discounttotal}</span><br />
		<strong><span style="background:white; padding-left: 305px;">Total:${transaction.total} </span></strong></span></span></span></span></td>
		</tr>
	</tbody>
	</table>
	</td>
	</tr>
	<tr>
	<td style="width: 126px; height: 156px;"> </td>
	<td colspan="5" rowspan="1" style="width: 823px; height: 147px; padding-left: 10px;">
	<table cellpadding="1" cellspacing="1" style="width: 817px;">
	<tbody>
		<tr>
		<td style="width: 353px; height: 144px;"><span style="font-size:14px;"><span style="line-height:115%"><span style="font-family:Verdana,Geneva,sans-serif;"><strong><span style="font-family:Verdana,Geneva,sans-serif;">Remit Wire Transfer To</span></strong><span style="font-family:Verdana,Geneva,sans-serif;">:   </span></span></span></span><br />
		${companyinformation.custrecord_jj_wire_info}<span style="font-size:14px;"><span style="line-height:115%"><span style="font-family:Calibri,sans-serif"><span style="font-family:Verdana,Geneva,sans-serif;">                                   <br />
		<strong><span style="font-family:Verdana,Geneva,sans-serif;">Account#: </span></strong></span></span></span></span>${companyinformation.custrecord_jj_account_number}<br />
		<span style="font-size:14px;"><span style="line-height:115%"><span style="font-family:Calibri,sans-serif"><span style="font-family:Verdana,Geneva,sans-serif;"><strong><span style="font-family:Verdana,Geneva,sans-serif;">ABA #</span></strong>: </span></span></span></span>${companyinformation.custrecord_jj_aba_number}<br />
		<span style="font-size:14px;"><span style="line-height:115%"><span style="font-family:Calibri,sans-serif"><span style="font-family:Verdana,Geneva,sans-serif;"><strong><span style="font-family:Verdana,Geneva,sans-serif;">Swift #</span></strong>: </span></span></span></span>${companyinformation.custrecord_jj_swift_code}</td>
		<td style="width: 427px; height: 144px;"><br />
		<span style="font-size:14px;"><strong><span style="line-height:115%"><span style="font-family:Verdana,Geneva,sans-serif;">Pickup Address</span></span></strong><span style="line-height:115%"><span style="font-family:Verdana,Geneva,sans-serif;">:</span></span></span><br />
		${companyinformation.mainaddress_text}<br />
		<br />
		<span style="font-size:14px;"><span style="line-height:115%"><span style="font-family:"Arial","sans-serif""><strong><span style="font-family:"Arial","sans-serif"">Shipping Contact</span></strong>:</span></span></span><br />
		${companyinformation.custrecord_jj_shipping_contact}<br />
		<br />
		<span style="font-size:14px;"><span style="line-height:115%"><span style="font-family:"Arial","sans-serif""><strong><span style="font-family:"Arial","sans-serif"">Hours</span></strong>: 9.00am - 4.30pm EST Monday-Friday</span></span></span></td>
		</tr>
	</tbody>
	</table>
	</td>
	</tr>
	<tr>
	<td style="width: 126px; height: 49px;"> </td>
	<td colspan="5" style="width: 828px; height: 49px; text-align: center; border-color: rgb(51, 51, 51); border-style: solid; border-width: medium;">STANDARD TERMS AND CONDITIONS APPLY<br />
	 
	<div><strong><span style="padding-right: 200px;">*ALL SALES FINAL</span>   </strong>*<strong>NO CREDITS   </strong><span style="padding-left: 200px;">*<strong>PRODUCTS SOLD AS IS</strong></span></div>
	</td>
	</tr>
	<tr>
	<td style="width: 126px; height: 15px;"> </td>
	<td colspan="5" style="width: 832px; height: 15px; text-align: center;">
	<hr style="border: solid 1.5px;color:#d6d9db;" /></td>
	</tr>
	<tr>
	<td style="width: 126px; height: 18px;"> </td>
	<td colspan="4" style="width: 830px; height: 18px;"><span style="background-color: rgb(255, 255, 255);">                                                    If you are a registered customer, you can  </span><a href="https://checkout.na3.netsuite.com/c.5019428/sca-dev-aconcagua/checkout.ssp?fragment=login-register&is=login&login=T&n=2#login-register" target="_blank">log in </a><span style="background-color: rgb(255, 255, 255);">to see your order status     </span></td>
	</tr>
</tbody>
</table>

Admin mail Template

<br />
       
<table id="salesrep_content">
<tbody>
	<tr>
	<td style="height: 78px; width: 185px;">                                                            </td>
	<td colspan="2" rowspan="1" style="height: 78px; width: 535px;"><br />
	<br />
	<span style="font-size:16px;"><strong>Dear</strong>,</span><br />
	<br />
	<span style="font-size:14px;"><span style="3D,font-family:Verdana,Geneva,sans-serif;"><span class="marker">A new order has placed with details attached.</span></span></span><br />
	<br />
	                                                                              </td>
	<td style="width: 266px; height: 78px;">
	<table>
	<tbody>
		<tr>
		<td style="3D,height: 70px; width: 266px;"><img alt="" src="http://shopping.netsuite.com/core/media/media.nl?id=62&c=5019428_SB1&h=d202286482b3bfa4f8a1" style="height: 45px; width: 250px;" /></td>
		</tr>
	</tbody>
	</table>
	</td>
	</tr>
	<tr>
	<td style="width: 185px; height: 50px;"> </td>
	<td colspan="3" rowspan="1" style="width: 807px; height: 50px;"><span style="font-size:14px;"><span style="3Dfont-family:Verdana,Geneva,sans-serif;"><span class="marker">Customer Name: ${customer.entityId}<br />
	Order Number: ${transaction.tranId}</span></span></span>
	<hr style="border: solid 1.5px;color:#d6d9db;" /></td>
	</tr>
	<tr>
	<td style="width: 185px; height: 35px;">                                                          </td>
	<td colspan="3" rowspan="1" style="width: 807px; height: 35px;"><strong><span style="font-size:14px;"><span style="3D,font-family:Verdana,Geneva,sans-serif;">Order Summary</span></span></strong><br />
	 
	<table border="1" bordercolor="#ccc" cellpadding="5" cellspacing="0" style="border-collapse:collapse;">
	<tbody>
	</tbody>
	</table>

	<table align="left" border="1" bordercolor="#ccc" cellpadding="5" cellspacing="0" style="width:639px;">
	<thead>
		<tr>
		<th style="width: 153px;">Item Name</th>
		<th style="width: 158px;">Quantity</th>
		<th style="width: 141px;">Rate</th>
		<th style="width: 137px;">Amount</th>
		</tr>
	</thead>
	<#list transaction.item as listItem>
	<tbody>
		<tr>
		<td style="text-align: center; width: 153px;">${listItem.item}</td>
		<td style="text-align: center; width: 158px;">${listItem.quantity}</td>
		<td style="text-align: center; width: 141px;">${listItem.rate}</td>
		<td style="text-align: center; width: 137px;">${listItem.amount}</td>
		</tr>
		</#list>
	</tbody>
	</table>
	<br />
	<br />
	<br />
	 </td>
	</tr>
</tbody>
</table>

Sales rep Mail Template

<br />
       
<table id="salesrep_content">
<tbody>
	<tr>
	<td style="height: 78px; width: 157px;">                                                            </td>
	<td colspan="2" rowspan="1" style="height: 78px; width: 569px;"><br />
	<br />
	<span style="font-size:16px;"><strong>Dear ${salesrep.firstName} ${salesrep.middleName} ${salesrep.lastName}</strong><b>,</b></span><br />
	<br />
	<span style="font-size:14px;"><span style="3D,font-family:Verdana,Geneva,sans-serif;"><span class="marker">A new order has placed with details attached.</span></span></span><br />
	<br />
	                                                                              </td>
	<td style="width: 260px; height: 78px;">
	<table>
	<tbody>
		<tr>
		<td style="3D,height: 70px; width: 266px;"><img alt="" src="http://shopping.netsuite.com/core/media/media.nl?id=62&c=5019428_SB1&h=d202286482b3bfa4f8a1" style="height: 45px; width: 250px;" /></td>
		</tr>
	</tbody>
	</table>
	</td>
	</tr>
	<tr>
	<td style="width: 157px; height: 50px;"> </td>
	<td colspan="3" rowspan="1" style="width: 835px; height: 50px;"><span style="font-size:14px;"><span style="3Dfont-family:Verdana,Geneva,sans-serif;"><span class="marker">Customer Name : ${customer.entityId}<br />
	Order Number : ${transaction.tranId}</span></span></span>
	<hr style="border: solid 1.5px;color:#d6d9db;" /></td>
	</tr>
	<tr>
	<td style="width: 157px; height: 35px;">                                                          </td>
	<td colspan="3" rowspan="1" style="width: 835px; height: 35px;"><strong><span style="font-size:14px;"><span style="3D,font-family:Verdana,Geneva,sans-serif;">Order Summary</span></span></strong><br />
	 
	<table border="1" bordercolor="#ccc" cellpadding="5" cellspacing="0" style="border-collapse:collapse;">
	<tbody>
	</tbody>
	</table>

	<table align="left" border="1" bordercolor="#ccc" cellpadding="5" cellspacing="0" style="width:639px;">
	<thead>
		<tr>
		<th style="width: 153px;">Item Name</th>
		<th style="width: 158px;">Quantity</th>
		<th style="width: 141px;">Rate</th>
		<th style="width: 137px;">Amount</th>
		</tr>
	</thead>
	<#list transaction.item as listItem>
	<tbody>
		<tr>
		<td style="text-align: center; width: 153px;">${listItem.item}</td>
		<td style="text-align: center; width: 158px;">${listItem.quantity}</td>
		<td style="text-align: center; width: 141px;">${listItem.rate}</td>
		<td style="text-align: center; width: 137px;">${listItem.amount}</td>
		</tr>
		</#list>
	</tbody>
	</table>
	<br />
	<br />
	<br />
	 </td>
	</tr>
</tbody>
</table>

Leave a comment

Your email address will not be published. Required fields are marked *