To import a list of relevant products to an offer by pasting
1.
In Campaign, when creating a new offer, on the New Offer page, click Import Product IDs.
The Select Products window opens.
2.
Copy product IDs from your source file, using Copy from the context menu or Ctrl+C.
*
3.
While working in the Select Products window, you can also manually add, edit, or delete entries from the Import Product IDs list. There is no limit to the number of entries you can paste into the Import Product IDs list.
4.
The IDs from the Import Product IDs area are imported and listed in the Select Products Where section, with "PRODUCTID =" prepended to each product ID. If any errors are detected during import (for example, alphabetic characters when the Product ID field is numeric, or exceeding the maximum string length for a text product ID), you see a pop-up for each error. Note each error and click OK to view the next error.
*
*
You can continue to paste and import product IDs until you click Save Changes on the Select Products window. Once you have exited the Select Products window, you cannot import additional product IDs. Clicking Import Product IDs again clears any existing query to allow you to begin anew. If you do not want to clear your existing query, click Cancel when prompted for confirmation.
5.
When you have finished importing product IDs, click Save Changes. The product IDs that were in the Select Products Where list are saved as a query for the offer, and the list of product IDs is displayed under Relevant Product(s).
6.