To edit the relevant products query for an offer
After importing a list of relevant products for an offer, the list is saved as a query. You can edit this query, including adding additional query conditions, when you edit the offer.
1.
In Campaign, open the offer for which you want to edit the list of Relevant Products.
2.
The Select Products window opens, displaying the list of IDs currently in the query under Select Product Where.
3.
Edit the query, using the << button to remove a selected entry from the list, or the up and down arrow buttons to change the order of entries. Add a query clause using any attribute in the UA_Products table, including Product ID, using the >> button to move it to the Select Products Where list.
4.
5.
On the offer Edit page, click Save Changes to save the offer.