Custom columns on productfields and product category field

[barendmosch]

Hi there

Occasionally, custom information is required to be saved on the product fields, think about: notes, custom descriptions, etc. In our case we would like to save an external field name that corresponds with the product field name, a mapping if you like.

Is it possible to add custom columns in de EcomProductField table?

• A custom defined label and input field in the general tab or a new custom tab
• So we can save custom information on specific fields.

Is this something to consider?

The case in more detail:

The client has an export to EZ-base, here we export PIM data to a CSV/Excel file with logic behind it. Since EZ-base has different fieldnames than the ones defined in Dynamicweb, we require a mapping of some sorts. If its possible to define the 'EZ-base' field name on the productfield in Dynamicweb as a custom field, that would solve our challenge.

Any alternatives for this specific situation:

• Using the TemplateTag to define the mapping field name, but the TemplateTag replaces spaces with underscores
• Using an XML file to define the mapping. (DW name -> EZ-base name)

[SoJensen]

Hi Barend,

You add columns to table "EcomProductField", when create new field in Product attribute area "Global custom fields".
These Fields manage and store values in same way as "Standard fields", like "Name"

If the "EZ-base name" are based on concatenation of multiple DW fields, you could also look at Customize filed-type, based on multiple expression of fields

Where to show or manage values for these fields, can be specified in our "Screen layout"

Let me know, if that helps you, or we need a chat

/Søren

[barendmosch]

Hi,

Cheers for your reaction.

I'm looking to store additional data on the product field definition. Such as an additional name or system-name. I figure it might be a challenge to restructure the design of the productfield class, but is there a way to make it configurable?

Like:
Adding a new column to the design:

So it will be visible on the product field definition:

Thanks!