LAST ORDER AND SUBCATEGORY (EMAIL TEMPLATE) | Community
Skip to main content
B
bcollado
Level 3
January 29, 2024
Solved

LAST ORDER AND SUBCATEGORY (EMAIL TEMPLATE)

  • January 29, 2024
  • 1 reply
  • 941 views

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,

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by isahore

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

1 reply

isahore
Community Advisor
isahoreCommunity AdvisorAccepted solution
Community Advisor
January 29, 2024

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

    B
    bcolladoAuthor
    Level 3
    January 29, 2024

    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

    B
    bcolladoAuthor
    Level 3
    February 2, 2024

    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

    Terms & ConditionsAccessibility statement

    Loading footer...