Migrating facetable attributes

If you are migrating from WebSphere Commerce Version 7 Feature Pack 2, 3, or 4, migrate facetable attributes.

Note: WebSphere Commerce Version 8 does not support attributes that are not in the attribute dictionary. You must use attribute dictionary attributes for faceted navigation.

Procedure

  1. Go to the following directory:
    • WC_installdir/bin
  2. For attribute dictionary facetable attributes, run the search faceted attributes migration utility:
    • WindowsmigrateSearchFacet.bat -instance instance_name -dbuser db_user -dbuserpwd db_password
    • AIXLinuxmigrateSearchFacet.sh -instance instance_name -dbuser db_user -dbuserpwd db_password
    Where:
    instance_name
    The name of the WebSphere Commerce instance with which you are working (for example, demo).
    dbuser
    The name of the user that is connecting to the database.
    dbuserpwd
    The password for the user that is connecting to the database.
  3. To ensure that the migrated attributes display in the storefront, set the FACETABLE column of the ATTR table to 1: 
    
UPDATE ATTR SET FACETABLE = 1 WHERE ATTR_ID IN (list_of_facetable_attribute_ids);