Developer forum

Forum » Integration » EcomProvider Use existing Product Id found by Number in Variant Products

EcomProvider Use existing Product Id found by Number in Variant Products

Andrejs Zavorotnijs
Reply

Hello

 

After upgrade from DW9 to DW10 "Use existing Product Id found by Number in Variant Products" doesn't work, instead creating new products


added some character in names for testing

After import New product created but variants not updated

In DW9 same configuration work without issues

before import

after import

Imported data

<item table="EcomProducts">
      <column columnName="ProductId"><![CDATA[996]]></column>
      <column columnName="ProductLanguageId"><![CDATA[LANG1]]></column>
      <column columnName="ProductVariantId"><![CDATA[]]></column>
      <column columnName="ProductDefaultShopId"><![CDATA[SHOP10]]></column>
      <column columnName="ProductDefaultUnitId"><![CDATA[]]></column>
      <column columnName="ProductNumber"><![CDATA[996]]></column>
      <column columnName="ProductName"><![CDATA[product996]]></column>
      <column columnName="ProductEAN"><![CDATA[99]]></column>
      <column columnName="ProductCost"><![CDATA[0]]></column>
      <column columnName="ProductPrice"><![CDATA[31.92]]></column>
      <column columnName="ProductStock"><![CDATA[0]]></column>
      <column columnName="ProductWeight"><![CDATA[0]]></column>
      <column columnName="ProductVolume"><![CDATA[0]]></column>
      <column columnName="ProductActive"><![CDATA[True]]></column>
      <column columnName="ProductMetaTitle"><![CDATA[product996]]></column>
      <column columnName="ProductPurchaseMinimumQuantity"><![CDATA[0]]></column>
      <column columnName="ProductPurchaseQuantityStep"><![CDATA[0]]></column>
      <column columnName="ProductManufacturerId"><![CDATA[]]></column>
      <column columnName="Groups"><![CDATA[CheckGroup]]></column>
    </item>
    <item table="EcomProducts">
      <column columnName="ProductId"><![CDATA[997]]></column>
      <column columnName="ProductLanguageId"><![CDATA[LANG1]]></column>
      <column columnName="ProductVariantId"><![CDATA[]]></column>
      <column columnName="ProductDefaultShopId"><![CDATA[SHOP10]]></column>
      <column columnName="ProductDefaultUnitId"><![CDATA[]]></column>
      <column columnName="ProductNumber"><![CDATA[997]]></column>
      <column columnName="ProductName"><![CDATA[product997]]></column>
      <column columnName="ProductEAN"><![CDATA[99]]></column>
      <column columnName="ProductCost"><![CDATA[0]]></column>
      <column columnName="ProductPrice"><![CDATA[30.93]]></column>
      <column columnName="ProductStock"><![CDATA[0]]></column>
      <column columnName="ProductWeight"><![CDATA[0]]></column>
      <column columnName="ProductVolume"><![CDATA[0]]></column>
      <column columnName="ProductActive"><![CDATA[True]]></column>
      <column columnName="ProductMetaTitle"><![CDATA[product997]]></column>
      <column columnName="ProductPurchaseMinimumQuantity"><![CDATA[0]]></column>
      <column columnName="ProductPurchaseQuantityStep"><![CDATA[0]]></column>
      <column columnName="ProductManufacturerId"><![CDATA[]]></column>
      <column columnName="Groups"><![CDATA[CheckGroup]]></column>
    </item>
    <item table="EcomProducts">
      <column columnName="ProductId"><![CDATA[998]]></column>
      <column columnName="ProductLanguageId"><![CDATA[LANG1]]></column>
      <column columnName="ProductVariantId"><![CDATA[]]></column>
      <column columnName="ProductDefaultShopId"><![CDATA[SHOP10]]></column>
      <column columnName="ProductDefaultUnitId"><![CDATA[]]></column>
      <column columnName="ProductNumber"><![CDATA[998]]></column>
      <column columnName="ProductName"><![CDATA[product998]]></column>
      <column columnName="ProductEAN"><![CDATA[99]]></column>
      <column columnName="ProductCost"><![CDATA[0]]></column>
      <column columnName="ProductPrice"><![CDATA[31.93]]></column>
      <column columnName="ProductStock"><![CDATA[0]]></column>
      <column columnName="ProductWeight"><![CDATA[0]]></column>
      <column columnName="ProductVolume"><![CDATA[0]]></column>
      <column columnName="ProductActive"><![CDATA[True]]></column>
      <column columnName="ProductMetaTitle"><![CDATA[product998]]></column>
      <column columnName="ProductPurchaseMinimumQuantity"><![CDATA[0]]></column>
      <column columnName="ProductPurchaseQuantityStep"><![CDATA[0]]></column>
      <column columnName="ProductManufacturerId"><![CDATA[]]></column>
      <column columnName="Groups"><![CDATA[CheckGroup]]></column>
    </item>
    <item table="EcomProducts">
      <column columnName="ProductId"><![CDATA[999]]></column>
      <column columnName="ProductLanguageId"><![CDATA[LANG1]]></column>
      <column columnName="ProductVariantId"><![CDATA[]]></column>
      <column columnName="ProductDefaultShopId"><![CDATA[SHOP10]]></column>
      <column columnName="ProductDefaultUnitId"><![CDATA[]]></column>
      <column columnName="ProductNumber"><![CDATA[999]]></column>
      <column columnName="ProductName"><![CDATA[product999]]></column>
      <column columnName="ProductEAN"><![CDATA[99]]></column>
      <column columnName="ProductCost"><![CDATA[0]]></column>
      <column columnName="ProductPrice"><![CDATA[30.94]]></column>
      <column columnName="ProductStock"><![CDATA[0]]></column>
      <column columnName="ProductWeight"><![CDATA[0]]></column>
      <column columnName="ProductVolume"><![CDATA[0]]></column>
      <column columnName="ProductActive"><![CDATA[True]]></column>
      <column columnName="ProductMetaTitle"><![CDATA[product999]]></column>
      <column columnName="ProductPurchaseMinimumQuantity"><![CDATA[0]]></column>
      <column columnName="ProductPurchaseQuantityStep"><![CDATA[0]]></column>
      <column columnName="ProductManufacturerId"><![CDATA[]]></column>
      <column columnName="Groups"><![CDATA[IDG-1,CheckGroup]]></column>
    </item>

Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply

Hi Andrejs,
thx for the detailed description of the problem. This is a bug and will be fixed in #27665.
BR, Dmitrij

 

You must be logged in to post in the forum