Product Fields

Product fields are fields which belong to a product – they exist to store information, e.g. a description, a price, or a stock state.

There are two types of product fields:

Standard product fields
Custom product fields

You can see a list of all product fields on a solution by navigating to Settings > Ecommerce > Product Catalog > Product fields

A small search bar above the list of product fields, allows you to quickly locate the wanted product field (Figure 1.1).

Figure 1.1 A list of product fields - standard or custom - on a solution

Standard product fields

A standard product field is a field which is present on all products, and typically represents a universal or very commonly used property such as Name, Price, Stock level, etc.

Below you will find an overview of all standard product fields. You don’t have to provide values for all standard fields – in many cases it makes for a much smoother editor experience if you configure the Fields settings to make some fields required, hidden or read only.

The first section of product fields contains the most commonly edited product data (Figure 2.1).

Figure 2.1 The first section contains the most commonly edited product fields

#	Field	Content	Notes
1	System Id	A system id is auto-assigned to each product when it is created.	A Fields setting makes the product ID editable when creating a product, but read-only after first save.
2	Active	Products can be set to active or inactive	This setting can be used to easily control which products are shown in frontend.
3	Name	The product name as you want the customer to see it.
4	EAN	The EAN number
5	Number	The product number
6	Price	The price in the default currency that you’re charging for the product	If prices depend on contextual information, prices should be managed using the Price matrix. Rounding: when saving the product from UI, the price will be rounded to two decimals. If you enter 10.6666, the saved value will be 10.67.
7	Loyalty points	The price in loyalty points that you’re charging for the product (if used on the solution)
8	Stock level	The number of units in stock.	If your stock is distributed across multiple stock locations, stock should instead be managed using the Stock matrix. Not present on product with the product types Service and Gift Card.
9	Manufacturer	Select a manufacturer for this product	See Manufacturers article for more information
10	Teaser text	A short description or teaser text for the product. This field uses a rich text editor, so you can format the content. If you’re a reseller, make sure the content is unique to search engines.
11	Description	A more in-depth description of the product. This field uses a rich text editor, so you can format the content. If you’re a reseller, make sure the content is unique to search engines.

The images fields (Figure 2.2) deal with the physical appearance of the product.

Figure 2.2 The Images & Stock fields

#	Field	Content	Notes
1	Product Images	Select 1-3 images related to the product – see note.	These fields are being deprecated – see Product Images article for details.

The Documents & Files fields allow you to associate one or more links, files, images or texts with the product (Figure 2.3).

Figure 2.3 The Documents & Files fields

#	Field	Content	Notes
1	Link	An internal or external link
2	Alternative link	An internal or external link
3	Details – Text	One or more additional texts associated with the product.
4	Images	One or more links to content or a file/image. One of the links can be marked as the Default link.	When using Dynamicweb PIM, images uploaded to the Images field or to an asset category are published to these fields. See Assets documentation for more information.

The Advanced Configuration section allows you to set a number of important (but not often edited) properties on a product (Figure 3.1).

Figure 3.1 Advanced Configuration options

#	Field	Use	Notes
1	Shop	Select a default shop	Only used for URL generation purposes
2	Default VAT group	Select a VAT group	A VAT group can also be set at the product group level
3	Product Type	Select a product type
4	Cost	How much it costs you to stock one unit of this product or variant	The cost can be what you paid the manufacturer, or the time and material you used to manufacture the unit yourself
5	Purchase minimum quantity	Specify the minimum quantity this product may be bought in	An addtocart cart command will add the minimum quantity to cart.
6	Purchase quantity step	Specify the increments this product may be purchased in	An incorderline and decorderline cart command will add/subtract this quantity from the order line.
7	Price calculation	Select a price calculation type for products of the type Parts list	Only present on products with the product type Parts list.

The Meta information fields are used to enrich the product with information which may have an effect on how your website is ranked in search results (Figure 3.2).

Figure 3.2 The Meta Information fields

#	Field	Content	Notes
1	Title	A title for search engine indexing purposes
2	Description	A description for search engine indexing purposes
3	Keywords	Keywords for search engine indexing purposes
4	Canonical	A canonical URL for search engine indexing purposes
5	URL	A (user-friendly) URL for search engine indexing purposes

The Discontinued products section (Figure 4.1) makes it possible to mark a product as discontinued and configure related behaviors.

Figure 4.1 Discontinued products

#	Field	Content	Notes
1	Discontinued	Mark product as discontinued
2	Replacement product	Select a replacement product
3	Discontinued action	None Reirect to replacement product Redirect to group	Choose what happens if the product details link is accessed. If redirect to group is selected you will be redirected to the group from where you accessed the product.

