...
The list of Product Extension tables will vary by each installation, however there are a set of default tables (based on the Price Setting package) that are part of the standard configuration. We click on the drop-down in the Pricing Parameter Lookup to see all tables:
...
...
Once a table has been selected, then the list of search attribute columns will be displayed with the ability to connect specific values for each attribute. However, if the only key to the selected table is product sku, then no additional search attributes will be displayed.
Search Attributes
The selected product extension table may have a predefined set of attribute columns that are designated for search purposes. These search attributes will appear immediately below the selected table. In the following example, we have selected the Freight Costs table:
...
In the above example, we have associated the value of “France” with the Country attribute using the functionality within the Constants option. This will only return rows that contain this value. If the search doesn’t find any matching rows, then no value is returned.
...
...
In this scenario, we are seeking to return the value of the PerUnitCost attribute. Since this is a product extension table, then we know that the product sku will be part of the table key.
Live Preview
The Live Preview will contain both the set of rows from the product extension table and the results data lookup based on your search criteria. In the following example, we are using Freight Costs extension table and have defined a specific value for the Country attribute (France). Therefore, out Live Preview panel will appear as:
...
infoNOTE:
The Freight Costs table was created with a primary key comprised of the product sku and the country name. Only with both of these attributes defined can we return a value.
We can utilize the product sku drop-down list to generate different PerUnitCost values:
...
By selecting one of the products from the list, we will then generate our PerUnitCost result value:
...
...
It is only through the pairing of these two keys of product sku and Country that a result value is returned in the Live Preview.
...
It is important to understand that the rows returned in the Source Data area ARE filtered based on any Country search criteria specified for the data lookup. It will show all rows that match the filter for the selected table.