Maintain attributes for multiple attributes parallely

Using an example, this chapter explains how to maintain attributes for multiple products parallely in the “Excel” tab of the “Product data update” app. Hereby, the products are called up via a worklist that contains the products. The attributes are maintained on the product level, the main context level as well as on the german locale level.

INFO
Detailed information about how to use the “Excel” tab of the “Product data update” app you can find here.

Step 1: Call up the products

In this step, the worklist that contains the products to be maintained is called up. To do so, proceed as follows:

  1. Call up the “Product data update” app and go the “Excel” tab.
  1. From the menu, select the option “Worklist”.
  2. Choose the corresponding worklist from the list of worklists. Possibly use the text search to filter the selection of shown worklists by a search term.
  3. Click on the worklist to select it. Following this, the products from the worklist are shown in the “Product list” table.

Step 2: Select the data levels

In this step, the data levels on which the attributes to be maintained are selected. To do so, proceed as follows:

  1. If not already set, select the main context level from the “Context” menu (in this example “Customer”), in order to maintain attributes on this context level.
  2. If not already set, select the option “German” from the “Locale” menu in order to maintain the attributes on the german locale level.
  3. If not already set, select the option “Product” from the “Data view” menu in order to maintain attributes on the product level.

Step 3: Select attributes

In this step, the attributes to be maintained are included in the table. To do so, proceed as follows:

  1. Click on the Attributes button above the table to call up the attribute selection dialog box.
  1. Select the first attribute:
    1. Use the test search above the left column to filter the list of attributes by a search term.
    2. Transfer the attribute from the left column to the right column in order to select it. To do so, click on the attribute.
  2. Select the remaining attributes as described above.
  3. Click on the ACCEPT button to finalise the attribute selection. Following this, the dialog box closes and attributes are shown in the table.

Step 4: Maintain attributes

In this step, the attributes are maintained. To do so, proceed as follows:

  1. Double-click in a table cell.
  2. Enter the desired value.
  3. Leave the table cell.
  4. Maintain the other attributes as described above.
  5. Click on the SAVE button to save your input. If the process was successful, a corresponding message will appear.
    The attributes are now maintained.
INFO
You can also maintain a larger number of attributes by copying data from a spreadsheet software to the clipboard and paste the data into the “Product list” table.