Developer forum

Forum » Ecommerce - Standard features » What is EcomProductCategoryFieldGroupValue

What is EcomProductCategoryFieldGroupValue

E-mail notifications
Scott Forsyth Dynamicweb Employee
Scott Forsyth
Reply
Posted on 13/12/2021 04:30:10

Hello,

What is the EcomProductCategoryFieldGroupValue table used for? That's a table I usually don't pay attention to, but we're running into an issue with it on one of our projects. Does that have to do with the Field Display Groups, or is it something else? I know the EcomProductCategory* family of tables, except for that table.

The issue that we're running into is that we're seeing duplicate entries in that table, one with FieldValueFieldId set to the spelling that we set (e.g. Length) and the other record is all uppercase (e.g. LENGTH). This suggests that it's auto-populated somehow.

My question is just what that table is used for, to help me understand it better.

Thanks,

Scott


Replies

 
Adrian Ursu Dynamicweb Employee
Adrian Ursu
Posted on 13/12/2021 10:43:07
Reply
This post has been marked as an answer

Hi Scott,

I believe that it stores default values for ProductCategoryFields.

These values would be inherited (or used as default) by products assigned to the Group.

At least that's how I interpret it.

Adrian

Votes for this answer: 1
 
Scott Forsyth Dynamicweb Employee
Scott Forsyth
Posted on 13/12/2021 16:21:53
Reply

Thanks Adrian. That helped. Now I realize that they are for the defaults for the product category field at the group level. And, saving and closing of the group settings will populate that table with a value for each category field (just with empty values if they haven't been set). 

We figured out our issue too. It had to do with different IDs in the past that hadn't been fully cleared from the database. With 2 entries with 2 spellings (1 uppercase and 1 pascal calse), it was getting confused.

 

You must be logged in to post in the forum