...
This refers to the name of the Product Extension table that will be used for our data lookup. Only those tables that have at least one defined column will be included in this list.
This will include one or more attributes columns from the selected product extension table that can be used to define our search criteria.
This will be the selected attribute column from the product extension table whose value we are attempting to retrieve.
Table Name
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:
...
| Info |
|---|
NOTE: 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:
...
| Info |
|---|
NOTE: 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:
...