1

We are implementing Hybris PCM and we would like to create some product category restrictions.

Some employees should find only the products with a specific category. For example, some employees can see only products with category "drills," while other employees can see only products with category "shoes".

How can we do this in Backoffice and PCM?

Adrian Mole
  • 49,934
  • 160
  • 51
  • 83
Marco Menegazzo
  • 23
  • 8

1 Answers1

1

Search restrictions (personalization) can be used to achieve this:

INSERT_UPDATE SearchRestriction;code[unique=true];active;generate;restrictedType(code);principal(uid);query
                               ;Product_restriction_1; true; false; Product; usergroup1; "{category} in ({{ select {pk} from {Category} where {code}='category1' }})"
                               ;Product_restriction_2; true; false; Product; usergroup2; "{category} in ({{ select {pk} from {Category} where {code}='category1' }})"

Here employees belonging to usergroup1 can see products belonging to category1 and usergroup2 can see products belonging to category2 (these queries given above are just some dummy queries for quick understanding of concept).

Restriction type = product Principal = user/ usergroup corresponding to the backoffice employee logging in

A more specific query to suit your requirement would be:

select {r.target} from { CategoryProductRelation as r join Category as c on {r.source}= {c.pk} } where {c.code}='shoes'

Hence please use an impex like:

INSERT_UPDATE SearchRestriction;code[unique=true];active;generate;restrictedType(code);principal(uid);query
                           ;Product_restriction_shoes; true; false; Product; shoeUser; " {pk} in ({{select {r.target} from { CategoryProductRelation as r join Category as c on {r.source}= {c.pk} } where {c.code}='shoes' }}) "
balias
  • 499
  • 1
  • 4
  • 17
  • Thanks!! it works! another question..how can i see this search restriction via backoffice? – Marco Menegazzo Sep 30 '20 at 15:14
  • You can navigate to System > Personalization in admininstration cockpit (default view) of backoffice. – balias Sep 30 '20 at 16:03
  • Hey! I found this query pretty close to my needs. My VariantProducts have a "BaseProduct" field. I need to make a restriction by category like this, but searching in my baseproduct field! – Nicolas Villacorta Jun 06 '22 at 14:26