Context menu

Tables feature a context menu which can be accessed via clicking on the right mouse button. The composition of the context menu depends on the respective surrounding.

Append value for selection

Using the action “Append value for selection” you can append the value of an attribute to the value of the same attribute of selected products. To do so, proceed as follows:

1. In the respective table, tick the products to whose attribute values you want append the source value.
2. Right-click in the table cell that contains the desired source value to access the context menu.
3. Click on the option “Append value for selection”. Then appears the corresponding dialog box which contains a text field which shows the selected source value. Here you can possibly make changes to the source value. Furthermore, you can prefix the source value to the target value. To do so, put the source value in front of the “Attribute value” chip.

• In order to finish the process, click on the SAVE button. Then the source value will be appended or prefixed to the attribute value of the appropriate attributes
• In order to cancel the process, click on the CANCEL button.

The action “Append value for selection” can also be applied on the variant or the item level. Though it only works on attributes of the attribute type “character chain”.

Append value for all

Using the action “Append value for all” you can append the value of an attribute to the value of the same attribute of all the products listed in the respective table. To do so, proceed as follows:

1. Right-click in the table cell that contains the source value to access the context menu.
2. Click on the option “Append value for all”. Then appears the corresponding dialog box which contains a text field which shows the selected source value. Here you can possibly make changes to the source value. Furthermore, you can prefix the source value to the target value. To do so, put the source value in front of the “Attribute value” chip.

• In order to finish the process, click on the SAVE button. Then the source value will be appended or prefixed to the attribute value of the appropriate attributes.
• In order to cancel the process, click on the CANCEL button.

The action “Append value for all” can also be applied on the variant or the item level. Though it only works on attributes of the attribute type “character chain”.

Apply value for all

Using the action “Apply value for all” you can apply an attribute value to the same attribute of all the products listed in the respective table. The former attribute values will be replaced. To use the “Apply value for all” action, proceed as follows:

1. Right-click in the table cell that contains the source value to access the context menu.
2. Click on the option “Apply value for all”. Then the attribute values of the appropriate attributes will be replaced by the source value.

The action “Apply value for all” can also be applied on the variant or the item level.

Apply value for selection

Using the action “Apply value for selection” you can apply an attribute value to the same attribute of selected products. The former attribute values will be replaced. To use the “Apply value for selection” action, proceed as follows:

1. In the table, tick the products whose attribute values you want to replace by the sorce value.
2. Right-click in the table cell that contains the source value to access the context menu.
3. Click on the option “Apply value for selection”. Then the attribute values of the appropriate attributes will be replaced by the source value.

The action “Apply value for selection” can also be applied on the variant or the item level.

Apply value to visible column cells

Using this action you can apply an attribute value to the same attribute of all the visible products. Attribute values ​​of products that are included in the table but are hidden, for example, via table filters, are not changed. In order to use the action, proceed as follows:

1. Right-click in the table cell that contains the source value to access the context menu.
2. Click on the option “Apply value to visible column cells”. Then the attribute values of the appropriate attributes will be replaced by the source value.

The action “Apply value for visible column cells” can also be applied on the variant or the item level.

5. Click on the option “Copy complex attributes for all”.The corresponding prompt window is shown.

• To finalise the copying the attribute values, click on the UPDATE button .
  The dialogbox closes and a success message is shown. The copied attribute values are now assigned to all the other products.
• To cancel the copying the attribute values, click on the CANCEL button .

• To finalise the copying the attribute values, click on the UPDATE button .
  The dialogbox closes and a success message is shown. The copied attribute values are now assigned to the selected products.
• To cancel the copying the attribute values, click on the CANCEL button .

Insert text module

Using the action “Insert text module” you can insert an exisiting text module into the table cell of a localized attribute. To do so, proceed as follows:

1. Double-click in the table cell into which you want to insert a text module.
2. Right-click to access the context menu.
3. Click on the option “Select text module” to call up the corresponding dialog box.
4. Tick the text module you want to insert.

• To finish the process and insert the selected text module, click on the APPLY button.
• To cancel the process, click on the CANCEL button.

The following right is needed to use this action:

Create new text module

Using the action “Create new text module” you can create a text module which is based on an attribute value. Later you can insert the text module in other places using the action “Insert text module”. To do so, proceed as follows:

1. Double-click in the table cell whose value you want use as a templete for the new text module.
2. Mark the attribute value.
3. Right-click to access the context menu.
4. Click on the option “Select text module”. If the process is successful, a corresponding message will appear.

• The newly created text module can only be inserted in attribute cells of the same attribute type. The locale also has to be the same.
• Text modules that were created using this action can be found in the “Text modules” area of iPIM CC. Though, it depends on the selected UI language which text modules were shown. The list of text modules only shows text modules that were created in the selected language.

The following right is needed to use this action:

This action only works for localized string type attributes.

Invert selection

Using the action “Invert selection” you can invert the selection. That means, ticked datasets will be unticked and unticked datasets will be ticked. Corresponding datasets can be products, variants, items, texts, prices etc. The “Invert selection” action can be used in almost any app. To use it, proceed as follows:

