Reduce multiple value set

First introduced in version 5.6.3: For selected products, you can revoke allocated values from list of values attributes using this action.

Step 1: Search products

In the first step, you can use one of the search functions to search for a selection of products. You can either use the standard search only, or you can enhance the standard search by using the advanced search.

Use the standard search

In order to use the standard search functions, proceed as follows:

  1. From the "Retrieval level" menu , select the product structure level down to which the bulk update shall extend. You can choose between the options "Product", "Variant" and "Item".
  2. Move the upper toggle switch to the on position to activate the standard search.
  3. Specify the search parameters:
    • Either enter a single product respectively item number or specify a range of product numbers.
      • In order to search for a single product number respectively a single item number, move the lower toggle switch  to the on position and enter the respective number in "Product no. / Item no." field .
      • In order to search for a range of product numbers, move the toggle switch to the off position. Then enter the start product number and the end product number in the "from Product no." and "to Product no." fields.
    • Possibly enter a product name in the "Name" field .
    • From the "Product state" menu , possibly select a product state. You can choose between the options "All", "Only active products" and "Only deleted products".
    • Possibly select a search mode from the "Search mode" menu . The selected search mode specifies the principle according to which the search function is executed. Click here to find more information about the different search modes.
  • In order to proceed to the next slider, click on the NEXT button.
  • In order to reset the search settings, click on the RESET button.

Use the list search

You can use the list search to search for a range of numbers. These can be, for example, product, variant or item numbers. You only have to set the corresponding search attribute.

  1. From the "Retrieval level" menu , select the product structure level down to which the bulk update shall extend. You can choose between the options "Product", "Variant" and "Item".
  2. Move the upper toggle switch to the off position to activate the list search.
  3. From the "Search attribute" menu , select a type of number (e.g. "Product number").
  4. Enter the numbers in the "Number list" field . You can separate the numbers by semicolons or line breaks.
  5. Possibly select a search mode from the "Search mode" menu . The selected search mode specifies the principle according to which the search function is executed. Click here to find more information about the different search modes.

INFO
Numbers which were not found by the search can be copied to the clipboard by clicking on the button.

Use the advanced search

Using the advanced search you can further specify the search by using particular attributes and their values as search parameters. You can either assemble a selection of attributes or you can use a search favorite in which the appropriate attributes and their values are already grouped.

Assemble an attribute selection and specify search parameters

In order to assemble an attribute selection and to specify the search parameters, proceed as follows:

  1. Tick the "Advanced search" checkbox to show interface elements of the advanced search.
  2. Click on the button to call up the corresponding dialog box.

  1. Optional Enter a search term in the search field to filter the list of attributes by a search term.
  2. Select an attribute You can also select multiple attributes:
    • To select an attribute, transfer it from the left column to the right column . To do so, click on the attribute .
    • To deselect an attribute, transfer it from the right column back to the left column. To do this, click on the attribute.
  3. Click on the ACCEPT button to finalise the attribute selection.
    the dialog box closes and the selected attributes are shown.

  1. Enter the respective search parameters in the input fields of the individual attributes respectively select them from the menus.
  2. In order to further specify particular search parameters, click on the speech bubble with magnifying glass button in the input field of the respective attribute.Chevron rightThe corresponding dialog box is shown. Make the appropriate settings and click on the ACCEPT button. Further information about this matter you can find here.
  • In order to proceed to the next slider, click on the NEXT button.
  • In order to reset the search settings, click on the RESET button.

Note
  • Click here to learn more about the handling of the dialog box for selecting attributes.
  • Using the button and the button you can transfer all the attributes from one column to the other column at once.

INFO
  • In order to turn the attribute selection in the right-hand column back to the standard selection, click on the
    button. Following this, the corresponding submenu is shown. Click on the option "saveReset selection to default".
  • In order to save the current selection in the right-hand column as a new standard selection, click on the
    button. Following this, the corresponding submenu is shown. Click on the option "save Save selection as default".

Call up existing search favourites

In order to call up an existing search favorite, proceed as follows:

  1. Tick the "Advanced search" checkbox to show the interface elements of the advanced search.
  2. Select a search favorite from the "Search favorite" menu . Following this, the respective attributes are shown below the menu. The same applies to the attribute values which are specified as search parameters.
  1. Possibly make changes to the search parameters:
    • In order to change a search parameter, click on the respective attribute field and enter a new value respectively select one or several values from the corresponding menu.
    • In order to further specify particular search parameters, click on the speech bubble with magnifying glass button in the input field of the respective attribute.Chevron rightThe corresponding dialog box is shown. Make the appropriate settings and click on the ACCEPT button. Further information about this matter you can find here.
  • In order to proceed to the next slider, click on the NEXT button.
  • In order to reset the search settings, click on the RESET button.

INFO
You create a search favorite that is based on the selected attributes. To do so, click on the MANAGE button to call up the dialog box where you can set up the search favorite.

INFO
Click here for more information about search favorites.

Step 2: Select an action

In the second step, you can select the action which will be applied to the selected products:


This screenshot shows the user interface under version 5.6.3.
  1. Click on the “Reduce multiple value set” action to select it.
  2. Click on the NEXT button to proceed to the next slider or click on the BACK button to get back to the previous slider.
INFO
As of version 5.6.4 you are immediately directed to the next step after selecting an action.

Step 3: Select attributes

In the third step, you can select the attributes which you want to update. To do so, proceed as follows:

  1. Optional: Enter a search term in the search field to filter the list of attributes by a search term.
  2. Select an attribute. You can also select multiple attributes:
    • To select an attribute, transfer it from the left column to the right column . To do so, click on the attribute .
    • To deselect an attribute, transfer it from the right column back to the left column. To do this, click on the attribute.
  3. Select a context level from the “Context” menu . This is the context level on which the product data is to be updated.
  1. Click on the NEXT button to proceed to the next slider or click on the BACK button to get back to the previous slider.

Step 4: Select attribute values

In the fourth step, you can see a list of the selected attributes. Here you can select the attribute values that are to be revoked from the individual attributes. To do so, proceed as follows:

  1. Click on the first attribute to expand the corresponding menu:
    1. Optional: Enter a search term in the search field to filter the list of attribute values by a search term.
    2. In the value list , tick each of the values you want to revoke from the attribute.
    3. Click on the button to finalise the attribute value selection.Chevron rightThe menu closes and the selected values are shown.
     
  2. Possible select values for further attributes.
  1. Click on the NEXT button to proceed to the next slider or click on the BACK button to get back to the previous slider.
INFO
As of version 5.6.4, values of list of values attributes with sortable values are selected via a dialog box. To do so, click in the respective attribute field to call up the dialog box. In order to make the values of a list of values attributes sortable, the attribute property SORTED_MULTIPLE_LOOKUP needs to be set to “YES” which can be done in iPIM CC.

Step 5: Finalise the mass data update

In the last step, you can see an overview of the update to be carried out. This includes the number of products, variants resp. items to be updated as well as a list of the selected attributes and their values.

  • In order to finalise the mass data update, click on the UPDATE button.Arrow to the right A success message is shown. The attribute values of the selected attributes are now updated. 
  • In order to go back to the previous slider, click on the  BACK button.