Reference > Data load utility CSV column definitions
Catalog entry description
Use the CatalogEntryDescription keyword to load catalog entry descriptions 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.
- LanguageId
- (Integer) The language id for language sensitive fields (Name, ShortDescription, LongDescription, AuxDescription1, AuxDescription2, Thumbnail, FullImage, Published, and Keyword). For example: -1 for English, -2 for French
- Name
- (String) The display name of this catalog entry. This field is language sensitive.
- ShortDescription
- (String) A short description of this catalog entry. This field is language sensitive.
- LongDescription
- (String) A long description of this catalog entry. This field is language sensitive.
- Thumbnail
- (String) The thumbnail image path of this catalog entry. This field is language sensitive. The forward slash '/' should be used in the path. Do not use backward slash '\'. For example, images/G1.jpg.
- FullImage
- (String) The full image path of this catalog entry. This field is language sensitive. The forward slash '/' should be used in the path. Do not use backward slash '\'. For example, images/G1.jpg .
- AuxDescription1
- (String) An auxiliary long description of this catalog entry. This field is language sensitive.
- AuxDescription2
- (String) An auxiliary description of this catalog entry. This field is language sensitive.
- Available
- (Integer) Indicates the length of time of availability of this catalog entry. Do not use this column to indicate inventory levels. The default value is 1. WebSphere Commerce does not contain any default business logic for this column.
- Published
- (Integer) Indicates whether this catalog entry should be displayed in the storefront for the language specified. 0 = catalog entry should not be displayed, 1= catalog entry should be displayed.
- AvailabilityDate
- (Timestamp) The date this catalog entry becomes available. Use the format yyyy-mm-dd hh:mm:ss.millis. WebSphere Commerce does not contain any default business logic for this column.
- Keyword
- (String) A keyword used for searching.
To include multiple keywords, separated by commas, include the entire string in double quotes. Example "keyword 1, keyword 2, keyword3". This field is language sensitive.
- 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.