Need help with getting my transactional email star rating system to automaticall
ID: 3826396 • Letter: N
Question
Need help with getting my transactional email star rating system to automatically update on the website. So basically every time someone orders something they are automatically sent an email thanking them for their transaction and at the bottom there is a star rating system for the product they bought. Right now I have it so that it just redirects them to the product on my website for a review when they click on any of the stars, but what I would like is for it to automaically update the website whenever some clicks any of the stars in the email without the redirect. Is this possible? Below is my current code.
<body>
<div>
<table cellspacing="0" cellpadding="0" border="0" height="100%" width="100%">
<tr>
<td align="center" valign="top">
<!-- [ header starts here] -->
<table bgcolor="#FFFFFF" cellspacing="0" cellpadding="10" border="0" width="650">
<tr>
<td valign="top"><a href="{{store url=""}}"><img src="{{var logo_url}}" alt="{{var logo_alt}}" border="0"/></a></td>
</tr>
<!-- [ middle starts here] -->
<tr>
<td valign="top">
<h1>Dear {{htmlescape var=$order.getCustomerName()}},</h1>
<p>
Your order # {{var order.increment_id}} has been <br/>
<strong>{{var order.getStatusLabel()}}</strong>.
</p>
<p>You can check the status of your order by <a href="{{store url="customer/account/"}}">logging into your account</a>.</p>
<p>{{var comment}}</p>
<p>
If you have any questions, please feel free to contact us at
<a href="mailto:{{config path='trans_email/ident_support/email'}}">{{config path='trans_email/ident_support/email'}}</a>
or by phone at {{config path='general/store_information/phone'}}.
</p>
<!-- Star rating system -->
<table width="320" border="0" align="center" cellpadding="5" cellspacing="0">
<tr>
<td><p>How would you rate the <span>quality</span> of this product?</p>
<h1><div class="rating"> <a href="https://hoshizakiicemaker.com/review/product/list/id/677/category/383/" title="5"></a>
<a href="https://hoshizakiicemaker.com/review/product/list/id/677/category/383/" title="4"></a>
<a href="https://hoshizakiicemaker.com/review/product/list/id/677/category/383/" title="3"></a>
<a href="https://hoshizakiicemaker.com/review/product/list/id/677/category/383/" title="2"></a>
<a href="https://hoshizakiicemaker.com/review/product/list/id/677/category/383/" title="1"></a></div></h1>
<p><span class="subtext">(select 1-5 stars)</span></p></td>
</tr>
</table>
</td>
</tr>
<tr>
<td bgcolor="#EAEAEA" align="center"><center><p>Thank you again, <strong>{{var store.getFrontendName()}}</strong></p></center></td>
</tr>
</table>
</td>
</tr>
</table>
</div>
</body>
Explanation / Answer
The code you have written is an good one. you have given href link to every star in your email to the webpage of the product, which leads you there. Then as part of your rating you have already included "HOW DO YOU RATE THIS PRODUCT? with quality, price, value and a mandatory part of user's review" in your website. The star rating triggered from your mail will reach your website to complete the process as you have kept it mandatory. Other thing is if you submit directly from your mail you will also face a problem for which product the user has rated which will also lead to unclarity. you can even try by adding a "submit" button in you email along with the stars (without href to product page) linking up to ur database which is used for storage, which helps to skip away without linking to product page.