Developer forum

Forum » Integration » importProductProperties not working

importProductProperties not working

Michael Knudsen
Reply

Hello forum,

- in a DW9.13.12 solution with integration to BC (cloud) with plug-in unit version: 1.2.0.31_NAV21.0.49939.52317 are we trying to get some product properties with a request like:

<GetEcomData><tables><Products type="all" setLanguage="LANG2" importProductProperties="true"/><RelatedProducts type="all" /></tables></GetEcomData>

However, when the import job run, it create the produktcategory 'ImportedNAVItemAttributes' but no of the fields are visible even they are in database?  

Checking the following tables in Firehose and the fields fields are created:
<table tableName="EcomProductCategory">
<table tableName="EcomProductCategoryTranslation">
<table tableName="EcomProductCategoryField">
<table tableName="EcomProductCategoryFieldTranslation" />
<table tableName="EcomFieldOption" />
<table tableName="EcomFieldOptionTranslation" />
<table tableName="EcomProductCategoryFieldValue">

Br. Michael Knudsen


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply

Hi Michael,

could you check if it is a caching issue? So can you restart the website and check?
Does it have a correct language id?
BR, Dmitrij

 
Michael Knudsen
Reply

Hello Dmitriy,

- website have been restarted, but it didn't have any impact. Default language is "LANG2" so that have been double checked.

However, I have been looking closer at the XML, and for some reason is there no translation of the "EcomProductCategoryField" fields in "EcomProductCategoryFieldTranslation"?
When I compare other product category fields (created manually), are they available in the "EcomProductCategoryFieldTranslation".

  <table tableName="EcomProductCategoryField">
    <item table="EcomProductCategoryField">
      <column columnName="FieldId"><![CDATA[ImportedNAVItemAttributes_1]]></column>
      <column columnName="FieldCategoryId"><![CDATA[ImportedNAVItemAttributes]]></column>
      <column columnName="FieldTemplateTag"><![CDATA[ImportedNAVItemAttributes_1]]></column>
      <column columnName="FieldType"><![CDATA[7]]></column>
      <column columnName="FieldDefaultValue"><![CDATA[]]></column>
      <column columnName="FieldPresentationType"><![CDATA[1]]></column>
      <column columnName="FieldDoNotRender"><![CDATA[false]]></column>
      <column columnName="FieldHideEmpty"><![CDATA[false]]></column>
    </item>
  </table>
  <table tableName="EcomProductCategoryFieldTranslation" />

 

Br. Michael Knudsen

 

You must be logged in to post in the forum