Operate > IBM Management Center for WebSphere Commerce > Catalogs tool > Upload catalogs
CSV format for catalog data
WebSphere Commerce provides sample CSV files for loading catalog business objects. When loading the catalog data, the CSV file must contain only one type of catalog business object.
Sample CSV file screen captureIn the CSV file:
- The first row must contain the keyword that corresponds to the catalog business object to upload
- The second row must contain the column headings.
The keyword and column headers are case sensitive.
Catalog business object keywords and column definitions
The following table lists the catalog business object types available for use.
The sample CSV files do not include all the available column headers for the catalog business object types. For a complete list of the available CSV column headers for the catalog business object types, see Data load utility CSV column definitions.
Catalog business object type descriptions, keywords, and sample CSV files.
To upload ... CSV keyword Sample CSV file Master or sales catalog, and optionally its description. Catalog Catalog.csv Catalog descriptions in multiple languages. CatalogDescription CatalogDescription.csv Categories, optionally the categories description, and the parent and child category relationships. CatalogGroup CatalogGroup.csv Merchandising associations between categories. CatalogGroupAssociation CatalogGroupAssociation.csv Category descriptions (language-dependent). CatalogGroupDescription CatalogGroupDescription.csv Parent/child relationship between categories. CatalogGroupRelationship CatalogGroupRelationship.csv Catalog entries such as products, SKUs, bundle or kits, and optionally the catalog entries description. Also the product and SKU relationships. CatalogEntry CatalogEntry.csv Merchandising associations between catalog entries. CatalogEntryAssociation CatalogEntryAssociation.csv Multiple relationships between the parent kit (package, bundle, and dynamic kit) and its child catalog entries CatalogEntryComponent CatalogEntryComponent.csv Catalog entry descriptions (language-dependent). CatalogEntryDescription CatalogEntryDescription.csv Classic descriptive attributes and values for a product or SKU. CatalogEntryDescriptiveAttributeAndValue CatalogEntryDescriptiveAttributeAndValue.csv Catalog entry offer price. CatalogEntryOfferPrice CatalogEntryOfferPrice.csv Parent/child relationships between categories and catalog entries. CatalogEntryParentCatalogGroupRelationship CatalogEntryParentCatalogGroupRelationship.csv Product and SKU relationships between catalog entries. CatalogEntryParentProductRelationship CatalogEntryParentProductRelationship.csv Classic attribute and allowed values for products. ProductDefiningAttributeAndAllowedValues ProductDefiningAttributeAndAllowedValues.csv Classic attribute value for SKUs. SKUDefiningAttributeValue SKUDefiningAttributeValue.csv Attribute dictionary attribute and allowed values. AttributeDictionaryAttributeAndAllowedValues AttributeDictionaryAttributeAndAllowedValues.csv AttributeDictionaryAttribute_fr_FR.csv
- Loads attributes in French.
Attribute dictionary attributes allowed values (in other national languages). AttributeDictionaryAttributeAllowedValues AttributeDictionaryAttributeAllowedValues_fr_FR.csv
- Loads attribute allowed values in French.
Attribute dictionary attribute value for SKUs. CatalogEntryAttributeDictionaryAttributeRelationship CatalogEntryAttributeDictionaryAttributeRelationship.csv CatalogEntryAttributeDictionaryAttributeRelationship_fr_FR.csv
- Loads descriptive attribute values in French.
You can also upload the following catalog business object types. However, the business objects are not visible within the Catalogs tool unless the business has customized the Management Center to display these business objects. Catalog entry calculation code. There are calculation codes for different calculation usages. The provided calculation usages include discount, shipping, sales tax, shipping tax, coupon, surcharge, and shipping adjustment. CatalogEntryCalculationCode CatalogEntryCalculationCode.csv Category calculation code. There are calculation codes for different calculation usages. The provided calculation usage includes discount, shipping, sales tax, shipping tax, coupon, surcharge, and shipping adjustment. CatalogGroupCalculationCode CatalogGroupCalculationCode.csv Catalog entry inventory (non-ATP). CatalogEntryInventory CatalogEntryInventory.csv Catalog entry inventory (ATP). CatalogEntryATPInventory CatalogEntryATPInventory.csv
Additional notes
- If you are loading attributes for the first time, log out of the Management Center and then log in again to be able to see the attribute dictionary attributes.
- If you are loading attributes in a different language for the first time, log out of the Management Center and then log in again to be able to see the attribute dictionary attributes allowed values. Also, ensure that the store supports the language.
Related concepts
Related tasks
Create catalog data in CSV format