Reference > Data load utility CSV column definitions
Product defining attribute and allowed values
Use the ProductDefiningAttributeAndAllowedValue keyword to load classic attributes and allowed values for a product into the database using a CSV file. The CSV file contains column definitions specifying the characteristics of the catalog business object type.
CSV file column definitions
- PartNumber
- (String) The part number of the catalog entry. Either this field or the CatalogEntryUniqueId is required.
- 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 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 field is language sensitive.
- SecondaryDescription
- (String) The secondary description of the attribute. This field 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 should be deleted.