Reference > Data load utility CSV column definitions


Catalog entry component

Use the CatalogEntryComponent keyword to load the relationship between the parent kit (package, bundle, and dynamic kit) and its child 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 child component 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.

Type

(String) This field defines the type of parent kit/child catalog entry relationship. The available values for this field are "PackageComponent", "BundleComponent" or "DynamicKitComponent". If you do not provide a value for this field, the Type is selected based on the catalog entry type of the parent kit. For example, if the parent kit catalog entry type is a package, then the "PackageComponent" relationship type is used.

ChildPartNumber

(String) The part number of the component catalog entry. Either this field or the ChildCatalogEntryUniqueId is required.

ChildCatalogEntryUniqueId

(Integer) The unique reference number of the component catalog entry. Either this field or the ChildPartNumber is required.

ChildStoreIdentifier

(String) The identifier of the store that owns the component catalog entry. Use this field when using the extended sites model, where the store that owns the component catalog entry is different from the store that owns the catalog entry.

ChildStoreUniqueId

(Integer) The unique reference number of the store that owns the component catalog entry.

Sequence

(Decimal) An optional number used to control the order in which the child catalog entry appears in the parent kit (package, bundle or dynamic kit).

Quantity

(Decimal) The quantity of child catalog entry.

ParentToChildCatEntryRelField1

(String) The parent to child catalog entry relationship custom field 1.

ParentToChildCatEntryRelField2

(Integer) The parent to child catalog entry relationship custom field 2.

ParentToChildCatEntryRelField3

(Decimal) The parent to child catalog entry relationship custom field 3.

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.


+

Search Tips   |   Advanced Search