Import group tree into PIM and Ecom

E-mail notifications

Marie Louise Veigert

Posted on 20/06/2023 12:42:14

Hi,

Im trying to import groups from ERP to both PIM and Ecom.

Source is XML Provider

Destination is Dynamicweb provider.

I have this tables mapped:

Im not getting a ShopGroupRelationsSorting, so every group is set to '0'.

I tried to create at test and add sort value for the root groups and set 'null' in the subgroups. This didn't work, so Im not thinking this is the issue.

The GroupIDs from ERP are containing letters like Ø,Æ,Å and characters like '-' and spaces.
Are this an issue?

It looks correct in the tables in the database but in backoffice it doesn't show any groups at all.

The indexes are build.

Anyone having a suggestion to what I could be missing? Are there some groupfields which is required for it to work?

Replies

Dmitriy Benyuk

Posted on 20/06/2023 15:38:05

Hi Marie,
if you are importing the same group to multiple shops then it will only be shown in just one shop but not in all others, so maybe this is your case?
Also the option "Disable cache clearing" needs to be un-checked.
BR, Dmitrij

Michael Knudsen

Posted on 20/06/2023 16:51:55

Hello Marie,

- if you are importing the 'same' groups from ERP to both PIM and Ecommerce, are you doing some XSLT transformation, so you have unique 'GroupID'? Using a unique prefix for 'PIM' groups and another for 'Ecom' groups should make it possible to import the same group tree into PIM and Ecom.

Br. Michael Knudsen

Marie Louise Veigert

Posted on 21/06/2023 08:09:22

Hi Dmitriy and Michael,

It’s the same groups for both ecom and PIM besides lvl 3.
But the ERP is handling the ID part by adding 'E ' to the ecom groups.

In the destination the setup for the Dynamicweb Provider is as follows with 'disable clear caching' not checked.

At one point one of the root groups was shown, but now no shops is shown - in either PIM or Ecom.
So I was wondering if the groupIDs could have something to do with it.

Example of groupIds and the sorting in EcomShopGroupsRelation table for the PIM:

The same groupIDs in ecom is fx
E AX1GAM FKM

And the EcomGroupRelations:

Are there any no go's in GroupIDs like these?

BR Marie Louise

Michael Knudsen

Posted on 21/06/2023 08:43:14

This post has been marked as an answer

Hello Marie Louise,

- I would avoid using " " (space), "," (comma), "." (dot) and "+" (plus) in any of DW ID's, but instead of removing the char, you should concider replacement with eg. "_" (underscore) or some other char.

Br. Michael Knudsen

Votes for this answer: 1

Marie Louise Veigert

Posted on 21/06/2023 12:46:37

Thanks for the input Michael.
I have tried to make a test without space, but still have issues.

Do you know wether there is a limit of the IDs length?

Michael Knudsen

Posted on 21/06/2023 13:30:03

Hello Marie Louise,

- all fields have limits according to the database schema and for the EcomGroups.GroupId is it 255 chars. I assume that would be the same for all other Id fields.

Br. Michael Knudsen

Marie Louise Veigert

Posted on 21/06/2023 13:32:15

Hi,

It shouldn't be the issue then with 255 available :)

Marie Louise Veigert

Posted on 22/06/2023 10:32:48

We figured out it was because the 'tree' from NAV was missing a parent reference, so the tree was broken.
So no wrong setup in Dynamicweb - but the spaces needed to be removed as well :)

You must be logged in to post in the forum

Developer forum

Import group tree into PIM and Ecom

Replies