How to Personalize Emails with eCommerce and Related Data Tables
- 1 Minute to read
- Print
- DarkLight
How to Personalize Emails with eCommerce and Related Data Tables
- 1 Minute to read
- Print
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback!
General Information
This page describes how to personalize Email messages in Mapp Engage, combining data from related data and eCommerce tables.
Note that eCommerce triggers cannot be set up using Related Data. To do that, you must use the Product Catalog.
Steps
Create a Related Data table: Administration > Attributes > Related Data
Create a new related data table called "myrdlistwithproductdata".
The table must use a unique unlinked key.
Add two String fields to the table:
descriptionprice
Documentation: Create Related Data Set
Import sample data into this related data table. For more information, see Import Data Into Related Data Set.
Import eCommerce Data: Administration > eCommerce > Product Catalog / Triggers / System Transactions / Wishlist / Abandoned Cart / Abandoned Browse / Recommended Products
Import data into the Recommended Product, Wishlist, and Abandoned Cart eCommerce tables. You can do this manually or using Mapp Connect:
Ensure that the
productSKUin the eCommerce tables is the same as theproductIdin the related data table.Verify that the products have been added to the eCommerce tables. For more information, see Testing eCommerce Tables.
Create an email message: Create New > Message > Email Message
Go to the message Compose section and use a sample template for testing.
Email code sample
<html> <head> <title> </title> </head> <body> Hello <%user.Email%><br> <%ForEach var="test" items="${user.wishlistProductsRD['myrdlistwithproductdata']}" %> WL description: <%${test['description']}%><br> WL price: <%${test['price']}%><br><br> <%/ForEach%> <%ForEach var="test" items="${user.abandonedCartProductsRD['myrdlistwithproductdata']}" %> AC description: <%${test['description']}%><br> AC price: <%${test['price']}%><br><br> <%/ForEach%> <%ForEach var="test" items="${user.recommendedProductsRD['myrdlistwithproductdata']}" %> RP description: <%${test['description']}%><br> RP price: <%${test['price']}%><br><br> <%/ForEach%> </body> </html>
Test the personalization.
Click Preview, select a test contact, and click Update.
The message is now personalized based on the imported data.
For more information, see:
Was this article helpful?