Developer forum

Hi Kim,

I assume you are refering to the "GroupProductRelationSorting" column in the database, on the EcomGroupProductRelation table.

In order to add data to this column, you need to populate the columns "Groups" and "GroupSorting" on the EcomProduct tabel

so, for one product, if the "Groups" column contains "Group1,Group2,Group3" and the "GroupSorting" contains "1,3,2" then the sorting of groups for this product will be: First product in Group1, third product in group2, second product in group 3.

I hope this makes sense :-)

If you need better control of the sorting and import data than this, I recommend using the Dynamicweb provider: While it does require you to handle the relations tables manually, it gives you much more fine grained control over your import.

If this doesn't answer your question, or if I misunderstood it, please let me know.

Regards, Jonas

Hi Jonas, I found a solution and actually it was as you suggest, making an additional data integration to the group tabel with the Dynamicweb provider. The only purpose of this is to keep track of the sorting, and I dont have to involve the "Perfion" developer in the other end :)

Glad to hear you solved the problem :-)

/Jonas