The Stock fields (Figure 5.1) concern the dimensions, and availability of the product.

Figure 5.1 Stock fields

#	Field	Content	Notes
1	Stock state	Select a group of stock states	Not present on product with the product types Service and Gift Card.
2	Units & stock	Select a default product unit	Not present on product with the product types Service and Gift Card, and Parts list.
3	Weight	The product weight	The weight unit can be changed under Settings > Ecommerce > Advanced configurations > General
4	Volume	The product volume	The volume unit can be changed under Settings > Ecommerce > Advanced configurations > General
5	Width	The product width	The width unit can be changed under Settings > Ecommerce > Advanced configurations > General
6	Height	The product height
7	Depth	The product depth
8	Never out of stock	This product can bought even if current stock is negative	Only shown for stock items
9	Expected delivery	A data where the product is back in stock	Only shown for stock items

Custom product fields

Like standard product fields, custom product fields are available on all products - they are added to a special section on the product details view (Figure 6.1).

Figure 6.1 Product fields are added to all products on a solution, and serve many purposes

To create a custom product field click New field in the toolbar to open the field properties (Figure 6.2)

Figure 6.2 The edit product field view

Fill in the values:

Specify a name and a system name for the field
Provide a template tag-value for the field - use this tag in your templates to render the field content in frontend
Select a field type
Enter a description - a helptext which is shown next to the product field when editing a product
Specify a validation pattern and a validation error message if the validation fails
If this is an administrative field which should not be shown in frontend, check the Do not render checkbox

The Fields Settings section is used to control whether the field is obligatory or not, if it is allowed to differ across variants and languages, and so on.

The Field Display Groups section is used to add the field to or remove it from field display groups.

Product Field validation

To help editors enter more consistent data when enriching products you can enable product field validation for both standard and custom fields. This is done by entering a validation pattern using regular expressions and a validation error message for the field.

Then, whenever the field is saved in PIM, the value is checked against the regular expression and – if it does not validate – the product is not saved and the error message is displayed.

Please note that this feature has not been implemented in Ecommerce.

You can set up different validation patterns for each Ecommerce language by using the language selector to switch to a localized field - please note that due to a technical issue you must save a standard field before being able to switch to non-default languages.

Database

These are the database tables related to custom product fields:

EcomProductField

Contains product field definitions from Settings -> Ecom -> Product catalog -> Product Fields.

Field name	Data type	Length
ProductFieldId	nvarchar	255
ProductFieldName	nvarchar	255
ProductFieldSystemName	nvarchar	255
ProductFieldTemplateName	nvarchar	255
ProductFieldTypeId	int	4
ProductFieldTypeName	nvarchar	255
ProductFieldLocked	bit	1
ProductFieldSort	int	4
ProductFieldListPresentationType	int	4
ProductFieldAutoId	int	4
ProductFieldDoNotRender	bit	1
ProductFieldValidationPattern	nvarchar	255
ProductFieldValidationErrorMessage	nvarchar	255
ProductFieldIsStandard	bit	1
ProductFieldIsStandart	bit	1

EcomProductFieldTranslation

Contains translations of product fields (ProductFieldTranslationFieldID) to various languages (ProductFieldTranslationLanguageID).

Field name	Data type	Length
ProductFieldTranslationID	int	4
ProductFieldTranslationFieldID	nvarchar	255
ProductFieldTranslationLanguageID	nvarchar	50
ProductFieldTranslationName	nvarchar	255
ProductFieldTranslationDescription	nvarchar	Max
ProductFieldTranslationErrorMessage	nvarchar	255

EcomFieldOption

Contains option values for product fields (EcomProductField) of type list. Linked on FieldsOptionFieldID.

Field name	Data type	Length
FieldOptionId	nvarchar	255
FieldOptionFieldId	nvarchar	255
FieldOptionName	nvarchar	255
FieldOptionValue	nvarchar	255
FieldOptionIsDefault	bit	1
FieldOptionSort	int	4
FieldOptionAutoId	int	4

EcomFieldOptionTranslation

Contains translation data for Ecom field options (EcomFieldOption). Links field options (EcomFieldOptionTranslationOptionID) to language (EcomFieldOptionTranslationLanguageID).

Field name	Data type	Length
EcomFieldOptionTranslationID	int	4
EcomFieldOptionTranslationOptionID	nvarchar	255
EcomFieldOptionTranslationLanguageID	nvarchar	50
EcomFieldOptionTranslationName	nvarchar	255