Reference > Data load utility CSV column definitions
Catalog entry attribute dictionary attribute relationship
Use the CatalogEntryAttributeDictionaryAttributeRelationship keyword to load attribute dictionary attribute value for SKUs 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.
- AttributeIdentifier
- (String) The attribute identifier. Either this field or the AttributeUniqueId is required.
- AttributeUniqueId
- (Integer) The unique reference number of the attribute. Either this field or the AttributeIdentifier is required.
- LanguageId
- (String) The language identifier for language sensitive fields. For example: -1 for English, -2 for French.
- ValueIdentifier
- (String) The unique identifier of the attribute value. Use this field when the attribute has allowed values defined. If the attribute does not have allowed values defined, then this field is used as the value identifier of the newly created value.
- Value
- (String) The value of the attribute. Use this field when the attribute does not have allowed values.
- Usage
- (String) The usage of the attribute. Specify "Defining" for defining attribute (SKU resolution), "Descriptive" for descriptive attribute.
- Sequence
- (Decimal) A sequence number used to control the order in which attributes are displayed in a catalog entry. The default value is 0.
- AttributeStoreIdentifier
- (String) The identifier of the store that owns the attribute dictionary. Use this field when using the extended sites model, where the store that owns the attribute dictionary is different from the store that the catalog entry belongs to.
- AttributeStoreUniqueId
- (Integer) The unique reference number of the store that owns the attribute dictionary.
- 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.