Settings

Sana Commerce 8.2
Your provider

Back Next

Search

Sana Commerce search is based on the Lucene search engine. By adding the product fields to the Lucene index you can extend the webshop search functionality.

The configuration of the Sana Commerce enhanced search settings provides the possibility to search products by different keywords: title, item number, color, size, description and others. The phonetic search can be used. Sorting and filtering can be configured to provide the possibility to the customers to sort the products by different values and refine the search request using the facets.

The search settings can be configured in the backoffice: Settings -> Search:

Webshop Search Settings

Phonetic search provides the possibility to search text by phonetic representation of the keywords pronunciation. This allows to search products not by the exact spelling of the words but by their pronunciation. It is useful when the customer does not know the exact spelling of the word or misspelt.

For example, if you are not sure how to spell the word 'discount' you can type 'diskaunt', 'dizkaunt', 'discaunt', in the search field, which is close to the pronunciation of the word 'discount'.

In the 'Keyword fields' section you can extend the webshop search by adding the fields to the index on which the customer can do the search.

The table below provides the description of the keywords search settings:

Field	Description
Field name	This dropdown list presents all the fields the customer can search on.
Lookup table name	If a field from the 'Item' table in NAV / AX is related to another table and this field is selected in the 'Field name' dropdown, the name of the lookup table will be shown in this column.
Lookup field name	This dropdown list provides all available fields from the lookup table which can be selected for display. If no field from the lookup table is selected a value of the field specified in the 'Field name' column will be shown by default.

Using search index fields you can configure filtering and sorting of the products on the search results and product list pages.

The table below provides the description of the facet and sorting settings:

Field	Description
Field name	This dropdown list presents all fields which can be used for sorting and filtering (using facets) of the products. These fields are also used for the product sets configuration. Note: Depending on the type of the field sorting and filtering may not be available.
Sortable	This option allows to sort products by the selected field names.
Facet	This option allows to filter the products (using facets) by the selected field names. For all product list pages the default facets are used but they can be redefined for each product list page individually. Go to 'Content -> Product list pages', find the necessary product list page and override the default facets. 'Facets multiselection' can be also enabled in the 'Search settings' section which provides the possibility to select many facets on the search results and product list pages. For example, you want to filter by few brands. By enabling or disabling the option 'Show facets with empty values' you can hide or show the facets on the frontend which do not have values. But it is possible to edit Sana texts for the empty-valued facets in the Frontend Editor.

The field names differ depending on your webshop provider. The field names which are at the head of the list and in bold type are optimized provider fields. The data from the standard fields is retrieved from the 'Items' table in Microsoft Dynamics NAV ('Released products' in Microsoft Dynamics AX), while the data from the optimized fields is retrieved from different places.

The tables below provide the description of the optimized fields:

Microsoft Dynamics NAV

Keyword fields:

Field	Description
Color	Used to search products by color and/or size. These two fields are used in the Sana Commerce NAV Connector with Fashion add-on. The colors are retrieved from the 'Item Vertical Components' table, while sizes are retrieved from the 'Item Horizontal Components' table.
Size
Description	Used to search products by description. If product description is present in the Sana Commerce backoffice the data will be retrieved from the backoffice. If there is no product description in the Sana Commerce backoffice the data is retrieved from the 'Extended Text' table in Microsoft Dynamics NAV. If product description is present in different languages it is also used.
Title	Used to search products by name. The data is retrieved from the 'Items' table, the 'Description' field. If product names are present in different languages, then product names translations are also used.
Variant Title	Used to search product variants by name. The data is retrieved from the 'Item Variants' table, the 'Description' field. If product variants names are present in different languages, then product variants translations are also used.

Search index fields:

Field	Description	Sortable	Facet
Color	Used to filter products by color and/or size. These two fields are used in the Sana Commerce NAV Connector with Fashion add-on. The colors are retrieved from the 'Item Vertical Components' table, while sizes are retrieved from the 'Item Horizontal Components' table. To be able to use color and size for filtering in standard NAV Connector requires customization.	No	Yes
Size		No	Yes
Gross weight (orderable products only)	Gross weight is not used for sorting or facets. It can be added to the search index to become available as filter for product sets. The data is retrieved from the 'Item Units of Measure' table, the 'Weight' field.	No	No
Price	Used to sort products by unit price. The data is retrieved form the 'Items' table, the 'Unit Price' field. The customer specific prices are not used for sorting.	Yes	No
Product category	Used to filter products by product category. The data is retrieved from the 'Item Categories' and 'Product Groups' tables, the 'Description' field, as combination of the item category and product group descriptions. If product categories (item category and product group) are present in different languages, then product categories translations are also used.	No	Yes
Title	Used to sort products by name. The data is retrieved from the 'Items' table, the 'Description' field. If product names are present in different languages, then product names translations are also used.	Yes	No

Microsoft Dynamics AX

Keyword fields:

Field	Description
Color	Used to search products by color and/or size. The data is retrieved from the 'Released product variants' table. The colors are retrieved from the 'Color' field, while sizes are retrieved from the 'Size' field.
Size
Description	Used to search products by description. If product description is present in the Sana Commerce backoffice the data will be retrieved from the backoffice. If there is no product description in the Sana Commerce backoffice the data is retrieved from 'Presentations' or 'Translations' in Microsoft Dynamics AX. If product description is present in different languages it is also used. For more information about product description in Microsoft Dynamics AX, see 'Product Description'.
Title	Used to search products by name. The data is retrieved from the 'Released products' table, the 'Product name' field. If product names are present in different languages, then product names translations are also used.
Variant Title	Used to search product variants by name. The data is retrieved from the 'Released product variants' table, the 'Product name' field. If product variants names are present in different languages, then product variants names translations are also used.

Search index fields:

Field	Description	Sortable	Facet
Color	Used to filter products by color and/or size. The data is retrieved from the 'Released product variants' table. The colors are retrieved from the 'Color' field, while sizes are retrieved from the 'Size' field.	No	Yes
Size		No	Yes
Gross weight (orderable products only)	Gross weight is not used for sorting or facets. It can be added to the search index to become available as filter for product sets. The data is retrieved from the 'Released products' table, the 'Gross weight' field.	No	No
Price	Used to sort products by base sales price. The data is retrieved from the 'Released products' table, the 'Price' field.	Yes	No
Product category	Used to filter products by product category. The data is retrieved from the 'Item groups' table, the 'Name' field. If item groups are present in different languages, then item groups translations are also used.	No	Yes
Title	Used to sort products by name. The data is retrieved from the 'Released products' table, the 'Product name' field. If product names are present in different languages, then product names translations are also used.	Yes	No

When the search is configured or you change the search settings the index should be rebuilt. In this case you will receive the message that the index should be updated by running the index task.

Back Next

User GuideSettings

Sitemap

Installation

Product Versions

Links

Sana Commerce does not accept any liability for the content of this website, or for the consequences of any actions taken on the basis of the information provided. The information below should be interpreted as an example. No rights can be derived from this information.

Sana Commerce – the integrated e-Commerce solution for Microsoft Dynamics NAV & AX

Updated: January 2013