Hi,
I need to create an email template where I have to be able to show the last product the user has bought and indicate the subcategory to which it belongs. Can someone explain me the steps to make it possible? I dont find the way to insert the LAST product bought, maybe doing something with the creation date of it?
Thanks in advance.
Kind regards,
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
Hi @bcollado,
I understand that a recipient can place multiple orders and an order can possibly have multiple products in it. For this, you will need to implement enrichment activity in your workflow to get the last order or product ID placed by the customer, and then you can use in the email for personalization as an extension of the target data.
The syntax would possibly look like: <%= targetData.lastOrderId %>.
I hope you got the gist of how to go about it.
BR,
Ishan
Hi @bcollado,
I understand that a recipient can place multiple orders and an order can possibly have multiple products in it. For this, you will need to implement enrichment activity in your workflow to get the last order or product ID placed by the customer, and then you can use in the email for personalization as an extension of the target data.
The syntax would possibly look like: <%= targetData.lastOrderId %>.
I hope you got the gist of how to go about it.
BR,
Ishan
Hi Ishan,
thank you very much for your help. I have another question:
Regardless of the product you have purchased, if it belongs to a specific product subcategory, I will show you some products or others. How can I build that into the email template?
Kind regards,
Blanca
Views
Replies
Total Likes
Hi @bcollado,
So that would also work with the help of another enrichment activity.
You would need to link your workflow temp table to the products table by joining on the product subcategory of the customer's last bought product. You can choose how many products you want to fetch in that linked.
BR,
Ishan
Thank you very much for you comments were very helpful!!!
Have a nice day!
Kind regards,
B
Views
Replies
Total Likes
Views
Like
Replies
Views
Likes
Replies