Operate > IBM Management Center for WebSphere Commerce > Catalogs tool > Upload catalogs


Create catalog data in CSV format

You can create the catalog data to upload into the Management Center in a CSV format.


Before you begin

Ensure that you are familiar with the following topics: CSV format for catalog data and Data load utility CSV column definitions.


Procedure

  1. Open a spreadsheet editor.

  2. In the first cell of the first row, you specify which business object to upload.

    Choose one of the following keywords, type exactly as shown:

    • Catalog

    • CatalogDescription

    • CatalogGroup

    • CatalogGroupAssociation

    • CatalogGroupDescription

    • CatalogGroupRelationship

    • CatalogEntry

    • CatalogEntryAssociation

    • CatalogEntryComponent

    • CatalogEntryDescription

    • CatalogEntryDescriptiveAttributeAndValue

    • CatalogEntryInventory

    • CatalogEntryATPInventory

    • CatalogEntryOfferPrice

    • CatalogEntryParentCatalogGroupRelationship

    • CatalogEntryParentProductRelationship

    • ProductDefiningAttributeAndAllowedValues

    • SKUDefiningAttributeValue

    • AttributeDictionaryAttributeAndAllowedValues

    • AttributeDictionaryAttributeAllowedValues

    • CatalogEntryAttributeDictionaryAttributeRelationship

  3. In the second row, specify the column headers that correspond to the catalog business object.

  4. In the remaining rows of the worksheet, specify the catalog data values that correspond to the column heading definitions used in the previous step.

    The following example creates a Springs Fashions sales catalog, and deletes the Winter Fashions sales catalog:

  5. Save the worksheet as a CSV file.

  6. Optional: Create catalog data for different catalog business objects. Repeat steps 1 - 5.

  7. Optional: Compress one or more CSV files into a .zip file using a compression utility; password-encrypted .zip files are not supported.

    If you choose to compress the CSV files into a .zip file, be aware of the following:

    • All CSV files must use the same file encoding. See Upload catalog data for more information about the various file encoding.

    • Catalog object types must be unique across all the CSV files in the .zip file, that is, you cannot have more than one CSV file that uses the same keyword.

    • Catalog object types are uploaded in the following order:

      Catalog Upload feature catalog object type load order
      Priority Keyword
      1 Catalog
      2 CatalogDescription
      3 CatalogGroup
      4 CatalogGroupAssociation, CatalogGroupDescription, CatalogGroupRelationship, CatalogGroupCalculationCode
      5 CatalogEntry
      6 ProductDefiningAttributeAndAllowedValues, CatalogEntryDescriptiveAttributeAndValue, AttributeDictionaryAttributeAndAllowedValues
      7 CatalogEntryAssociation, CatalogEntryComponent, CatalogEntryDescription, CatalogEntryCalculationCode, CatalogEntryInventory, CatalogEntryATPInventory, CatalogEntryOfferPrice, CatalogEntryParentCatalogGroupRelationship, CatalogEntryParentProductRelationship, AttributeDictionaryAttributeAllowedValues
      8 SKUDefiningAttributeValue, CatalogEntryAttributeDictionaryAttributeRelationship

    By default, the maximum file size for uploads is 10 MB.


Results

You have created CSV files in a suitable format for the Catalog Upload feature. When you upload the files, the catalog business object keyword and the column headers are interpreted but are not uploaded to the catalog.


Related concepts

Upload catalogs


Related tasks

Create managed files

Related reference

Sample: Loading list prices in multiple currencies

Sample: Adding image attachments to categories and catalog entries

CSV format for catalog data


+

Search Tips   |   Advanced Search