How to build the filter
- Go to Data → Customers.
- Add a filter for customers who have a product in their Favorites that belongs to the Heaters category.
- the product list (for example, Favorites or Cart);
- the product information (for example, category, price, brand, or any other product attribute).
How to specify product price in a list
There are several ways to set price-based conditions in list filters, depending on what you want to achieve.- Product in product list — Actual line cost — the price at which the product was added to the list. This price is specified for the entire line, including quantity.
- Product in product list — Product — Price — the current product price stored on the platform from the product feed.
- Product in product list — Product — Old price — the old product price stored on the platform from the product feed.
Difference between a product and a product in list
A product is a catalog item. Products are usually loaded into the project via a YML feed, which keeps the current price and availability up to date. On the platform, products are listed under Data → Products. When a customer adds a product to a list (or buys it), the product, its current price, and quantity are transmitted to the list — all combined into a single line in the product list. In other words, a product is one component of a line in a list. That’s why the product price and the product-in-list price can differ.For example, a year ago a customer added a watch to their cart for 6,000. In this case, the actual line cost in the list is 6,000.
Example
A customer added an item to their Wishlist for $3,000. The same product on the platform has the following prices:- Line cost — $3,000 (the price the customer saw when they added it to the list)
- Current product price — $2,300 (the live price in the feed)
- Old product price — $2,500 (the previous price recorded in the feed)
Both numeric boundaries in filters are inclusive.
Total cost of products in a list
You can also filter by the total sum of a list. The sum is calculated using the same logic as the actual line cost — by the prices at which the products were added to the list. So the list sum is the sum of the actual line costs of all matching products in the list. When you add conditions inside the filter, only the products matching those conditions are included in the total. For example, you can calculate:- the total sum of products in Cart only;
- the total sum of women’s clothing products in Cart.
Understanding quantity
You can specify quantity in two places: at the Products in product list level, and inside the nested Product condition. The difference between the two is easy to miss, so here are three examples that show how it works.Example 1: At least two different products
The customer has at least two different products from the School Supplies category in their list. For example, one history textbook and one geometry textbook.Example 2: A single line with quantity of at least two
The customer has a single line in the list with a quantity of at least two. For example, 15 lined notebooks on one line.Example 3: Multiple products, each with a quantity threshold
The customer has at least two different products, and each of those products is on a line with a quantity of two or more. For example, 5 planners and 10 pencil cases.Exporting product lists
You can export product lists for further analysis if needed.Related
- Use the Actual line cost vs. Current product price difference to power price-drop flows.
- Combine list filters with product attributes (category, brand, tags) to target promotions precisely.
- Use the list-sum condition to identify high-intent customers with valuable carts or wishlists.