HCL Commerce Enterprise

Uploading catalog filter data

Use the Catalog Filter Upload feature in Management Center to upload catalog filter data in your CSV file or compressed file (.zip) into the database.

Before you begin

Ensure that you complete the steps in the following topic: Creating catalog filter data in CSV format.

Procedure

  1. Open Management Center tools and from the hamburger menu, click Manage Accounts > Catalog Filter and Pricing.
  2. HCL Commerce Version 9.1.16.0 or later Open Management Center tools and from the left navigation menu, click Business tools > Customer Management > Catalog Filters.
  3. From the toolbar, click the arrow on the right side of New icon New iconCreate New icon; then select Catalog Filter Upload.
  4. In the New Catalog Filter Upload page:
    1. Browse for the CSV file or compressed file (.zip) you want to upload.
    2. Select the file encoding that applies to your catalog filter data:
      UTF-8
      This is the default encoding. English uses this encoding, and some other languages can also use this encoding.
      UTF-16
      This encoding is large enough to cover all languages.
      GB2312
      This encoding is for simplified Chinese used in People's Republic of China.
      Big5
      This encoding is for traditional Chinese encoding that is used in Taiwan, Hong Kong, and Macau.
      Windows Latin-1
      This encoding supports more characters than the English language, such as the copyright symbol, Copyright symbol.
      ISO 8859-1
      This encoding is used for languages in the Americas, Western Europe, Oceania, and much of Africa.
      ISO 8859-15
      This encoding is used for some European languages, and also contains the euro sign €.
      KS C 5601 (KS X 1001)
      This encoding is used for Korean.
      Shift-JIS
      This encoding is used for Japanese.
  5. Click Save and Close.
    After you upload the file, the HCL Commerce server uploads the catalog filter data into the database tables. The total time for the upload to complete depends on the amount of catalog filter data.
  6. To check the status of your upload, from the explorer tree, click Catalog Filter Uploads.
    The Catalog Filter Uploads list is displayed.
    OptionDescription
    File name The name of the uploaded CSV file or compressed file.
    Size The size of the uploaded file in kilobytes.
    User name The identifier of the user who uploaded the file.
    Start time The time the catalog upload process begins.
    End time The time the catalog upload process ends.
    Status The status of the catalog upload.
    Idle
    The initial status when the catalog upload is waiting to start.
    Processing Processing
    The CSV file or the compressed file is uploaded to the server and is submitted for publishing.
    Successful Successful
    The file is published without any errors or exception messages.
    Failed Failed
    The file was submitted for publishing, but publishing did not complete. There are errors or exception messages.
    Server path The server file path of the uploaded file. This column is not shown by default.
    Upload time The time the uploaded file is uploaded to the server. This column is not shown by default.
    Unique ID The internal unique identifier of the catalog upload. This column is not shown by default.
  7. Select your catalog filter upload from the Catalog Uploads - List view.
    The properties page for the selected upload is displayed.
    Note: An extra Status section is shown on the properties page when the upload completes or fails. This section contains a more detailed status of the selected catalog filter upload.
  8. Optional: If your catalog filter upload fails or is successful, you might want to remove the entry from the Catalog Filter Uploads - List view. Right-click the catalog filter upload entry that you want to remove; then click Delete.
    The catalog filter upload entry is removed from the list view, but the catalog filter upload action is not affected.

What to do next

You can view and modify the new catalog filter in the Catalog Filter and Pricing tool. For example, you can change the description of the catalog filter.