Use the CatalogFilterCondition keyword to load catalog filter condition information into your HCL Commerce database.

Previously, you could load this data only in CSV formatted files. You can now load information in a CSV or XML formatted input file. Your input file must contain CSV column or XML element names and definitions that specify the characteristics of the business object type you are loading into your database.

CSV column and XML element definitions

(String) The condition group reference number. If you specify this column, then the next six columns do not need to be specified are not required to locate a condition group.
(String) The reference number of a catalog filter. If this column is specified, then the CatalogFilterName, StoreIdentifier, or CatalogIdentifier column are not required.
(String) The unique external identifier for catalog filter.
(String) The unique external identifier for the store that the catalog filter is created for.
(String) The unique external identifier for the catalog that the catalog filter is created for.
(String) The catalog group identifier that is included or excluded by this catalog filter. This field cannot be null.
(String) The external reference number for a condition group. This field cannot be null.
(Integer) This column indicates whether this condition is referring to an attribute.
(String) The identifier of the attribute. A value of 0 represents the name of the attribute dictionary attribute. A value of 1 represents the name of a property.
(String) The operator between the property name and the property value. Possible values: equals, contains, not equals, not contains, in, not in. This field cannot be null.
(String) The identifier of the attribute value. Use a comma to specify multiple attribute values. For example, Red, Green, Black.
Note: The sequence of this column should be the same as the AttributeValue. That is, if the identifier is at the position 2, then its value in AttributeValue is also at the same position.
(String) The value of the attribute. For example, Red, Green, Black.
(Integer) The identifier of the language. For example, -1 represents English.
(String) The type of the attribute value. Specify String, Integer, or Float.