Developer forum

Forum » Ecommerce - Standard features » Groups from data integration not displaying subgroups and products

Groups from data integration not displaying subgroups and products

E-mail notifications
Arnór Halldórsson
Arnór Halldórsson
Reply
Posted on 31/05/2018 11:47:13

Hi,

We´ve had a bug in a couple of our solutions where newly imported Groups (imported from NAV in one case, AX in another) don´t show any subgroups, and the products affiliated with them don´t appear under All Products until you open up the group and hit Save and close, see images: https://imgur.com/a/XQaaz0k

Has anyone else had this issue?

Best regards,
Arnór Geir


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 31/05/2018 13:09:20
Reply

Hi Arnór,
in what Dynamicweb version is this reproduced? Can you provide a sample/part of the xml with some groups and products you are importing to Dynamicweb and point what destination provider do you use Ecom or Dynamicweb provider?
Regards, Dmitrij

 
Arnór Halldórsson
Arnór Halldórsson
Posted on 31/05/2018 17:35:47
Reply

Hi Dimitri,

Thank you for a quick response! We´ve experienced this in versions ranging from 9.3.5 all the way to 9.3.12. Always using the Dynamicweb Provider as our destination provider.

Example XML:

<tables>
<table tableName="EcomProducts">
<item table="EcomProducts">
<column columnName="ProductId"><![CDATA[184091]]></column>
<column columnName="ProductLanguageId"><![CDATA[LANG1]]></column>
<column columnName="ProductVariantId"><![CDATA[]]></column>
<column columnName="Sku"><![CDATA[]]></column>
<column columnName="ProductNumber"><![CDATA[184091]]></column>
<column columnName="ProductVariantCounter"><![CDATA[1]]></column>
<column columnName="ProductActive"><![CDATA[True]]></column>
<column columnName="MandatoryAccessories"><![CDATA[]]></column>
<column columnName="OptionalAccessories"><![CDATA[]]></column>
</item>
</table>
<table tableName="EcomGroups">
<item table="EcomGroups">
<column columnName="GroupId"><![CDATA[234563]]></column>
<column columnName="GroupLanguageId"><![CDATA[LANG1]]></column>
<column columnName="GroupName"><![CDATA[Parket]]></column>
<column columnName="GroupNumber"><![CDATA[]]></column>
<column columnName="GroupPageIDRel"><![CDATA[0]]></column>
<column columnName="GroupSmallImage"><![CDATA[]]></column>
<column columnName="GroupLargeImage"><![CDATA[]]></column>
<column columnName="GroupDescription"><![CDATA[]]></column>
<column columnName="GroupAssortment"><![CDATA[False]]></column>
<column columnName="GroupIcon"><![CDATA[]]></column>
<column columnName="GroupNavigationShowInMenu"><![CDATA[True]]></column>
<column columnName="GroupNavigationShowInSiteMap"><![CDATA[True]]></column>
<column columnName="GroupNavigationClickable"><![CDATA[True]]></column>
<column columnName="GroupInheritOrderLineFields"><![CDATA[True]]></column>
<column columnName="ProductCategoryId" isNull="true"/>
<column columnName="GroupRelatedGroups"><![CDATA[]]></column>
<column columnName="GroupRelatedProducts"><![CDATA[]]></column>
<column columnName="GroupManufacturerId"><![CDATA[]]></column>
<column columnName="GroupVatGroupId"><![CDATA[]]></column>
<column columnName="GroupProductType"><![CDATA[0]]></column>
<column columnName="GroupStockGroupId"><![CDATA[0]]></column>
<column columnName="GroupMetaTitle"><![CDATA[]]></column>
<column columnName="GroupMetaKeywords"><![CDATA[]]></column>
<column columnName="GroupMetaDescription"><![CDATA[]]></column>
<column columnName="GroupMetaUrl"><![CDATA[]]></column>
<column columnName="GroupFilterPagedQueryMode" isNull="true"/>
<column columnName="GroupMetaPrimaryPage"><![CDATA[]]></column>
<column columnName="GroupMetaCanonical"><![CDATA[]]></column>
<column columnName="GroupInheritCategoryFieldsFromParent"><![CDATA[False]]></column>
</item>
</table>
<table tableName="EcomGroupProductRelation">
<item table="EcomGroupProductRelation">
<column columnName="GroupProductRelationGroupId"><![CDATA[234563]]></column>
<column columnName="GroupProductRelationProductId"><![CDATA[184091]]></column>
<column columnName="GroupProductRelationSorting"><![CDATA[13]]></column>
<column columnName="GroupProductRelationIsPrimary"><![CDATA[True]]></column>
</item>
</table>
<table tableName="EcomGroupRelations">
<item table="EcomGroupRelations">
<column columnName="GroupRelationsGroupId"><![CDATA[236719]]></column>
<column columnName="GroupRelationsParentId"><![CDATA[234563]]></column>
<column columnName="GroupRelationsSorting"><![CDATA[0]]></column>
<column columnName="GroupRelationsIsPrimary"><![CDATA[True]]></column>
<column columnName="GroupRelationsInheritCategories"><![CDATA[False]]></column>
</item>
<item table="EcomGroupRelations">
<column columnName="GroupRelationsGroupId"><![CDATA[236721]]></column>
<column columnName="GroupRelationsParentId"><![CDATA[234563]]></column>
<column columnName="GroupRelationsSorting"><![CDATA[1]]></column>
<column columnName="GroupRelationsIsPrimary"><![CDATA[True]]></column>
<column columnName="GroupRelationsInheritCategories"><![CDATA[False]]></column>
</item>
<item table="EcomGroupRelations">
<column columnName="GroupRelationsGroupId"><![CDATA[236723]]></column>
<column columnName="GroupRelationsParentId"><![CDATA[234563]]></column>
<column columnName="GroupRelationsSorting"><![CDATA[2]]></column>
<column columnName="GroupRelationsIsPrimary"><![CDATA[True]]></column>
<column columnName="GroupRelationsInheritCategories"><![CDATA[False]]></column>
</item>
<item table="EcomGroupRelations">
<column columnName="GroupRelationsGroupId"><![CDATA[236725]]></column>
<column columnName="GroupRelationsParentId"><![CDATA[234563]]></column>
<column columnName="GroupRelationsSorting"><![CDATA[3]]></column>
<column columnName="GroupRelationsIsPrimary"><![CDATA[True]]></column>
<column columnName="GroupRelationsInheritCategories"><![CDATA[False]]></column>
</item>
</table>
<table tableName="EcomShopGroupRelation">
<item table="EcomShopGroupRelation">
<column columnName="ShopGroupShopId"><![CDATA[SHOP1]]></column>
<column columnName="ShopGroupGroupId"><![CDATA[234563]]></column>
<column columnName="ShopGroupRelationsSorting"><![CDATA[-1]]></column>
</item>
</table>
</tables>
 
Best regards,
Arnór
 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 01/06/2018 09:58:04
Reply

Hi Arnór,
that problem is not reproduced in the last Dynamicweb 9.4.12 version. Could you upgrade your solution to more latest version?
That problem should have been fixed some time later 9.3.*.
Regards, Dmitrij

 
Arnór Halldórsson
Arnór Halldórsson
Posted on 04/06/2018 15:02:20
Reply

Hi again,

I updated a dev instance of one of our webs to version 9.4.12 and it´s still happening :/

Br,
Arnór

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 06/06/2018 09:43:48
Reply
This post has been marked as an answer

HI Arnór,
that issue can be reproduced when you are missing the data in the EcomShopGroupRelation table. You need to fill that table with all groups: parent and childs.
So try to add the failing subgroups to your xml in <table tableName="EcomShopGroupRelation">
Regards, Dmitrij

Votes for this answer: 2
 
Arnór Halldórsson
Arnór Halldórsson
Posted on 06/06/2018 17:12:37
Reply

That was exactly it!!!

I added a table mapping for EcomGroups -> EcomShopGroupRelations to the data integration job and voila!!

Thank you very much Dmitrij!

 

Best regards,
Arnór

 

You must be logged in to post in the forum