eCommerce Data Filtering and Sorting Guide

  • 2 minute(s) read
Prev Next

Overview

Filtering and sorting can be combined and applied to different types of eCommerce data, such as Wishlist, Abandoned Cart, Abandoned Browse, Transaction, or Recommended Products.

This guide provides an overview of how to apply filtering and ordering operations to eCommerce personalization placeholders, such as <%user.WishlistProducts%>. These operations allow users to handle eCommerce data dynamically. All ecx:sort and ecx:filter functions work across all eCommerce types and product data sources. For example, user.[Wishllist/AbandonedCart/AbandonedBrowse/Transaction/Recommended]Products loads data from the Product Catalog.

Data can be loaded from these sources:

  • Product Catalog

  • Related Data

Filtering

Using operators, you can filter eCommerce data based on date range or specific fields. Below are examples of different use cases:

Date Range Filtering

To retrieve eCommerce data for a user within a specified date range:

  • Last 6 days:

    <%ForEach var='wishlist' items="${ecx:filterDateRange(user.wishlistProducts, 'timestamp', ecx:formatDate(ecm:addInterval(date.today, '-6d'), 'yyyy-MM-dd', ecm:timeZone('Europe/Berlin'), 'de', false), '')}"%>

  • Between two specific dates:

    <%ForEach var='wishlist' items="${ecx:filterDateRange(user.wishlistProducts, 'timestamp', ecm:toDate('2024-10-10 13:45:00',null), ecm:toDate('2024-12-10 14:45:00',null))}"%>

Field Filtering with Operators

Filter data by field using various operators such as:

  • Product name starts with "shoes":

    <%ForEach var='wishlist' items="${ecx:filter(user.wishlistProducts, 'productName', 'startswith', 'shoes')}"%>

The available operators are:

  • EQUALS (==)

  • NOT_EQUALS (!=)

  • EMPTY (empty)

  • NOT_EMPTY (notempty)

  • LESS_THAN (<)

  • GREATER_THAN (>)

  • LESS_EQUALS_THAN (<=)

  • GREATER_EQUALS_THAN (>=)

  • STARTS_WITH (startswith)

  • ENDS_WITH (endswith)

  • CONTAINS (contains)

  • CONTAINS_CASE_INSENSITIVE (containsignorecase)

  • REGEX (regex)

Using an operator for an incompatible data type will result in an empty return.

Sorting and Removing Duplicates

Removing Duplicates

To remove duplicate entries based on a specific field, such as productSKU:

<%ForEach var='wishlist' items="${ecx:filterDuplicatesByField(user.wishlistProducts, 'productSKU')}"%>

Sorting Data

To sort eCommerce data by a specific field (e.g., by timestamp):

  • Sort in descending order:

    <%ForEach var='wishlist' items="${ecx:sort(user.wishlistProducts, 'timestamp', 'desc')}" max="5"%>

You can also combine sorting and removing duplicates:

  • Get 5 newest items without duplicates:

    <%ForEach var='wishlist' items="${ecx:sort(ecx:filterDuplicatesByField(user.wishlistProducts, 'productSKU'), 'timestamp', 'desc')}" max="5"%>

Use Cases

Use Case 1: Top 3 Abandoned Cart Products (Last 7 Days, Sorted by Price)

To retrieve the top 3 abandoned cart products from the last 7 days, sorted by price in descending order, you can use the following example:

Example Data:

Abandoned Cart Table (user.AbandonedCartProducts):

  • Product A (SKU: 1234, Price: $50, Timestamp: 2024-10-05)

  • Product B (SKU: 5678, Price: $70, Timestamp: 2024-10-03)

  • Product C (SKU: 91011, Price: $40, Timestamp: 2024-10-04)

Personalization Example:

<%ForEach var='cart' items="${ecx:sort(ecx:filterDateRange(user.AbandonedCartProducts, 'timestamp', ecx:formatDate(ecm:addInterval(date.today, '-7d'), 'yyyy-MM-dd', ecm:timeZone('Europe/Berlin'), 'de', false), ''), 'price', 'desc')}" max="3"%>
  <%${cart['productName']} - ${cart['price']}%>
<%/ForEach%>

This will return the top 3 abandoned cart products ordered by their price from the last 7 days.

Use Case 2: Top 3 Wishlist Products Using Related Data (Sorted by Name)

To showcase how Related Data is used, let’s retrieve the top 3 wishlist products from a related data table (e.g., myrdlistwithproductdata), sorted by product name.

Example Data:

Related Data Wishlist Table (user.WishlistProductsRD):

  • Shoes A (Description: Running Shoes, Price: $50, Timestamp: 2024-10-01)

  • Shoes B (Description: Hiking Shoes, Price: $70, Timestamp: 2024-09-30)

  • Shoes C (Description: Casual Shoes, Price: $40, Timestamp: 2024-10-03)

Personalization Example:

<%ForEach var="wishlist" items="${ecx:sort(user.wishlistProductsRD['myrdlistwithproductdata'], 'productName', 'asc')}" max="3"%>
  Wishlist Description: <%${wishlist['description']}%><br>
  Wishlist Price: <%${wishlist['price']}%><br><br>
<%/ForEach%>

This will retrieve and display the top 3 wishlist products from the Related Data table, sorted by product name in ascending order.

Related articles