Skip to content

Özkan Çınar Posts

Hybris (SAP Commerce) MSSQL How to get database table details in HAC (Administration Console)?

How to get MSSQL table details (attributes) in Hybris Administration Console (HAC) by a basic query. If you don’t have access to DB directly, you can fetch table attributes by this way.

Buy 2 products of the same category, get x% discount on those products

Scenario You want to set a discount if a user buys more than 2 different products in a category. You would like to sell more products of specific categories by offering discounts to users. Accomplishing this is possible in SAP Commerce Hybris by an OOTB (Out of the box) way. If you want to apply a promotion if a user adds 2 amounts of the same products to his cart, see this post. If you are looking for more articles about promotions, check here. Implementation I would like to offer a discount for BALLS category. If the user adds 2 or more balls products, a 10 percent discount will be applied to those products. Go to Backoffice → Marketing → Promotion Rules Create a new Promotion by clicking the ‘+’ button Give a name. Select web site. Set priority as you desired. Select product promotion Add 2 containers Add Qualifying categories to both containers. Add the same category that you want to apply for promotion. In the actions tab, add Percentage discount on partner products. Set containers and numbers as below. Save and publish. Test I added 2 Balls products and 1 product from another category. 10% discount only applied…

How to Add a Customer Group Restriction to Navigation Node

You have some exclusive customers. You offer some special sales for these customers. They should be able to see a navigation node on the page so they can visit the special campaign page. So, you have to display some navigation nodes for users who belong to a specific user group and hide them for other users. To accomplish this requirement we can use Search Restriction. Search Restriction Search restriction is a restriction type that you can apply for models. It has 3 main parts: Restricted Type (Model): Model that you want to apply restriction Apply On: User group for filtering the model Filter (Query): Custom query. This query will be added to end of the normal query of the model. Filter query will be added at end of the your model’s SQL query. By this, we will be able to add some additional filters to the model’s query. What a great idea! You can find search restrictions in the Backoffice → System → Personalization Implementation Create user group I have a user group called FamilySaleGroup. I want to make a navigation node visible for only users of this group. User group impex: Create navigation nodes I have two navigation nodes.…