Webshop filters in Microsoft Dynamics 365 Business Central are used to filter items, customers, contacts, salespeople, stock and store locations. This means that only those items, customers, contacts, salespeople and locations which meet the filter criteria will be available in the Sana webshop. If webshop filters are not configured, all valid items, customers, contacts, salespeople and locations will be available in the Sana webshop.

For example, you can set up webshop filter for items, if you want to show only the items of a certain brand in your Sana webshop. If you don't want certain customers in your ERP systems to purchase online through the Sana webshop for some reason, you can also set up webshop filter for customers.

If you don't use contacts or salespeople at all, you can also disable indexing of customers, contacts or salespeople globally in the settings of the Customer import task in Sana Admin.

Additionally, you can choose to hide certain locations or configure different locations per webshop, providing greater flexibility and more tailored customer experience.

Set Up Webshop Filters

Step 1: In Microsoft Dynamics 365 Business Central click on the search button and enter Webshops.

Step 2: Open the Webshop Card and at the top click Webshop Filter.

Step 3: In the Table Name field, select the table to which the filter should be applied.

Step 4: In the Field Name list, select the table field by which items, customers, contacts, salespeople or locations must be filtered.

Step 5: In the Filter field, enter the filter expression. The filter is applied to the selected table and table field. See example on the screenshot above.

If you set the webshop filters for items, customers, contacts or salespeople, then in the Webshop Catalog Overview window you will see only the filtered items, customers, contacts and salespeople, but not the whole list. Items in the Webshop Catalog Overview window are only filtered by the fields Item No. and Description. If you set up webshop filters for the fields Item No. and Description of the Item table, then only the items which meet the filter criteria will be shown in the Webshop Catalog Overview window.

If you set up webshop filters for customers using the fields No. and Name, then only those customers which meet the filter criteria will be shown in the Webshop Customer Overview window.