Download page Populating Product Attribute values Using Numeric Expression.
Populating Product Attribute values Using Numeric Expression
Create a product with attributes. You can use these attribute values to create a numeric expressions.
Example
SunHome is a product with the following attributes:
Refrigerator Run Time
Microwave Run Time
Television Run Time
House Lights
Each attribute has the datatype defined as number. You must also create an attribute group named Summary of WattHoursrequired and assign it to the product SunHome. The attribute group contains the following attributes.
Total daily WattHours required
WattHours required for 3 days
Battery capacity
Each attribute has the datatype defined as number. You can derive the values for these attributes using numeric expressions.
To populate product attribute values using numeric expressions
From the Products detail page, select SunHome and click Product Console.
Scroll down to the Additional Data section, and click Attributes.
Click Summary of Watthours required Attribute Group. All the attributes listed under the attribute group are displayed.
To associate an expression to an attribute, click the text field next to the attribute in the Expression Column. An expression builder pop up is displayed.
Selecting any function displays the example syntax on the right on how you can use it.
Click Insert Field. To retrieve the fields for building the expression, click Insert Field and choose Product attributes or Line Item. Line Item allows you to get access to fields at Product and Quote objects as well.
In the Insert Field dialog, click Product Attribute and select the required attributes to derive the values for attributes of SunHome. The following expressions are built for each attribute: