Reference > Data load utility CSV column definitions
Catalog entry association
Use the CatalogEntryAssociation keyword to load merchandising associations between catalog entries 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 source catalog entry in the association. 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.
- AssociationType
- (String) The type of merchandising association to use. The available values are CrossSell, UpSell, Accessory, and Replacement. This field cannot be null.
- TargetPartNumber
- (String) The part number of the target catalog entry in the association. Either this field or the TargetCatalogEntryUniqueId is required.
- TargetCatalogEntryUniqueId
- The internal unique reference number of the target catalog entry. Either this field or the TargetPartNumber is required.
- TargetStoreIdentifier
- (String) The identifier of the store that owns the target catalog entry. Use this field when using the extended sites model, where the store that owns the target catalog entry is different from the store that owns the source catalog entry.
- TargetStoreUniqueId
- (Integer) The unique reference number of the store that owns the target catalog entry. Use this field when using the extended sites model, where the store that owns the target catalog entry is different from the store that owns the source catalog entry.
- Sequence
- (Decimal) The order in which the merchandising associations are displayed.
- SemanticSpecifier
- (String) The semantic specifier of the 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 target catalog entries associated to the source. For example, if the source catalog entry is a camera, and the target catalog entry is the type of battery it uses, the quantity indicates the number of batteries required.
- Field1
- (String) A user defined field available for merchandising association customization purposes.
- Field2
- (Integer) A user defined field available for merchandising association customization purposes.
- Field3
- (Decimal) A user defined field available for merchandising association customization purposes.
- Date1
- (Timestamp) A user defined field available for merchandising association customization purposes.
- 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.