Creating catalog data in CSV format

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

Before you begin

Ensure that you are familiar with the following topics: File format for uploading catalog data and Data Load utility CSV column and XML element 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 the keyword exactly as shown:
    • Attachment
    • AttachmentAsset
    • Catalog
    • CatalogDescription
    • CatalogGroup
    • CatalogGroupAsset
    • CatalogGroupAssociation
    • CatalogGroupAttachment
    • CatalogGroupCalculationCode
    • CatalogGroupDescription
    • CatalogGroupRelationship
    • CatalogGroupSEO
    • CatalogEntry
    • CatalogEntryAsset
    • CatalogEntryAssociation
    • CatalogEntryAttachment
    • CatalogEntryCalculationCode
    • CatalogEntryComponent
    • CatalogEntryDescription
    • CatalogEntryDescriptionOverride
    • CatalogEntryDescriptiveAttributeAndValue
    • CatalogEntryInventory
    • CatalogEntryATPInventory
    • CatalogEntryOfferPrice
    • CatalogEntryParentCatalogGroupRelationship
    • CatalogEntryParentProductRelationship
    • CatalogEntrySEO
    • CatalogEntryUpdate
    • CatalogEntryDescriptionUpdate
    • CatalogFilter
    • CatalogFilterCategory
    • CatalogFilterCatentry
    • CatalogFilterCondition
    • CatalogFilterConditionGroup
    • ListPriceList
    • ProductDefiningAttributeAndAllowedValues
    • SKUDefiningAttributeValue
    • AttributeDictionaryAttributeAndAllowedValues
    • AttributeDictionaryAttributeAllowedValues
    • CatalogEntryAttributeDictionaryAttributeRelationship
    • AttributeDictionaryAttributeFolderRelationship
  3. You can include the Delete column header among your column headings. For each record in your file, you can identify if it is to be deleted or not. If the value for the Delete column is 1, the catalog object is to be deleted. If the value for the Delete column is 0 or omitted, the catalog object is not to be deleted.
  4. In the second row, specify the column headers that correspond to the catalog business object.
  5. 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:


    Sample CSV file
  6. Save the worksheet as a CSV file.
  7. Optional: Create catalog data for different catalog business objects. Repeat steps 1 - 5.
  8. Optional: Compress one or more CSV files into a compressed file using a compression utility; password-encrypted compressed files are not supported.
    If you choose to compress your CSV files into a compressed file, be aware of the following:
    • All CSV files must use the same file encoding. For more information about the various file encoding, see Uploading catalog data.
    • Catalog object types must be unique across all the CSV files in the compressed 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, CatalogEntryDescriptionOverride
      8 SKUDefiningAttributeValue, CatalogEntryAttributeDictionaryAttributeRelationship, AttributeDictionaryAttributeFolderRelationship
    Note: By default, the maximum file size for uploads is 10 MB.

Results

You create 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.