ProductDefiningAttributeAndAllowedValue

Use the ProductDefiningAttributeAndAllowedValue keyword to load non-attribute dictionary attributes and allowed values for a product into your WebSphere 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

PartNumber
(String) The part number of the catalog entry. Either this field or the CatalogEntryUniqueId is required. The part number for a catalog entry displays in Management Center as the value for the catalog entry Code property.
CatalogEntryUniqueId
(Integer) The internal unique reference number of the catalog entry. Either this field or the PartNumber is required.
AttributeUniqueId
(Integer) The unique reference number of the attribute.
LanguageId
(String) The language identifier for language sensitive fields. For example: -1 for English, -2 for French.
Type
(String) This field defines the data type of the attribute. This field cannot be NULL. Examples of data types are STRING, INTEGER, and FLOAT.
Name
(String) The name of the attribute. This field is language sensitive.
Sequence
(Decimal) A sequence number that is used to control the order in which attribute values are displayed in a product. The default value is 0.
Description
(String) A description of this attribute. This description is language sensitive.
SecondaryDescription
(String) The secondary description of the attribute. This description is language sensitive.
GroupName
(String) The name of the attribute group this attribute belongs to.
Field1
(String) A custom field for the attribute.
Footnote
(String) Use this field to store auxiliary attribute data such as a footnote.
UnitOfMeasure
(String) The unit in which the attribute is measured.
AllowedValue1
(String|Integer|Decimal) An allowed value of the attribute.
AllowedValue2
(String|Integer|Decimal) An allowed value of the attribute.
AllowedValue3
(String|Integer|Decimal) An allowed value of the attribute.
AllowedValue4
(String|Integer|Decimal) An allowed value of the attribute.
AllowedValue5
(String|Integer|Decimal) An allowed value of the attribute.
AllowedValue6
(String|Integer|Decimal) An allowed value of the attribute.
AllowedValue7
(String|Integer|Decimal) An allowed value of the attribute.
AllowedValue8
(String|Integer|Decimal) The allowed value of the attribute.
AllowedValue9
(String|Integer|Decimal) An allowed value of the attribute.
AllowedValue10
(String|Integer|Decimal) An allowed value of the attribute.
Delete
(String) Indicates whether to delete. If you are performing a delete operation, specify this column. A value of "1" indicates that the row is to be deleted.