1. Move the mouse cursor over a given table cell and click on the right mouse button to access the context menu.
2. Click on the option “Invert selection”.

Select same values

Using the action “Select same values” you can select all the table rows which share the same attribute value for a particular attribute.

1. In the respective table, move the mouse cursor over a table cell that contains the desired attribute value.
2. Right-click to access the context menu.
3. Click on the action “Select same values”. Then all table rows are ticked, in which the respective attribute possesses the same attribute value.

4. Choose the desired content-object from the list. Possibly use the free-text search or the column header tools to do.
5. Click on the identifier of the content-object. Following this, you will be directed to the “Content-Management” app where the content-object is called up.

For example, in order to relate lookup values to content-objects, go to the “Content relations“ app.

Open product in new tab

Via the action “Open product in new tab” you can call up a product in the “Product details” app, with the product opened in a new tab. To do so, proceed as follows:

1. In the respective table, move the mouse cursor over the table row of the product.
2. Right-click to access the context menu.
3. Click on the option “Open product in new tab”. Then you will be directed to a new tab where the respective product is openend in the “Product details” app.

Active selection

Add to active selection

You can add products to the “Active selection”. They will then appear in the product list of the “Selection” widget which can be accessed via the collapsible sidebar on the right-hand side. For example, you can temporarily list products there in order to access them repeatedly without having to call them up using the search function again and again. To use the action “Add to active selection”, proceed as follows:

1. Tick the product which you want to add to the “Active selection”.
2. Right-click in a given table cell to access the context menu.
3. Move the mouse cursor over the option “Active selection” to show the corresponding submenu.
4. Click on the option “Add to active selection”. Then the selected product will appear in the product list of the “Selection” widget.

Remove from active selection

Using the action “Remove from active selection” you can remove a product from the product list of the “Selection” widget. To do so, proceed as follows:

1. Tick the product which you want to remove from to the “Active selection”.
2. Right-click in a given table cell to access the context menu.
3. Move the mouse cursor over the option “Active selection” to show the corresponding submenu.
4. Click on the option “Remove from active selection”. Then the selected product will vanish from the product list of the “Selection” widget.

Export

Export

Using the “Export” action you can export product data from a table as a .csv or .xslx file. To do so, proceed as follows:

1. In the respective table, possibly tick the table rows you want to export.
2. Move the mouse cursor over a given table cell.
3. Click on the right mouse button to access the context menu.
4. Move the mouse cursor over the option “Export” to show the corresponding submenu.
5. Click on the option “Export” to call up the corresponding dialog box.

6. Enter an identifier in the "Task name" field . The identifier makes it easier to identify the export file in the "History" tab of the "Tasks" menu.
7. From the "Export format" menu , select an export format. You can choose between "CSV" for an export as a .csv file and "Excel" for an export as a .xslx file.
8. From the "Digital asset format" menu select the file format in which digital assets are to be exported. But there is also the option to exclude images from the export.
9. If you selected the export format "CSV", enter a separator in the "Separator" field . In the exported .csv file, the attribute values will be separated by this separator. Usually a semicolon is used for this purpose.
10. If you selected the export format "CSV", select an encoding from the "Encoding" menu .
11. Possibly tick the "Export headers" checkbox  to include the column headers in the export.
12. Possibly tick the "Only selected rows"* checkbox . Then only the selected rows will be included in the export. Otherwise all the table rows will be exported.

• In order to create the export file, click on the EXPORT button . If the process was successful, a corresponding message will appear. The export file can be downloaded in the “History” tab of the dialog box which can be accessed by clicking on the button in the header or in the “Processes” table of the "Tasks" app.
• In order to create the export file and download it directly, click on the DOWNLOAD button . If the process was successful, a corresponding message will appear. The export file can usually be found in your local download folder. Additionally, it can be downloaded in the "History" tab of the dialog box which can be accessed by clicking on the  button in the header or in the "Processes" table of the "Tasks" app.
• In order to cancel the process, click on the CANCEL button .

*This checkbox is only available if the respective table offers the option to tick table rows.

In general, the name of the export file is the name of the table from which the data was exported.

First introduced in version 5.6: When exporting a greater amount of data from tables that feature a pagination, the export dialog box features the “Export rows from all pages” checkbox which is used to determine if all the data is exported or if only the data shown on the visible page is exported.

Clipboard

Using the different “Clipboard” actions you can copy data from the respective table to paste it, for example, into a table of a spreadsheet software.

Copy all rows

Using the action “Copy all rows” you can copy the data from all the rows of the respective table to the clipboard. To do so, proceed as follows:

1. Move the mouse cursor over a given table cell and click on the right mouse button to access the context menu.
2. Move the cursor over the option “Clipboard” to show the corresponding submenu.
3. Click on the option “Copy all rows”. This transfers the data from all rows to the clipboard. It can then be pasted into a table of a spreadsheet software, for example.

Copy all rows with header

