Start a new topic
Answered

Categories with same name

When developing in Virto 1.11 - we noticed that we can not have 2 categories (sub-categories) in a master catalog with the same Code / Name (even if they are under different parent categories).


We have traced this down to an Index restriction on the CategoryBase table where there is an IX_Code_CatalogId index that requires all Category Codes within a Catalog to by Unique.


Since the primary key is a GUID for Categories, we were wondering why the Code needed to be unique across the entire Catalog?


We were creating a Master Catalog with multiple brands, and in each brand we were going to create sub-categories to match the storefront taxonomy, however with this restriction we need to create individual brand catalogs.


This makes for a lot of catalogs, and also mean we have to re-enter in all of the property sets over and over (as we have probably 20 brands).  If they were all under one master it would be far easier.


Please let us know if this is a hard-constraint of the system, or if we can modify the index to allow for duplicate Codes.


Thanks,

Brian


Best Answer

Category Code is supposed to be unique, it is another way besides internal category id to look up a specific category and is typically used for importing or synchronization. If you concerned about frontend taxonomy there are several ways to mitigate it. First, you can define taxonomy yourself using SEO tab, it doesn't need to be category code (it is just that by default). The other method will be to create a virtual catalog and then define a different taxonomy there by linking brand categories together under one category.


Let me know if that resolves the issue for you?

1 Comment

Answer

Category Code is supposed to be unique, it is another way besides internal category id to look up a specific category and is typically used for importing or synchronization. If you concerned about frontend taxonomy there are several ways to mitigate it. First, you can define taxonomy yourself using SEO tab, it doesn't need to be category code (it is just that by default). The other method will be to create a virtual catalog and then define a different taxonomy there by linking brand categories together under one category.


Let me know if that resolves the issue for you?

Login or Signup to post a comment