Data load utility CSV column definitions
Look up the column definitions for catalog business objects to find details about the required and optional fields, and the values that they can contain.
- The first line of the CSV file contains the keyword for the catalog business object type.
- The second line of the CSV file contains the column definitions available for the catalog business object type.
- The keyword and column headers for the catalog business object type are case sensitive.
- Catalog
Use the Catalog keyword to load master catalog or sales catalog data into the database using a CSV file. The CSV file contains column definitions specifying the characteristics of the catalog business object type.
- Catalog description
Use the CatalogDescription keyword to load catalog description data in multiple languages into the database using a CSV file. The CSV file contains column definitions specifying the characteristics of the catalog business object type.
- Catalog group
Use the CatalogGroup keyword to load categories, and optionally the categories description, the categories calculation code, and the parent and child category relationships into the database using a CSV file. The CSV file contains column definitions specifying the characteristics of the catalog business object type.
- Catalog group association
Use the CatalogGroupAssociation keyword to load merchandising associations between categories into the database using a CSV file. The CSV file contains column definitions specifying the characteristics of the catalog business object type.
- Catalog group calculation code
Use the CatalogGroupCalculationCode keyword to load a categories calculation code into the database using a CSV file. The CSV file contains column definitions specifying the characteristics of the catalog business object type.
- Catalog group description
Use the CatalogGroupDescription keyword to load category descriptions into the database using a CSV file. The CSV file contains column definitions specifying the characteristics of the catalog business object type.
- Catalog group relationship
Use the CatalogGroupRelationship keyword to load the parent and child category relationships into the database using a CSV file. The CSV file contains column definitions specifying the characteristics of the catalog business object type.
- Catalog entry
Use the CatalogEntry keyword to load catalog entries (products, SKUs, bundles and kits) and the catalog entries calculation code into the database using a CSV file. The CSV file contains column definitions specifying the characteristics of the catalog business object type.
- Catalog entry association
Use the CatalogEntryAssociation keyword to load merchandising associations between catalog entries into the database using a CSV file. The CSV file contains column definitions specifying the characteristics of the catalog business object type.
- Catalog entry calculation code
Use the CatalogEntryCalculationCode keyword to load catalog entry calculation codes into the database using a CSV file. The CSV file contains column definitions specifying the characteristics of the catalog business object type. There are calculation codes for different usages; the provided calculation code usages discount, shipping, sales tax, shipping tax, coupon, surcharge, and shipping adjustment
- Catalog entry component
Use the CatalogEntryComponent keyword to load the relationship between the parent kit (package, bundle, and dynamic kit) and its child catalog entries into the database using a CSV file. The CSV file contains column definitions specifying the characteristics of the catalog business object type.
- 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.
- Catalog entry descriptive attribute and value
Use the CatalogEntryDescriptiveAttributeAndValue keyword to load classic descriptive attributes and values for a product or SKU into the database using a CSV file. The CSV file contains column definitions specifying the characteristics of the catalog business object type.
- Catalog entry inventory
Use the CatalogEntryInventory keyword to load catalog entry inventory (non-ATP store) into the database using a CSV file. The CSV file contains column definitions specifying the characteristics of the catalog business object type.
- Catalog entry ATP inventory
Use the CatalogEntryATPInventory keyword to load catalog entry inventory (ATP store) into the database using a CSV file. The CSV file contains column definitions specifying the characteristics of the catalog business object type.
- Catalog entry offer price
Use the CatalogEntryOfferPrice keyword to load a catalog entry offer price into the database using a CSV file. The CSV file contains column definitions specifying the characteristics of the catalog business object type.
- Catalog entry parent catalog group relationship
Use the CatalogEntryParentCatalogGroupRelationship keyword to load the parent/child relationships between categories and catalog entries into the database using a CSV file. The CSV file contains column definitions specifying the characteristics of the catalog business object type.
- Catalog entry parent product relationship
Use the CatalogEntryParentProductRelationship keyword to load product and SKU relationships between catalog entries into the database using a CSV file. The CSV file contains column definitions specifying the characteristics of the catalog business object type.
- Product defining attribute and allowed values
Use the ProductDefiningAttributeAndAllowedValue keyword to load classic attributes and allowed values for a product into the database using a CSV file. The CSV file contains column definitions specifying the characteristics of the catalog business object type.
- SKU defining attribute value
Use the SKUDefiningAttributeValue keyword to load classic attribute value for SKUs into the database using a CSV file. The CSV file contains column definitions specifying the characteristics of the catalog business object type.
- Attribute dictionary attribute allowed values
Use the AttributeDictionaryAttributeAllowedValues keyword to load attribute dictionary attributes allowed values (in other languages) into the database using a CSV file. If you are loading attributes in a different language for the first time, log out of the Management Center and then log on again to be able to see the attribute dictionary attributes.. Also, ensure that the store supports the language. The CSV file contains column definitions specifying the characteristics of the catalog business object type.
- Attribute dictionary attribute and allowed values
Use the AttributeDictionaryAttributeAndAllowedValues keyword to load attribute dictionary attributes and allowed values into the database using a CSV file. If you are loading attributes to the store for the first time, log out of the Management Center and then log on again to be able to see the attribute dictionary attributes. The CSV file contains column definitions specifying the characteristics of the catalog business object type.
- Catalog entry attribute dictionary attribute relationship
Use the CatalogEntryAttributeDictionaryAttributeRelationship keyword to load attribute dictionary attribute value for SKUs into the database using a CSV file. The CSV file contains column definitions specifying the characteristics of the catalog business object type.