Using the action “Copy all rows with header” you can copy the data from all the rows and the header of the respective table to the clipboard. To do so, proceed as follows:

1. Move the mouse cursor over a given table cell and click on the right mouse button to access the context menu.
2. Move the cursor over the option “Clipboard” to show the corresponding submenu.
3. Click on the option “Copy all rows with header”. This transfers the data from all rows and the header to the clipboard. It can then be pasted into a table of a spreadsheet software, for example.

Copy selected cells incl. context column

Using the action “Copy selected cells incl. context column” you can copy the data from selected cells including a contextual column that contains the respective product numbers to the clipboard. To do so, proceed as follows:

1. In the respective table, mark the cell(s) whose content you want to copy to the clipboard.
2. Click on thebutton in the footer to access the action menu.
3. Move the cursor over the option “Clipboard” to show the corresponding submenu.
4. Click on the option “Copy selected selected cells incl. context column”. This transfers the data from the selected cell to the clipboard. It can then be pasted into a table of a spreadsheet software, for example.

This action only works as described in tables that do not feature checkboxes to select table rows. In tables with these checkboxes, whole table rows are ticked and selected.

• In order to mark multiple adjacent cells, press and hold the “Shift” key while clicking on the first and the last of the cells whose data you wan to copy to the clipboard.
• If you mark a single cell, only its content is copied to the clipboard. If you mark multple cells, additionally to the cell content also the respective product or item numbers are copied to the clipboard to facilitate the allocation of the data. If you only want to copy the content of multiple marked cells to the clipboard, you can use the keyboard shortcut “Ctrl+C” respectively the equivalent of your operation system.

Copy selected cells excl. context column

First introduce in version 5.5.0: Using the action “Copy selected cells excl. context column” you can copy the data from selected cells of the respective table to the clipboard. To do so, proceed as follows:

1. In the respective table, mark the cell(s) whose content you want to copy to the clipboard.
2. Click on thebutton in the footer to access the action menu.
3. Move the cursor over the option “Clipboard” to show the corresponding submenu.
4. Click on the option “Copy selected selected cells excl. context column”. This transfers the data from the selected cell to the clipboard. It can then be pasted into a table of a spreadsheet software, for example.

This action only works as described in tables that do not feature checkboxes to select table rows. In tables with these checkboxes, whole table rows are ticked and selected.

Copy selected cells

Using the action “Copy selected cells” you can copy the data from selected cells of the respective table to the clipboard. To do so, proceed as follows:

1. In the respective table, click in the table cell whose content you want to copy to the clipboard.
2. Move the mouse cursor over the table cell and click on the right mouse button to access the context menu.
3. Move the cursor over the option “Clipboard” to show the corresponding submenu.
4. Click on the option “Copy selected cells”. This transfers the data from the selected cell to the clipboard. It can then be pasted into a table of a spreadsheet software, for example.

You can copy the data from multiple adjacent cells to the clipboard. For this purpose, press and hold the Shift key while clicking on the first and the last of the cells whose data you wan to copy to the clipboard.

Copy selected column cells

Using the action “Copy the selected column cells” you can copy the data from a table column to the clipboard. To do so, proceed as follows:

1. In the respective table, click in a given cell of the column whose content you want to copy to the clipboard.
2. Move the mouse cursor over a given table cell and click on the right mouse button to access the context menu.
3. Move the mouse cursor over the option “Clipboard” to show the corresponding submenu.
4. Click on the option “Copy selected column cells”. This transfers the data from the selected column to the clipboard. It can then be pasted into a table of a spreadsheet software, for example.

FAQ

What is the difference between “append” and “apply” when editing attribute values?

Using the actions “Append value for selection” and “Append value for all” you can append the value of an attribute to the value of the same attribute of the respective products; the source value is appended or prefixed to the existing attribute value. Using the actions “Apply value for all” and “Apply value for selection”, on the other hand, the former attribute values will be replaced by the source value.

Which attribute types does the “Insert text module” action work for?

Using the action “Insert text module” you can insert an existing text module into the table cell of a localized attribute. Note: in this English documentation, the statement “This action only works for localized string type attributes” appears at the end of the “Create new text module” section rather than directly under “Insert text module”, so it’s not fully clear from the wording which of the two actions it refers to.

Where can text modules created via the “Create new text module” action be found?

Text modules that were created using this action can be found in the “Text modules” area of iPIM CC. Though, it depends on the selected UI language which text modules were shown. The list of text modules only shows text modules that were created in the selected language.

Why isn’t the “Only selected rows” checkbox always available when exporting?

This checkbox is only available if the respective table offers the option to tick table rows.

Where can I find an export file again later?

The export file can be downloaded in the “History” tab of the dialog box which can be accessed by clicking on the button in the header or in the “Processes” table of the “Tasks” app.

Why doesn’t “Copy selected cells incl. context column” work as described in every table?

This action only works as described in tables that do not feature checkboxes to select table rows. In tables with these checkboxes, whole table rows are ticked and selected.