Developer forum

Hi Davy,
it is not clear what is your problem. Is that the product-group relations that are created are wrong?
Or do you need the EcomGroup itself to be updated with some new data?
If it is related to the product group relations try to check if the Group with GroupId = "Group205" exists.
You can also un-check the option "Create missing groups" then new groups will not be created.
BR, Dmitrij

Hi Dmitriy,

I'm trying to overwrite existing product group relations with a single, predefined group relation. The group I'm targeting has the ID GROUP205, and it's already created in the system.

In my setup, I mapped the groups field to a constant value containing this ID, expecting that the EcomProvider would interpret this as a directive to remove all other group relations and retain only this one. However, it seems that’s not happening—the existing relations remain untouched.

Is there a way to achieve this clean overwrite without introducing a separate source file or setting up a more complex integration flow? Ideally, I’d like to keep the solution as simple and maintainable as possible.

Thanks in advance for any insights!

Hi Davy,
it is related to the Partial update feature described here. To use it you need to add the <config> section to your source xmll file like that:
<?xml version="1.0" encoding="utf-8"?>
<tables>
<config>
    <destination>
        <setting field="PartialUpdate">true</setting>
    </destination>
</config>
  <table tableName="EcomProducts">
    <item table="EcomProducts">
      <column columnName="ProductID"><![CDATA[PROD112]]></column>
      <column columnName="ProductLanguageID"><![CDATA[DAN]]></column>
      <column columnName="ProductVariantID"><![CDATA[]]></column>
      <column columnName="ProductNumber"><![CDATA[]]></column>
      <column columnName="ProductName"><![CDATA[s2g1p1]]></column>
      <column columnName="Groups"><![CDATA["GROUP64"]]></column>
    </item>   
  </table>
</tables>
BR, Dmitrij