Hi there,
I have the XML as show below that contains product data, a group sorting and a comma separated list of group IDs. It all works fine, except for the group sorting. No matter what's in GroupSorting, it always ends up as 0 in the database. Is this a limitation when using multiple groups or is this a bug?
Thanks,
Imar
<table tableName="EcomProducts">
<item table="EcomProducts">
<column columnName="ProductID"><![CDATA[170032]]></column>
<column columnName="ProductType"><![CDATA[0]]></column>
<column columnName="ProductPriceType"><![CDATA[0]]></column>
<column columnName="ProductLanguageID"><![CDATA[LANG1]]></column>
<column columnName="ProductNumber"><![CDATA[170032]]></column>
<column columnName="ProductName"><![CDATA[BOXX Premium Support 1 Year (Years 2 and 3 Standard) - US and Canada Only]]></column>
<column columnName="HasPdfInCart"><![CDATA[0]]></column>
<column columnName="GroupSorting"><![CDATA[2]]></column>
<column columnName="PrimaryGroup"><![CDATA[GROUP92]]></column>
<column columnName="Active"><![CDATA[true]]></column>
<column columnName="ProductStock"><![CDATA[10]]></column>
<column columnName="ProductPrice"><![CDATA[0]]></column>
<column columnName="ProductLongDescription"><![CDATA[]]></column>
<column columnName="ProductImageLarge"><![CDATA[]]></column>
<column columnName="BasicConfigurationSpecs"><![CDATA[]]></column>
<column columnName="LeadTimeInDays"><![CDATA[6]]></column>
<column columnName="ProductIsImported"><![CDATA[true]]></column>
<column columnName="AlternateProductLink"><![CDATA[]]></column>
<column columnName="Groups"><![CDATA[GROUP101,GROUP92]]></column>
</item>
<item table="EcomProducts">
<column columnName="ProductID"><![CDATA[170060]]></column>
<column columnName="ProductType"><![CDATA[0]]></column>
<column columnName="ProductPriceType"><![CDATA[0]]></column>
<column columnName="ProductLanguageID"><![CDATA[LANG1]]></column>
<column columnName="ProductNumber"><![CDATA[170060]]></column>
<column columnName="ProductName"><![CDATA[3 Year Standard Warranty]]></column>
<column columnName="HasPdfInCart"><![CDATA[0]]></column>
<column columnName="GroupSorting"><![CDATA[1]]></column>
<column columnName="PrimaryGroup"><![CDATA[GROUP92]]></column>
<column columnName="Active"><![CDATA[true]]></column>
<column columnName="ProductStock"><![CDATA[10]]></column>
<column columnName="ProductPrice"><![CDATA[0]]></column>
<column columnName="ProductLongDescription"><![CDATA[]]></column>
<column columnName="ProductImageLarge"><![CDATA[]]></column>
<column columnName="BasicConfigurationSpecs"><![CDATA[]]></column>
<column columnName="LeadTimeInDays"><![CDATA[1]]></column>
<column columnName="ProductIsImported"><![CDATA[true]]></column>
<column columnName="AlternateProductLink"><![CDATA[]]></column>
<column columnName="Groups"><![CDATA[GROUP101,GROUP92]]></column>
</item>
.....
