In a spreadsheet editor, you can create the catalog
filter data that you want to upload in CSV format. The easiest way
to create this data is to download a sample CSV file to use as a starting
point
Procedure
- Open a spreadsheet editor.
- In the first cell of the first row, specify which catalog
filter business object type to upload.
Choose one of
the following keywords, type the keyword exactly as shown:
- CatalogFilter
- CatalogFilterCategory
- CatalogFilterCatentry
- CatalogFilterCondition
- CatalogFilterConditionGroup
- In the second row, specify the column headers that correspond
to the catalog filter business object type.
- Starting from the third row, define your catalog filter
by specifying values in the mandatory and optional columns.
- Save the worksheet as a CSV file.
- Optional: Create catalog filter data for different
catalog filter 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 filter data.
- If you specified different catalog filter object types in the
compressed file, the catalog filter object types are uploaded in the
following order: Catalog filter, Catalog filter catalog entry, Catalog
filter category, Catalog filter condition groups, Catalog filter conditions.
Note: By default, the maximum file size for uploads is 10
MB.
Results
The CSV files are created in a suitable format for the Catalog
Filter Upload feature. When you upload the file, the keyword and the
column headers are interpreted but are not uploaded to the catalog
filter.