Forum management
- Threads started by me
- Threads I participate in

Developer forum

product group field - type List box - options

Lars Larsen

Posted on 25/11/2020 12:08:03

I have created a product group field of type List box and want to populate it with data (don't want do that manually). So where in the database are the options for a List box stored?

Replies

Steffen Kruse Hansen

Posted on 25/11/2020 12:17:20

This post has been marked as an answer

Hi Lars,

I'm pretty sure that the options for Product Fields and Product Group Fields will both be put in the EcomFieldOption and EcomFieldOptionTranslation tables.

Best regards,

Steffen

Votes for this answer: 1

Lars Larsen

Posted on 25/11/2020 12:19:38

Hi Steffen

Your'e absolutely right. I found them there. Thanks.

Nicolai Pedersen

Posted on 25/11/2020 13:07:14

Hi Lars

In the bottom om most feature documentation, you will find information about the tables. See https://doc.dynamicweb.com/documentation-9/ecommerce/product-catalog/custom-fields#sideNavTitle1-4

Lars Larsen

Posted on 25/11/2020 13:10:09

Hi Nicolai

Yea, that's right, thanks. I have seen those tables once in awhile. But didn't remember to look there this time!

Nicolai Pedersen

Posted on 25/11/2020 13:15:57

Then it is good I am here to remind you

Adrian Ursu

Posted on 25/11/2020 13:18:10

Hi Nicolai,

If I remember correctly and things have not changed in the newer versions, the options for List box fields for ProductCategoryFields are stored in the EcomProductCategoryFieldTranslation table.

Adrian

You must be logged in to post in the forum