Knowing how to access individual pieces of data is a great start to setting up your Klaviyo account to utilize the Shopper Approved integration. In this article, I will demonstrate how to loop through data in Klaviyo, particularly to get the product information from the data sent by Shopper Approved.

In another article, I created a new flow in Klaviyo to send a review link via SMS message to the customer. To make the experience more customized, I will instead send an email to the customer, detailing the products purchased and requesting a review.

To add a new email to your Kalviyo flow, you can drag and drop the email action from the left-hand bar onto your flow directly:

You can then click on that new email box in your flow and click "Configure Content" to open the email editor:

For this example, we can edit the Plain Text version of the email:

Similarly to the survey link in the SMS message created previously, we can create custom code to extract pieces of the JSON data from Shopper Approved. The first thing I want to extract in my example email is the order ID. The code for this in Klaviyo would be {{ event.order_id }}, extracting the order_id of the Shopper Approved event.

Now, I want to extract the product information. Because the product information is nested under "products" in the Shopper Approved data, we can not just put {{ event.products }}, since there's more than one piece of data for that key. We need to loop over each product and extract the data that way.

To do a "for" loop in Klaviyo, you can first declare the beginning and the end of your loop:

{% for item in event.products %}

{% endfor %}

This is going to loop through each product under "products" in the Shopper Approved event, and give it a name of "item." We can then extract the data for each item inside of our loop:

{% for item in event.products %}

{{ item.Description }}

{% endfor %}

This will print the description for each product. Now, my email gives the customer their order ID, lists the products to be reviews, and then I added the survey link again at the end, which would be the same code as from the SMS message:

Did this answer your question?