inRiver

Retrieve Product Category Based on inRiver Data

After you created the navigation tree, you need to define which Product Model fields take part in determining product category. This is necessary in order to link products to the specific categories in inRiver and thus Sana can determine which product belongs to which category.

Step 1: Open the inRiver Product Model, in the Fields section open the field of the CVL type (you need the same fields (CVLs) you used to build the navigation tree). You need the Field Type Id of the CVL to create the server setting.

Step 2: Go to the Settings in the inRiver Control Center and create the SANA_PRODUCT_HIERARCHY_FIELDS server setting.

You will need the Field Type Id of the CVLs to create the server setting string.

For example, you have the Industry, MainCategory and SubCategory CVLs in your category tree. Combine the Field Type Ids of the CVLs you are going to use in a single string. The strings should be separated with semicolon.

As a result, the setting string will look like this:

ProductIndustry;ProductMainCategory;ProductSubCategory

Then you need to add the setting string you created to the value of the SANA_PRODUCT_HIERARCHY_FIELDS server setting.

When the server setting is created, you need to link products to the specific categories in the inRiver Enrichment Portal. It is necessary for Sana in order to determine which product belongs to which category.

Retrieve Product Category from Related Entity

In inRiver you can also retrieve product categories from the related entity type. For example, you are using Item entity type as a source entity, but you want to retrieve product categories from the related Product entity type. To do this, you need to enter the correct value in the server setting.

Step 1: You need to get the relation which will be used to connect the Product entity type to the Item entity type. Open the inRiver Item Model. On the right side of the page you will see 2 sections: Included in and Includes. Click on Included in to see the list of relations. All related to the Item entity type relations are shown in the Included in section. You will need the Link Type Id of the Product source entity type, which is: ProductItem. You will need this value to create the server setting to connect the Product entity type to the Item entity type.

Now, open the inRiver Product Model and select the necessary field of the CVL type. This field will be used to retrieve a category from the Product entity type. You need the Field Type Id of the CVL to create the server setting, for example: ProductIndustry.

Combine the Link Type Id of the relation which is used to connect the Product entity type and the Item entity type and the Field Type Id of the CVL which is used to retrieve categories from the Product entity type, separating the Ids with an underscore: ProductItem_ProducIndustry. This string is necessary to create the server setting.

Step 2: Create the server setting. Go to the Settings in the inRiver Control Center and create the SANA_ITEM_HIERARCHY_FIELDS server setting. In the value of the server setting enter the string you created in the previous step: ProductItem_ProducIndustry.

Add a product to multiple categories

In Sana one product can belong to multiple product categories.

In the inRiver Product Model in the Fields section, open the field of the CVL type you need and select the Multivalue checkbox. If this checkbox is selected, inRiver allows to add the same product to multiple product categories in Sana.

Import product categories from inRiver to Sana

When the category tree is created and the products are assigned to the categories, you need to import them to Sana.

Step 1: Open Sana Admin and click: Tools > Scheduled tasks. Run the General information import task to retrieve categories from inRiver and import them to Sana.

Step 2: Run Rebuild index for the Product import task. This will allow Sana to define which products belong to which categories.

Step 3: In Sana Admin click: Setup > ERP integration. On the Item categories tab click Import from ERP. This process allows to create product sets and product list pages based on which products belong to which categories.