ERP User GuideSAP Business One

SAP Business One

Sana Commerce 9.3
Your connector

Web Store Filters

Web store filters in SAP Business One are used to filter items, business partners (customers) and sales agents. This means that only those items, business partners and sales agents that meet the filter criteria will be indexed by Sana and available in the Sana web store. If web store filters are not configured, all valid items, business partners and sales agents will be available in Sana after indexing.

For example, you can set up a web store filter for items, if you want to show only the items assigned to some specific item groups in your Sana web store. If you don't want certain customers that exist in your SAP Business One system to purchase online through the Sana web store for some reason, you can also set up web store filter for customers.

If you don't use sales agents at all, for example, you can also disable indexing of sales agents globally in the settings of the Customer import task in Sana Admin. For more information, see "Customer import".

Enable Web Store Filters for SAP Business One Cloud


Applies to: SAP Business One Cloud

Before setting up web store filters in SAP Business One Cloud, you must download the necessary metadata files.

Step 1: Run SAP Business One Cloud as a Windows administrator and go to: Web Store > Setup > Services > Configure Service Layer.

Step 2: Set up Service Layer, if not configured yet.

Field Description
Service Layer URL Enter SAP Business One Service Layer service URL. You must request it from your SAP Business One Cloud implementation partner.
Company User Name Enter the credentials of the dedicated database user that is used to log in to the SAP company the Sana add-on is assigned to. This must be a super user with an Indirect Access user or professional license in SAP Business One Cloud.
Company Password

Step 3: Click Test Connection to check Service Layer configuration. If connection is successful, save your changes.

Step 4: Click Download Metadata. To be able to set up web store filters, you must download the metadata files to the location where the Sana add-on is installed.

Now you can set up web store filters.

Set up web store filters

Step 1: In SAP Business One click: Web Store > Web Stores.

Step 2: Select your Web Store and click Web Store Filter. If you have multiple web stores, you can set up different filters for each web store.

Step 3: Click on the required filter button depending on data that you want to filter - items, customers or sales agents. On the screenshot below you can see an example of the catalog filter for the items.

Step 4: In the Field Name list, select a field by which items, customers or sales agents must be filtered. The list of fields that is shown here depends on the web store filter that you configure.

Step 5: Select the required Filter Method. It indicates a specific filter expression. The combination of the filter method and value defines the filter for the selected field name.


Starting from Sana 9.3.4 you can use the filter method called "In" which allows to enter multiple filter values for a field. You can separate multiple filter values with a "," (comma). This filter method can be used for catalog, customer and sales agent filters.

Step 6: Enter the filed value in the Filter field and click Add.

This way you can add as many filters for different fields and values as you need.

ERP User GuideSAP Business One