Developer forum

Forum » Integration » PIm Groups not visisble in PIM

PIm Groups not visisble in PIM

E-mail notifications
Justin Sjouw Dynamicweb Employee
Justin Sjouw
Reply
Posted on 25/07/2023 10:44:29

Hello,

I. working on importing a Group structure in PIM.

  • The PIM Warehouse is defined as SHOP3
  • All groups are imported into EcomGroups (with a GROUPID provided in the source file)
  • All GoupID's are added to EcomShopGroupRelation to connect them to SHOP3
  • The parent child relations between groups are imported into EcomGroupRelations

From a database perspective this all looks good, but the groups do not show in the Admin interface when I expand the Warehouse.

What am I missing?

Thanks,

Justin


Replies

 
Rasmus Sanggaard Dynamicweb Employee
Rasmus Sanggaard
Posted on 25/07/2023 11:14:57
Reply

Hi Justin, 

The shop needs to have ShopType = 2 in EcomShops to appear as a PIM Warehouse and remember to refresh ShopService cache. 

 

BR Rasmus  

 
Justin Sjouw Dynamicweb Employee
Justin Sjouw
Posted on 25/07/2023 11:33:48
Reply

Hey Rasmus,

The SHOP3 does have type 2, and it does show up as a PIM warehouse. However, the groups that should be part of it do not show up.

Clearing the ShopService cache does not effect this.

This is an excerpt of the EcomShopGroupRelation table:

And this from EcomGroups

LANG1 is en-US and I am logged in with an account with EN as default language.

Any idea what I could be missing?

Thanks,

Justin

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 25/07/2023 12:43:56
Reply

Hi Justin,
can you show what is in the Group relations table? Maybe there could be a circular references or no root groups can be found.
BR, Dmitrij

 
Justin Sjouw Dynamicweb Employee
Justin Sjouw
Posted on 25/07/2023 13:10:34
Reply

Hey Dmitriy,

This is the bottom page of the table, you can see that there are several parent groups, and they are set as parent of child groups:

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 25/07/2023 13:23:59
Reply

Ok, then try to delete the rows where GroupRelationsParentId = 0 and recycle the site or clear caches

 
Justin Sjouw Dynamicweb Employee
Justin Sjouw
Posted on 25/07/2023 13:36:14
Reply

Thanks that did the trick. I thought I saw in a demo solution that all groups must be in the relations table, but I have probably interpreted that wrong.

Thanks!

Justin

 

You must be logged in to post in the forum