---
title: "Personalize Emails with eCommerce and Related Data"
slug: "personalize-emails-with-ecommerce-and-related-data"
description: "Show product data from a related data set for the wishlist, abandoned cart, and recommended products of a contact in an email."
status: "update"
updated: 2026-11-04T12:48:09Z
published: 2026-11-04T12:48:09Z
canonical: "docs.mapp.com/personalize-emails-with-ecommerce-and-related-data"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.mapp.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Personalize Emails with eCommerce and Related Data

## Goal

Personalize an email with product data from a related data set. The products come from the wishlist, abandoned cart, or recommended products of the contact.

---

## Background Information

- The eCommerce tables contain the products of each contact, identified by their SKU.
- Instead of the Product Catalog, a related data set can provide the product data. The key of the related data set is the product SKU.
- The placeholders for this combination end with `RD` and name the related data set, for example `user.wishlistProductsRD['myrdlistwithproductdata']`. See [Placeholders for eCommerce Data](/v1/docs/placeholders-for-ecommerce-data).

> [!NOTE]
> Note
> 
> eCommerce triggers cannot be set up with related data. They always use the Product Catalog. See [eCommerce Triggers](/v1/docs/triggers).

---

## Procedure

### 1 Create the related data set

1. Go to *Administration > Attributes > Related Data*.
2. Create a related data set, for example `myrdlistwithproductdata`. Use a unique, unlinked key. The key holds the product SKU.
3. Add two String columns: `description` and `price`.

See [Create Related Data Set](/v1/docs/create-related-data-set).

### 2 Import the product data into the related data set

Import a file with one row per product. The key of each row is the product SKU. See [Import Data Into Related Data Set](/v1/docs/import-data-into-related-data-set).

### 3 Import the eCommerce data

1. Import data into the eCommerce tables **Recommended Products**, **Wishlist**, and **Abandoned Cart** (*Administration > eCommerce*). You can import the data manually or with Mapp Connect. See [Manual Import & Search of eCommerce Data](/v1/docs/manual-import-search-of-ecommerce-data) and [Set Up Data Imports (Data Feeds)](/v1/docs/set-up-data-imports-data-feeds).
2. Make sure that the `productSKU` in the eCommerce tables matches the key in the related data set.
3. Check that the products have been added to the eCommerce tables. See [Testing eCommerce Tables](/v1/docs/testing-ecommerce-tables).

### 4 Create the email

1. Go to *Create New > Message > Email Message*.
2. In the Compose step, insert the placeholders into the email.

The following template shows the description and price of each product in the wishlist, the abandoned cart, and the recommended products:

```plaintext
<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>
```

### 5 Test the personalization

1. Click **Preview**.
2. Select a test contact with products in the eCommerce tables and click **Update**.

The preview shows the data from the related data set for the products of the contact. See [Message Preview (Email)](/v1/docs/email-message-preview).