Group sorting reset to 0 after integration

Gaetan Di Caro

Posted on 07/12/2015 10:47:29

Hello,

I have set up a data integration job with an Ecom Provider as a destination, to import groups. I would like to import groups as they are and then sort them in the Dynamicweb back-office directly. I have only mapped the columns GroupID, GroupLanguageID, Shops, ParentGroups, GroupName and a custom field.

But, when I run the job, I can find that my custom sorting have disappeared : the column [GroupProductRelationSorting] of the table [EcomGroupProductRelation] is set to 0 for every line.

Do you know how to avoid this ?

Thank you !

Replies

Gaetan Di Caro

Posted on 09/12/2015 10:27:16

I suppose the problem lies with the Ecom provider... Is this a normal behavior ?

I could replace it by a Dynamicweb provider, but I'm not sure which tables/fields to map to keep it working the same way.

Jonas Krarup Dam

Posted on 09/12/2015 11:11:27

Hi Gaetan,

I haven't seen this problem before.

Do you have an example input file I can use to test, so I'm sure my test scenario matches your setup?

It is most likely an EcomProvider specific problem, and yes, you can probably work around it by using the DynamicwebProvider. If you chose to do so, you wil probably have to add data to some/most of the following tables:

EcomGroups

EcomShopGroupRelations

EcomGroupProductRelations (if you are also importing products into specific groups)

EcomGroupRelations (for parent groups)

Regards, Jonas

Morten Snedker

Posted on 10/12/2015 12:59:58

This post has been marked as an answer

Hi,

Just to wrap it up: it is a bug (#20287) that occurs whenever ParentGroups is mapped, having EcomGroups as destination table, and using the Ecom Provider. The bug is not yet fixed.

Best regards
Morten Snedker

Votes for this answer: 1

You must be logged in to post in the forum

Developer forum

Group sorting reset to 0 after integration

Replies