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
Procedure
- Open a spreadsheet editor.
- 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
- 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.
- In the second row, specify the column headers that correspond to the catalog business object.
- 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:
- Save the worksheet as a CSV file.
- Optional: Create catalog data for different catalog business objects. Repeat steps 1 - 5.
- 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.