Linnworks Order Management and Stock Control system is capable of generating and sending automated HTML emails when an order is despatched, returned, exchanged or resent. In addition Linnworks can attach invoice and return form as PDF to the email generated. This documentation describes how to set this functionality up.
It is possible to setup multiple email accounts, which will allow outgoing email to be tied to a Source/SubSource by a condition.
Configuration
will output 3 when the email is generated.
will output Order is from eBay if the order source equals EBAY, otherwise will output Order is not from eBay.
will output the list of all order items as OrderItemNumber – Order Item Title x Quantity.
You can have multiple templates for a single template type. Each additional template will be conditional. You can specify conditions as direct logical function, for example
will apply this template only if this order is from Amazon or eBay.
Double click on the template type you want to edit in the Templates grid.
Once an additional email account has been configured (as shown above) it is possible to select which account is used for sending
|
Fig 3.1 |
|
Use menu bar to access the data tags and iterations.
- Iterations. Inserts FOREACH()<>
Note: when using inside HTML formatted email edit the FOREACH to look like.
- Inserts a data tag. Each data tag refers to a data value in the order you are generating the email for. The data tags are arranged by tables they belong to.
- Inserts evaluation tag EVAL<>
Note: When using inside HTML formatted email, change the tag to.
Dear, [{ORDER.CFULLNAME}].
Thank you for your purchase with us through [{ORDER.SOURCE}] order reference [{ORDER.REFERENCENUM}], our system order number [{ORDER.NORDERID}] on [{ORDER.DRECEIEVEDDATE}].
I am glad to inform you that the order has been despatched with [{ADD-IN.SHIPPINGMETHOD}] on [{ORDER.DPROCESSEDON}]
You order details:
[{ORDER.CSHIPPINGADDRESS}]
Products:
FOREACH(OrderItems)<
[{ORDERITEMS.ITEMNUMBER}] - [{ORDERITEMS.ITEMTITLE}] x [{ORDERITEMS.NQTY}] [{ORDERITEMS.FPRICEPERUNIT}] [{ORDER.CCURRENCY}] each
>
SubTotal: EVAL<N2[[{ORDER.FTOTALCHARGE}]-[{ORDER.FPOSTAGECOST}]-[{ORDER.FTAX}]]> [{ORDER.CCURRENCY}]
P&P Cost: [{ORDER.FPOSTAGECOST}] [{ORDER.CCURRENCY}]
Tax: [{ORDER.FTAX}] [{ORDER.CCURRENCY}]
Total: [{ORDER.FTOTALCHARGE}] [{ORDER.CCURRENCY}]
Calculated TAX (15% inclusive) : EVAL<N2[[{ORDER.FTOTALCHARGE}] * 15 / 115]> [{ORDER.CCURRENCY}]
EVAL<IIF["[{ORDER.POSTALTRACKINGNUMBER}]"="","",concat["Postage Tracking number: ","[{ORDER.POSTALTRACKINGNUMBER}]"]]>
EVAL<IIF["[{ORDER.SHIPPINGMETHOD}]"="MyCourier",concat["http://mycourier.com/?tracking=","[{ORDER.POSTALTRACKINGNUMBER}]"],""]>
EVAL<IIF["[{ORDER.SOURCE}]"="EBAY","Thank you for buying from our excellent eBay shop, please leave feedback.",""]>
EVAL<IIF["[{ORDER.SOURCE}]"="AMAZON","Thank you for buying from our excellent Amazon shop, please leave feedback.",""]>
EVAL<IIF["[{ORDER.SOURCE}]"="WEBSITE","Thank you for buying from our excellent shop www.myshop.com. Visit us again.",""]>
EVAL<IIF["[{ORDER.SOURCE}]"="DUMMY","Source related text will go here",""]>
Best Wishes
The Data tags are highlighted in bold.
Foreach iteration highlighted in blue.
The evaluation expression is highlighted in orange.
Expression function is highlighted in red.
|
Fig 1.1 |
<body style="background:#F6F6F6; font-family:Verdana, Arial, Helvetica, sans-serif; fontsize:12px; margin:0; padding:0;">
<div style="background:#F6F6F6; font-family:Verdana, Arial, Helvetica, sans-serif; fontsize:12px; margin:0; padding:0;">
<table cellspacing="0" cellpadding="0" border="0" height="100%" width="100%">
<tr>
<td align="center" valign="top" style="padding:20px 0 20px 0">
<table bgcolor="#FFFFFF" cellspacing="0" cellpadding="10" border="0" width="700" style="border:1px solid #093f56;">
<!-- Header -->
<tr>
<td bgcolor="#0088c1" valign="top">
<a href="http://www.linnsystems.com"}}"><img src="http://www.linnsystems.com/img/linnsystems-logo.png" width="177" height="92" alt="Linn Systems" style="margin-bottom:10px;" border="0"/></a>
</td>
</tr>
<!-- Body -->
<tr>
<td valign="top">
<h1 style="font-size:20px; font-weight:normal; line-height:22px; margin:0 0 11px 0;> Hello, [{ORDER.CFULLNAME}] </h1>
</td>
</tr>
<tr>
<td>
<h2 style="font-size:16px; font-weight:normal; margin:0;"> Thank you for your order which we are happy to inform your has now been shipped with [{ADD-IN.SHIPPINGMETHOD}] on [{ORDER.DPROCESSEDON}] </h2>
</td>
</tr>
<tr>
<td>
<!-- Shipping --> Shipping details:<br><br>
<table cellspacing="0" cellpadding="0" border="0" width="100%">
<thead>
<tr>
<th align="left" width="325" bgcolor="#EAEAEA" style="fontsize:13px; padding:5px 9px 6px 9px; line-height:1em;">Shipping Information:</th>
<th width="10"></th>
<th align="left" width="325" bgcolor="#EAEAEA" style="fontsize:13px; padding:5px 9px 6px 9px; line-height:1em;">Shipping Method:</th>
</tr>
</thead>
<tbody>
<tr>
<td valign="top" style="font-size:12px; padding:7px 9px 9px 9px; border-left:1px solid #EAEAEA; border-bottom:1px solid #EAEAEA; border-right:1px solid #EAEAEA;"> [{ORDER.CSHIPPINGADDRESS}] </td>
<td> </td>
<td valign="top" style="font-size:12px; padding:7px 9px 9px 9px; border-left:1px solid #EAEAEA; border-bottom:1px solid #EAEAEA; border-right:1px solid #EAEAEA;"> [{ADD-IN.SHIPPINGMETHOD}] </td>
</tr>
</tbody>
</table>
<br> EVAL<IIF["[{ORDER.POSTALTRACKINGNUMBER}]"="","", concat["Postage Tracking number:","[{ORDER.POSTALTRACKINGNUMBER}]"]]>
<!-- Order Details -->
<br/><br/><br/> Your order details:
<br><br> Our Reference Number : [{ORDER.NORDERID}]
EVAL<IIF["[{ORDER.SOURCE}]"="EBAY","eBay Reference number: [{ORDER.REFERENCENUM}]",""]>
EVAL<IIF["[{ORDER.SOURCE}]"="AMAZON","Amazon Reference number: [{ORDER.REFERENCENUM}]",""]>
EVAL<IIF["[{ORDER.SOURCE}]"="WEBSITE","Web Shop Reference number: [{ORDER.REFERENCENUM}]",""]>
<table cellspacing="0" cellpadding="0" border="0" width="100%">
<thead>
<tr>
<th align="left" width="450" bgcolor="#EAEAEA" style="fontsize:13px; padding:5px 9px 6px 9px; line-height:1em;">Item Information</th>
<th width="10"></th>
<th align="left" width="100" bgcolor="#EAEAEA" style="fontsize:13px; padding:5px 9px 6px 9px; line-height:1em;">Cost (Each)</th>
<th align="left" width="100" bgcolor="#EAEAEA" style="fontsize:13px; padding:5px 9px 6px 9px; line-height:1em;">Cost </th>
</tr>
</thead>
<tbody> FOREACH(OrderItems){BEGIN}
<tr>
<td valign="top" style="font-size:12px; padding:7px 9px 9px 9px; border-left:1px solid #EAEAEA; border-bottom:1px solid #EAEAEA; border-right:1px solid #EAEAEA;"> Item Number ~ [{ORDERITEMS.ITEMNUMBER}] <br/> [{ORDERITEMS.ITEMTITLE}] x [{ORDERITEMS.NQTY}] </td>
<td> </td>
<td valign="top" style="font-size:12px; padding:7px 9px 9px 9px; border-left:1px solid #EAEAEA; border-bottom:1px solid #EAEAEA; border-right:1px solid #EAEAEA;"> [{ORDERITEMS.FPRICEPERUNIT}] [{ORDER.CCURRENCY}] </td>
<td valign="top" style="font-size:12px; padding:7px 9px 9px 9px; border-left:1px solid #EAEAEA; border-bottom:1px solid #EAEAEA; border-right:1px solid #EAEAEA;"> [{ORDERITEMS.FPRICEPERUNIT}] [{ORDER.CCURRENCY}] </td>
</tr> {END}
</tbody>
</table>
<!-- Order total -->
<table cellspacing="0" cellpadding="0" border="0" width="100%">
<tbody>
<tr>
<td width= "545" align="right" valign="top" style="font-size:12px; padding:7px 9px 9px 9px; border-left:1px solid #EAEAEA;"> SubTotal: </td>
<td valign="top" style="font-size:12px; padding:7px 9px 9px 9px;"> EVAL<N2[[{ORDER.FTOTALCHARGE}]-[{ORDER.FPOSTAGECOST}]-[{ORDER.FTAX}]]> [{ORDER.CCURRENCY}] </td>
</tr>
<tr>
<td width= "545" align="right" valign="top" style="font-size:12px; padding:7px 9px 9px 9px;"> P&P Cost: </td>
<td valign="top" style="font-size:12px; padding:7px 9px 9px 9px;"> [{ORDER.FPOSTAGECOST}] [{ORDER.CCURRENCY}] </td>
</tr>
<tr>
<td width= "545" align="right" valign="top" style="font-size:12px; padding:7px 9px 9px 9px;"> Tax: </td>
<td valign="top" style="font-size:12px; padding:7px 9px 9px 9px; "> [{ORDER.FTAX}] [{ORDER.CCURRENCY}] </td>
</tr>
<tr>
<td width= "545" align="right" valign="top" style="font-size:12px; padding:7px 9px 9px 9px;"> Total: </td>
<td valign="top" style="font-size:12px; padding:7px 9px 9px 9px;"> [{ORDER.FTOTALCHARGE}] [{ORDER.CCURRENCY}] </td>
</tr>
</tbody>
</table>
<br><br><br>
EVAL<IIF["[{ORDER.SOURCE}]"="EBAY","Thank you for buying from our excellent eBay shop, please leave feedback.",""]>
EVAL<IIF["[{ORDER.SOURCE}]"="AMAZON","Thank you for buying from our excellent Amazon shop, please leave feedback.",""]>
EVAL<IIF["[{ORDER.SOURCE}]"="WEBSITE","Thank you for buying from our excellent shop www.LinnSystems.com, please visit us again.",""]>
EVAL<IIF["[{ORDER.SOURCE}]"="DUMMY","Source related text will go here",""]>
</td>
</tr>
<!-- Footer -->
<tr>
<td bgcolor="#EAEAEA" align="center" style="background:#0088c1; textalign:center;"> <center>
<p style="font-size:12px; margin:0;"><strong>Linn Systems Ltd</strong></p>
<p style="font-size:12px; margin:0;">email: info@LinnSystems.com</p>
<p style="font-size:12px; margin:0;">telephone: +44 020 3651 7045</p>
</center> </td>
</tr>
</table>
</td>
</tr>
</table>
</div>
</body>
Conditional fields available:
Examples of the conditions:
when source of the order is EBAY or AMAZON
when source of the order is EBAY and the order came from the primary ebay account, i.e. subsource is EBAY0
when country is France and order is not from eBay or when order is from France and subsource is specific amazon account with the name My French Amazon Account.
For Example
Condition 1 Source <> 'AMAZON' AND Source <> 'EBAY'
Condition 2 Source = '3DCART'
In this example the email template associated with Condition 2 will never be used as it is fulfilled by Condition 1
To allow Condition 2 to be used Condition 1 needs to changed to Source <> 'AMAZON' AND Source <> 'EBAY' AND Source <> '3DCART'
To preview the template click Preview Dummy. On the email template edit screen – this will produce the email body as per dummy order.