All Collections
Integrations
Klaviyo
Add a Rating Aggregate to Abandoned Cart Emails in Klaviyo (New Editor)
Add a Rating Aggregate to Abandoned Cart Emails in Klaviyo (New Editor)
Norma Cooper avatar
Written by Norma Cooper
Updated over a week ago
This feature is available on the "Power" plan and above

Adding a rating aggregate to your abandoned cart emails will dynamically pull in product star ratings.

Once you have completed the following instructions, you’ll see your product star ratings appear under the product title in your abandoned cart emails.

Enable your Klaviyo Feed

  1. Open your Okendo app

  2. Click "Settings"

  3. Click "Integrations"

  4. Click the pencil icon next to Klaviyo

  5. Turn on the "Enable Product Review Aggregate Feed" toggle

  6. Click "Save"

⚠️ Note: Once enabled, allow up to 24 hours for your feed to be populated before continuing.

Add the Product Review Aggregate Feed

Navigate to your Klaviyo account > Settings > Web Feeds > Add Web Feed.

Input the following data into the spaces and click update.

Required name: product_review_aggregate

Request Method: GET

Content-Type: JSON

⚠️ Note: In Klaviyo’s New Editor, web feeds are automatically enabled so you don’t need to action anything further.

Adding Star Rating Under Product Title

Select the product block, where the products from the cart will populate. The example below is within the Shopify Abandoned Cart Reminder Flow.

On your left panel, select "Rows" > "Data Source" and confirm that you are using the correct “Row Collection” and “Row Alias”.

Row Collection: event.extra.line_items

Row Alias: item

On that same left panel, select "Column 2" > "Source" then paste the below snippet of code under an existing Quantity <p> tag.

{% with product=item.product %} {% with productId=item.product.id|slugify %}</p>
</div>
{% for value in feeds.product_review_aggregate %}{% if productId == value.product_id %}
<table style="border: 0;" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td style="padding-top: 2px; padding-right: 2px;"><img style="height: 14px;" src="https://d3hw6dc1ow8pp2.cloudfront.net/emails/review/stars/stars-{% widthratio value.rating 1 10 %}-000000.png" height="14" /></td>
<td>
<p style="padding-top: 1px; padding-left: 2px; font-size: 14px;">{{ value.count }} {% if value.count > 1 %} Reviews {% endif %}{% if value.count == 1 %} Review {% endif %}</p>
</td>
</tr>
</tbody>
</table>
{% endif %}{% endfor %}
<div>{% endwith %} {% endwith %}</div>

⚠️ Note: If you aren’t using the standard Data Source (item.product.title) you’ll need to use the below custom event snippet of code.

{% with productId=event.ProductID|slugify %} {% for value in feeds.product_review_aggregate %} {% if productId == value.product_id %}
<table cellpadding="0" cellspacing="0" style="border:0;">
<tbody>
<tr>
<td style="padding-top:2px;padding-right:2px"><img height="14" src="https://d3hw6dc1ow8pp2.cloudfront.net/emails/review/stars/stars-{% widthratio value.rating 1 10 %}-000000.png" style="height:14px;" /></td>
<td>
<p style="padding-top:1px;padding-left:2px;font-size:14px;">{{ value.count }} {% if value.count > 1 %} Reviews {% endif %}{% if value.count == 1 %} Review {% endif %}</p>
</td>
</tr>
</tbody>
</table>
{% endif %} {% endfor %} {% endwith %}

If you’d like to update the star colour, please contact support@okendo.io.

To insert a reviews block, please see our help article here.

Did this answer your question?