Changing the list of relevant products for an offer

When you assign relevant products to an offer, the list is saved as a query. You can edit the offer if you want to change the query or remove items from the list.

Choose Campaign > Offers, and open the offer that you want to edit.

If you want to remove items from the list of Relevant Products, use Ctrl+click or Shift+click to select the items, then click Remove.

If you want to clear the list, click Import Product IDs. You can then either exit or rebuild the list.

If you want to edit the query that generated the list, click Edit Query. The Select Products dialog opens, and the Select Products Where list displays the list of relevant products.

The Add a Condition list on the left of the dialog shows fields from the UA_Products table, such as Product ID. Edit the query by adding or removing conditions:

To build an AND query: Specify at least two values in the Add a Condition list, then click >> to move them into the Select Products Where list. For example: Color = 'Red' AND Brand = 'XYZ'. When multiple values (fields) are added in a single step, they are combined as an AND.

To build an OR query: Move one value to the Select Products Where list, then move another value. An example of the resulting query is Color = 'Red' OR Brand = 'XYZ'. When values are added one at a time, they are OR'd.

Save Changes to close the dialog and save the query.

On the offer Edit page, click Save Changes to save the offer.