Product Extensions

Product Extensions (PX) are attributes of products that do not have a strict one-to-one relationship with a product: the attribute can change over time or a product can have multiple attributes of the same type. Product extensions accommodate these attributes. Product extensions can be used in price calculations. Product extensions can be classified by category.

Product extension structures are set up by an administrator in Configuration. The first column contains the Product-Id. The other columns can contain any type of value. As for the number of columns, you can choose a product extensions table with 3, 6, 8, 10, 20, 30 or 50 attributes.

 For each column, there is a limit of 255 characters. For product extension with 50 attributes, the limit is 70 characters for each column. If you change the size of the product extension from a lower number of attributes to 50 attributes and some of the attributes have more than 70 characters, a warning is displayed and the character string is truncated.

To access Product Extensions:

1. Go to Master Data > Product Extensions.
2. Select the required Product Extension from the Category drop-down.
   The data is not loaded immediately after you select the product extension. This allows you to set a filter before loading data.
   
3. Click the Refresh  icon to load the data.

The available options are:

• Add  a product extension. You have to enter the 'ProductID', all other data are optional. All entered values are saved automatically.
• Copy  a selected item.
• Edit the values by double-clicking the field that needs to be changed.

• Mass edit  all, filtered or selected fields. A new pop-up window will open. Select the 'Field', 'Operator' and 'Value' and add the required changes. Click the 'Edit' button to confirm the changes. The number of changed items will be shown at the 'Edit' button in brackets.
  

• Delete an item. The item will be deleted immediately.

   Delete options for Administrators

  When deleting a PX table, you can decide whether the underlying data will be also deleted from the DB. There is a system-level "stale OX" command:

  /pricefx/system/system$staleox/<partition> – Does not delete data, only detects. The partition URL parameter is optional; if omitted all partitions are checked.

  /pricefx/system/system$staleox/<partition>/delete – Data will be deleted. The partition URL param is mandatory

• Mass delete all, filtered or selected items.

• Download  the data into MS Excel.
• Filter  the items by product extension or product master attributes.
  See also a filtering limitation when filtering Products using Product Extension attributes in an advanced filter.

 To modify/add the product extensions, you can also use the Excel Client.