Developer forum

Forum » Integration » Column naming for EcomProductRelated

Column naming for EcomProductRelated

E-mail notifications
Mikkel Ulstrup
Reply
Posted on 13/02/2017 16:28:49

Hi,

This is DW 8.9.1.9.

 

When importing related products, we have the following columnnames in the database:

  • ProductRelatedProductId
  • ProductRelatedGroupId
  • ProductRelatedProductRelId
  • ProductRelatedSortOrder

 

The import fails, with our XML like this:

<item table="EcomProductsRelated">

      <column columnName="ProductRelatedProductId"><![CDATA[PROD1]]></column>

      <column columnName="ProductRelatedGroupId"><![CDATA[Relaterede produkter]]></column>

      <column columnName="ProductRelatedProductRelId"><![CDATA[PROD2]]></column>

      <column columnName="ProductRelatedSortOrder"><![CDATA[0]]></column>

    </item>

 

Could it be a hardcodet "ID" in the sourcecode? - Previous versions of DW had an uppercase "ID" in the database for the mentioned columns. :)

 

 

Kind regards

Mikkel Ulstrup


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 13/02/2017 21:51:10
Reply

Hi Mikkel,
thanks for finding, yes indeed this is a bug. We have registered it in TFS# 30619.
Best regards, Dmitrij
 

 
Kristian Kirkholt Dynamicweb Employee
Kristian Kirkholt
Posted on 20/09/2017 16:33:43
Reply

Hi Mikkel

The problem TFS#30619 "Fix casing problem for the EcomProductRelated columns in EcomProvider" has now been fixed in 9.3+ versions

You are able to find this build in the download section:

http://doc.dynamicweb.com/releases-and-downloads/releases

Please contact Dynamicweb Support if you need any additional help regarding this.

Kind Regards
Dynamicweb Support
Kristian Kirkholt

 

You must be logged in to post in the forum