Try our conversational search powered by Generative AI!

[11.8.4] Why not possible to set IsPrimary=true for NodeEntryRelation for different Catalogs?



We have a setup where we have two catalogs in Episerver Commerce, one for our swedish assortment and one for our norwegian assortment. These assortments have separate category structures but share the same products and variants in quite a lot of cases. Therefore we'd also like to create separate primary NodeEntryRelations for products and variants in these two separate catalogs but that's not possible since there can only be one entry in the table NodeEntryRelation that has the column IsPrimary set to 1. My question is why this constraint is not also including CatalogId as a key column? Or are we doing something wrong in our catalog/category structure? 

Best regards


Jul 13, 2018 11:25

An entry can belong to one catalog. All other catalogs are linked. For that reason we don't think we should allow multiple primary NodeEntryRelations. But as always we are open to suggestions. Why would you want to do that?

Jul 13, 2018 12:14

Maybe it's just a lack of understanding on my side regarding these details but considering that an entry can only belong to one catalog, say the Swedish catalog in our case. If we have this fictive category structure:

Swedish catalog 

--- Category A

--- Category B

Norwegian catalog

--- Category C

--- Category D

In the Swedish catalog we want to make it clear that the primary category for the entry is "Category A" and in Norway "Category D", this is not possible with this limitation. If we do set "Category A" as primary NodeEntryRelation and "Category D" as a non-primary NodeEntryRelation, looking at the entry under the Norwegian category tree in Commerce will show the user that the entry's primary category actually is a category in the Swedish catalog, which might be a bit confusing I guess?

Jul 13, 2018 12:55

Interesting. I still think an entry should belong to a catalog, and that kinda contradicts with two primary nodes. If the editors understand that rule then it will be not confusing to them, I suppose

Jul 13, 2018 13:07

Then we'll do as we're told (wink) and stick with one primary category, most probably the one that is located in the same catalog as the entry belongs to. Thanks for your quick response Quan! 

Jul 13, 2018 13:35

The concept of a primary category is also defined by its mapping to the ParentLink of the content model. ParentLink can only represent one parent relation. ParentLink is in turn used for example when building the default route, where again multiple values are not possible.

Jul 14, 2018 9:16
This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.