Prices missing in Business Central integration

[dwlhs]

Hi,

In a solution we are currently implementing based on the plug-in unit we are not able to retrieve unit prices from BC on products that have been combined in PIM. DW does include the DW native variant ids in the request, but in the response, it is only the base prices that contain the variant id. This example is the regular response from the base uom price:

<tables version="1.2.0.47_NAV25.2.28630.0">
  <table tableName="EcomProducts">
    <item table="EcomProducts">
      <column columnName="ProductId"><![CDATA[4071005]]></column>
      **<column columnName="ProductVariantId"><![CDATA[VARGRP160_4071005]]></column>**
      **<column columnName="ProductIdentifier"><![CDATA[4071005.VARGRP160_4071005.LANG1]]></column>**
      <column columnName="ProductNumber"><![CDATA[4071005]]></column>
      <column columnName="ProductPrice"><![CDATA[60]]></column>
      <column columnName="ProductPriceWithVat"><![CDATA[75]]></column>
      <column columnName="ProductStock"><![CDATA[0]]></column>
      <column columnName="ProductCurrencyCode"><![CDATA[DKK]]></column>
      <column columnName="ProductDefaultUnitId"><![CDATA[Unit_MTR]]></column>
    </item>
  </table>
</tables>

An this is from the different units:

<table tableName="EcomPrices">
    <item table="EcomPrices">
      <column columnName="PriceProductId"><![CDATA[4071005]]></column>
      <column columnName="PriceUserCustomerNumber"><![CDATA[76870888]]></column>
      <column columnName="PriceProductUnitId"><![CDATA[Unit_MTR]]></column>
      <column columnName="PriceQuantity"><![CDATA[1]]></column>
      <column columnName="PriceAmount"><![CDATA[60.00]]></column>
      <column columnName="PriceAmountWithVat"><![CDATA[75.00]]></column>
    </item>
</table>

You'll notice that the latter includes neither the variant id nor the ProductIdentifier, so it would only be able to use the productid to map the response to a product in DW, which is not sufficient.

So, please make sure that this information is included and used, so that the prices are parsed correctly, and we can display unit prices for PIM variants in Dynamicweb frontend.

Br.
Lars