When performing our data lookups, one of the categories that we will be accessing are our Product Extension tables. These tables can contain additional variables that are associated with our products and use the product sku as part of their key. Through the Data Lookup panel, we are able to create customized data queries that can return specific values from these tables, then these returned values can be used in our pricing strategies.

Here is an example of a Product Extension data lookup:

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:

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:

After selecting the Freight Costs table, we can see that there is an additional search attributes that can be defined (Country). If we know the values, then we can create a lookup for specific entry:

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.

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:

NOTE: 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: