Using Find and Replace Tool

You can use the Find and Replace tool to search for items by item attributes. For example, you can find items that contain a specific word or phrase in their description or items that belong to a specific category. The Find and Replace tool lets you set up combined search requests to quickly locate items that you need in the product catalog.

To search for items in the product catalog, follow the steps:

1. From the main PIM menu, select Product Catalog > Items.
   

   Result: The Items form opens.

   

2. In the By field list, select the item attribute by which you want to search for items. You can search for items by the following fields:
   

• Global item attributes, for example, Description or GTIN.
• Additional item attributes, for example, Component Number or Country of Settlement.
• Item tags, for example, Food or Snacks.
• Other item fields, for example, Vendor, Risk Group or VIN.

3. In the Condition field, select one of the following search operators:

• Like: Select this operator to find items with values similar to the search value.
• Equal: Select this operator to find items that exactly match the search value.
• Empty: Select this operator to find all items for which there is no entry in the specified attribute field.
• Exclude: Select this operator to exclude all items that contain the search value in the specified attributes field.
• More than: Select this operator to find all items with values that are greater than the search value.
• Less than: Select this operator to find all items with values that are less than the search value.
• Any: Select this operator to find items that contain any value in the specified attribute field.

4. In the Item to search field, enter the search value.
5. To set up a combined search request, in the And/Or field, select the necessary value and set up another search criterion in the request line below.
6. To further narrow the search results, select the Active Only and/or Not For Sale check boxes if necessary.
7. At the bottom of the search filter, click the Find button.

   

   Result: PIM displays a list of items that match the specified search criteria.

   

You can use the Find and Replace tool to quickly replace values in item attributes for a group of items. For example, you may want to change the category for some items or modify items description.

To replace item attribute values, follow the steps:

1. From the main PIM menu, select Product Catalog > Items.
   

   Result: The Items form opens.

   

2. Using the Search tool, filter items whose attribute values you want to replace. For more details, see Searching for Items.
3. In the list of filtered items, select check boxes next to items whose values you want to replace.
4. At the top left corner of the Find and Replace section, click Replace.
5. In the Field list, select the item attribute whose value you want to replace. You can replace values in the following fields:
   

• Global item attributes, for example, Description or GTIN.
• Additional item attributes, for example, Component Number or Country of Settlement.
• Item tags, for example, Food or Snacks.
• Other item fields, for example, Vendor, Risk Group or VIN.

5. In the Condition field, select one of the following search operators:

• Like: Select this operator to replace values that are similar to the specified value.
• Equal: Select this operator to replace values that exactly match the specified value.
• Empty: Select this operator to replace empty item attribute values.
• Exclude: Select this operator to exclude from the replace operation all items that contain the search value in the specified attribute field.
• More than: Select this operator to apply the replace operation to all items whose attribute values are greater than the search value.
• Less than: Select this operator to apply the replace operation to all items whose attribute values are less than the search value.
• Any: Select this operator to apply the replace operation to items with any value in the specified attribute field.

6. At the bottom of the replace filter, click the Replace button.

   

   Result: PIM replaces values in attribute fields of those items that you have filtered using the Search tool.