Developer forum

Forum » Integration » AX integration - imported group doesn't show in shop

AX integration - imported group doesn't show in shop

E-mail notifications
Rene Poulsen
Reply
Posted on 21/11/2014 10:28:11

Hi,

We have a solution with AX integration and we experience some problems with the group (the customer only have one group for all products) not showing in the shop.

When I click into one of the products and click "related groups" the group is shown - if I then click the group from there and go see the location of the group, it is correctly set to "Produkter" shop. You can see this video: http://shrpa.dk/Files/Files/tmp/dw-integration-ecomgroup.swf

The XML response for the groups is:

<table tableName="EcomShopGroupRelation">
    <item table="EcomShopGroupRelation">
      <column columnName="ShopGroupGroupID"><![CDATA[90]]></column>
      <column columnName="ShopGroupShopID"><![CDATA[SHOP5]]></column>
    </item>
  </table>
  <table tableName="EcomGroups">
    <item table="EcomGroups">
      <column columnName="GroupID"><![CDATA[90]]></column>
      <column columnName="GroupLanguageID"><![CDATA[DA]]></column>
      <column columnName="GroupName"><![CDATA[Forbrugsvarer - Salg & Marketing]]></column>
    </item>
    <item table="EcomGroups">
      <column columnName="GroupID"><![CDATA[90]]></column>
      <column columnName="GroupLanguageID"><![CDATA[DE]]></column>
      <column columnName="GroupName"><![CDATA[Forbrugsvarer - Salg & Marketing]]></column>
    </item>
    <item table="EcomGroups">
      <column columnName="GroupID"><![CDATA[90]]></column>
      <column columnName="GroupLanguageID"><![CDATA[EN-GB]]></column>
      <column columnName="GroupName"><![CDATA[Forbrugsvarer - Salg & Marketing]]></column>
    </item>
    <item table="EcomGroups">
      <column columnName="GroupID"><![CDATA[90]]></column>
      <column columnName="GroupLanguageID"><![CDATA[FR]]></column>
      <column columnName="GroupName"><![CDATA[Forbrugsvarer - Salg & Marketing]]></column>
    </item>
    <item table="EcomGroups">
      <column columnName="GroupID"><![CDATA[90]]></column>
      <column columnName="GroupLanguageID"><![CDATA[RU]]></column>
      <column columnName="GroupName"><![CDATA[Forbrugsvarer - Salg & Marketing]]></column>
    </item>
  </table>

 

To me this looks like it should, but I'm not an expert in this area so maybe something is missing - that I'm missing :-)

If I go to the group in the way shown in the video and I save it - it shows up like it's supposed to, but the customer is going to have more groups in the future, so it's not a useful solution for them to go the groups in this way and save them, to make them show in the shop.

I've been looking in the database too and averything seems right.

Can anyone point me in the right direction here?


Replies

 
Jonas Krarup Dam
Posted on 21/11/2014 12:29:59
Reply
This post has been marked as an answer

Hi Rene,

I believe that the problem is that the group doesn't exist in the default language.

Assuming I am right, you can solve this either by changing the default language to one of the ones that are imported, or by manually translating the group to the current default language.

if you expect there to ever be more groups, I recommend changing the default language, as that would mean that any future groups show up correctly :-)

 

Regards, Jonas

Votes for this answer: 1
 
Rene Poulsen
Posted on 21/11/2014 12:54:50
Reply

Hi Jonas,

You are right. I've changed the default language and it works. The problem was that there's a default danish language created in DW - it has "lang1" (or something like that) as ID. The one from AX has "da" as ID, so i actually had two instances of danish. I'm gonna delete the one DW is born with and keep the one from the AX.

Thank you very much for the help - it's much appreciated :-)

 
Jonas Krarup Dam
Posted on 21/11/2014 14:35:58
Reply

I'm glad I could help :-)

 

You must be logged in to post in the forum