File format for uploading catalog filter data
The load file that we use to upload catalog filters must follow a specific format so that the data loads correctly into the WebSphere Commerce database. A sample CSV file is provided. The following screen capture shows the data that is contained in a sample CSV file for catalog filter data (note that the image is split into two rows to fit on this page):
In the CSV file:
- The first row must contain the keyword that corresponds to the catalog filter business object type to upload.
- The second row must contain the column headings.
- The remaining rows contain catalog filter data.
The keyword and column headings are case-sensitive.
Catalog filter business object column definition
The following table lists the catalog filter business object typesNote: The sample CSV files do not include all the available columns for the catalog filter business object types. For a complete list of the available columns for the catalog filter business object types, see Catalog filter object input file definitions.
| To upload ... | CSV keyword | Sample CSV file |
|---|---|---|
| Catalog filter name, description, and identifier | CatalogFilter | CatalogFilter.csv |
| Catalog entry inclusion and exclusion selection for an existing catalog filter | CatalogFilterCatentry | CatalogFilterCatentry.csv |
| Category inclusion and exclusion selection for an existing catalog filter | CatalogFilterCategory | CatalogFilterCategory.csv |
| Condition groups for an existing catalog filter | CatalogFilterConditionGroup | CatalogFilterConditionGroup.csv |
| Attribute dictionary attribute and property conditions and condition values for an existing catalog filter | CatalogFilterCondition | CatalogFilterCondition.csv |
Related concepts
Catalog filtering
Catalog Filter and Pricing tool
Catalog filter uploads
Related reference
Scenarios for using catalog filters