Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

(warning) For each column, there is a limit of 255 characters. For customer extensions with 50 attributes, the limit is 70 characters. (There is, however, no character limit for attribute extensions.) If you change the size of the customer 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 new customer extension. Enter a Customer Id; all other field are optional.

  • Import customer 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 appended.

  • Duplicate a customer extension.

  • Edit customer extensions data.

  • Mass edit all, filtered or selected items. In the dialog that opens, select the Attribute and Change (operator) and enter a Value. Click the Edit button to confirm the changes.

  • Delete items.

Expand
titleDelete options for Administrators

When deleting a CX 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.

  • Export the data into Excel.

  • Advanced filter to narrow down the data.
    See also the filtering limitation when filtering Customers using Customer Extension attributes in an advanced filter.

...

(warning) 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).
(info) Note that only the support team can change the server configuration.