Wishlists allow customers to mark items from the catalog to appear in a "Wishlist". The Wishlist will be saved per customer, allowing each customer to create a dynamic list of items they wish to purchase or review at a later time. The customer can easily add/remove items from the Wishlist.
An alternative use for this type of list is for the distributor to set which items appear, making it more of a "Recommended items per customer" list. In this case, the customer won't have the option to mark items, rather the distributor will load the data as to which items should appear in the list per customer.
Note: Wishlist filters are supported in the New Order Center only, using the NEW Filters only. If you have not moved to the new Order Center or the NEW Filters, please contact support so they can migrate you ( the old Favorites/Wishlists feature is no longer supported in the New Order Center).
The Wishlist filter is configured via a user defined table consisting of a list of items for each customer, where each item is flagged as true if it is to be saved in the customer's Wishlist. A custom checkbox field is then created to query the table, and get the most updated value. Items may be flagged within the catalog on the app via this checkbox field, and updates to the wishlist are then saved back to the user defined table so if the app is deleted or the user logs in on another device, the updated wishlists are synced.
To create a Wishlist filter per Account:
1. Create a UDT called "Wishlist" (create only, no data loading required)
2. Create a custom checkbox field that queries the UDT to find out if each item is/isn't in the customer's Wishlist
3. Add the custom checkbox field to the Order Center Grid View
4. Create a Wishlist filter (NEW filters only) and indicate the filter criteria to be all items whose checkbox value=true.
1. Create a UDT called "Wishlist"
You only need to create the UDT in the Pepperi backoffice (not upload any data to it). The data will be written there automatically as customers add items to their Wishlist.
Settings -> Configuration Files -> User Defined Tables
Click +Add and define the UDT as follows:
API Name - provide any name for your UDT
Main Key - select Account External ID (because the first lookup key will be by Account since every Account has different items in its list)
Secondary Key - any
2. Create a custom Checkbox type field (this is a boolean field)
Create a custom Transaction Line-Item field in the Transaction Type you wish to create the Wishlist filter in. The field will query the Wishlist UDT to check which items should be in the Wishlist.
In the Fields tab of the Transaction Type, add a Transaction Line-Item custom field:
Checked Display Text - if you want users to see an emoji icon when adding/removing an item from the wishlist, add the options for checked/unchecked. For example: a ❤ for checked, and a ➕ for unchecked. (To access emoji icons on your keyboard you can type the "Windows key" and "." and a window of emoji will come up allowing you to select).
User Defined Table Object - select the UDT name you created in step 1.
Main Key - select Transaction.AccountExternalID
Secondary Key - select Item.ExternalID
Get data from column number - enter zero ("0"), because there is no delimiter, since there is only one value in the "Value" column.
Make sure to check "Save the updated value to the UDT", this ensures that items that are subsequently added/removed from the wishlist on the app are updated in the table.
3. Add the custom checkbox field to the Grid View layout of the order center
Add the checkbox field to the layout of the Order Center Grid View so that it can be checked and unchecked as needed for the wishlist.
In the same Transaction Type where you created the custom field, open the Order Center Views and edit the Grid Line View.
Position the custom Transaction line-item field in the layout:
Wishlist field with checked value as ❤ and unchecked as ➕ in Order Center Grid View:
4. Create a Wishlist filter (NEW filters only) and indicate the filter criteria to be all items whose checkbox value=true
Wishlist filters must be created using the NEW filters only, since they require filtering by custom fields.
Go to Items -> Filters and add a new filter.
Filter by the custom field you created above to equal "true", so only items with the value true
(or 1) in the UDT will be displayed in this filter.
NOTE: If you have Matrix items (items with Styles and variants) in your catalog that could potentially be added to a wishlist, you will need to include a Transaction Parent Line Item definition in the Filter for the Style codes.
If you have both Matrix and non-Matrix Items that could potentially be added to a wishlist, include both Line Item and Parent definitions with an "OR" condition, so that both cases will be included:
You must add the Filter to the catalog - even if you are using only the Default catalog (you must be using the New Filters for this capability to be available).
Go to Catalogs -> Edit the catalog you wish to include this filter in.
In the Filters tab, add the Wishlist filter to the layout: