Developer forum

Hi Hans

Unfortunately not. In 9.5 you will see some improvements to ecommerce fields, but not this one.

Items on products is not arround the corner, and probably never will be. The reason is because of Ecommerce products have triple keys (ProductID, Languages and Variants) and has rules related to field value inheritance and stuff like that - none of that is compatible with Items.

Another concern is that we want to keep ecommerce data very structured - with items and item list we would start to see data structures that would make it hard to seperate product data from all other kinds of data.

If you have ideas for improvements to product fields, feel free to share them!

BR Nicolai

Ok, but some sort of posibilty of adding unlimted listvalues (maybe even with multiple datacolumns) would be a really nice feature.

In our specific case, we have at shop that sells music (downloads and actual fysical CD´s, and yes - peaople stil buy tangible music media), and we want it to be possible to add involved musicians (name and what instrument they play) - and then on the product view itself, we want it to be possible to click on an involved musician, and see an overview over all musicprojects this musician is involved in. To display this, we can ofcourse use the marvelous Index - but the challange is how we best add/attach musicians to a product. As it is now, I´m thinking a textarea/long text field is the best solution, but it is not so easy to decide what should be a link triggerin the index from a field of values of something like this:

Firstname1 Lastname1, Violin 
Firstname2 Middlename2 Lastname2, Drums, vocals and percussion
Firstname3 Lastname3, Bass and piano
etc. etc.

Any suggestions on how I can solve this? If it was possible to create a multicolumn list customfield on products, this would be possible. It would be even more nice, if a listitem would suggest adding the values of an already existing row of the same value, sort of like Microsoft Excel does, or like Dynamicweb does when you type inn foldernames on items in Settings. This to avoid duplicate instances of same musician, due to misspelling

Any suggestions?

/Hans

My best bet is to create a Group (maybe with sub groups) where you have musicians. Create a product category for the musicians with the fields they require.

Then use related products feature to link CDs to a musician, and add all cds to that musician to a subfolder if he has one. Or just have one group for each musician.

BR Nicolai

Hi Nicolai,

I've been struggling with similar issues as Hans and I do understand your concerns about the ecom data being very structured. However I thought of a compromise. We have the "List Box" controls that basically save a comma splited value.

• What if he had some field types that would still save comma splitted values, but we could use a SQL statement to populate the list box?
  That would allow us to render dynamic options
  For translation, we could update the query if needed

In a few projects we have some Items (as pages, paragraphs, named item lists) and have a notification on ItemSave to repopulate our list boxes, in order to keep the Ecommerce in sync with the Items. If we could use a SQL satement would be more flexible.

Best Regards,

Nuno Aguiar

Roger that - data driven list fields is something else than items on products - and that is within reach.

Will have a look at it.

BR Nicolai