Reference > Data load utility CSV column definitions
Catalog group association
Use the CatalogGroupAssociation keyword to load merchandising associations between categories 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
- GroupIdentifier
- (String) The category identifier. Either this field or the GroupUniqueId is required.
- GroupUniqueId
- (Integer) The internal unique reference number of the category. Either this field or the GroupIdentifier is required.
- AssociationType
- (String) Use this field to indicate the type of association wanted. This field cannot be null. The default association options are CrossSell, UpSell, Accessory, and Replacement.
- TargetGroupIdentifier
- (String) The identifier of the category that is the target of the association. Either this field or the TargetGroupUniqueId is required.
- TargetGroupUniqueId
- (Integer) The internal unique reference of the target category. Either this field or the TargetGroupIdentifier is required.
- TargetStoreIdentifier
- (String) The identifier of the store owns the target category.
- TargetStoreUniqueId
- (Integer) The internal unique reference number of the store that owns the target category.
- Sequence
- (Decimal) An optional number used to control the order in which the category merchandising associations are displayed.
- SemanticSpecifier
- (String) The semantic specifier to use for this merchandising association. Examples of semantic specifiers are "REQUIRES", "NONE", "TEMP", or "COMES_WITH". If no value is provided, then the default value is set to "NONE".
- Quantity
- (Decimal) The quantity of the association.
- Field 1
- (String) A user defined field available for customization purposes.
- Field 2
- (Integer) A user defined field available for customization purposes.
- Field 3
- (Decimal) A user defined field available for customization purposes.
- Date1
- (Timestamp) A customizable field of timestamp type.
- 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.