...
For each column, there is a limit of 255 characters. For product extension with 50 attributes, the limit is 70 characters for each column. (There is, however, no character limit for attribute extensions.) 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.
...
Add a product extension. You have to enter the ProductID, all other data are optional.
Import product extensions. Export the current table into the CSV or XLSX format (XLS is not supported), make your changes and import the file back. The existing data can be replaced or appendedProducts – Allows you to export, edit and import data using the Import Manager.
Duplicate the selected item.
Edit the values by double-clicking the field that needs to be changed.
Mass edit all, filtered or selected fields. Also enables you to add or remove attributes. A new pop-up window will open. Select the Attribute, Change (operator) and enter a new Value. Click the Edit button to confirm the changes.
Delete an item. The item will be deleted immediately.
| Expand | ||
|---|---|---|
| ||
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:
|
Mass delete all, filtered or selected items.
Export the data into MS ExcelXLSX or CSV format.
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.
...
When you filter in Products using Product Extensions attributes or in Customers using Customer Extensions attributes, using subclauses will return correct results only if the optimizeQueriesToExtensionTables option is set to true in pricefx in pricefx-config.xml (it is by default).
Note that only the support team can change the server configuration.