CatalogEntryDescriptiveAttributeAndValue

Use the CatalogEntryDescriptiveAttributeAndValue keyword to load classic descriptive attributes and values for a product or SKU into the WebSphere Commerce database.

Previously, you could load this data only in CSV formatted files. We 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 we are loading into the database.

CSV column and XML element definitions

PartNumber

(String) The unique part number of the catalog entry. This field cannot be null in Insert or Replace. In Delete, 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. In Delete, 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) The data type of the attribute. This field cannot be NULL. This field is restricted to types that are defined in the ATTRTYPE table.

Name

(String) The name of the attribute. This field is language sensitive.

Sequence

(Decimal) A sequence number used to control the order in which attribute values are displayed in a product. Default 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 group name of the attribute.

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.

Value

(String) The value of the attribute.

Delete

(String) Indicates whether to delete. If we are performing a delete operation, specify this column. A value of "1" indicates that the row is to be deleted.