The Lookup Table extension is used to translate values based on a lookup table. For example, the Lookup Table Extension allows you to match a readable value, such as a product's name, to that product's ID number.
See the full list of available extensions.
In this article:
If your system contains a list of product IDs, it may be difficult to determine what product references which product ID. The Lookup Table extension allows you to match a readable value, such as a product name, to that product ID’s number.
In this case, the Lookup Value would be the product ID, and the destination would e the product name. When the extension runs, it looks for the product’s ID variable and populate the product name variable with the corresponding product’s name.
Before you begin, familiarize yourself with how extensions work.
Once the extension is added, the following configuration options are available:
\", use two backslashes "
\\". The ignore case "
i" flag is applied automatically.
The following table explains how the destination changes in relation to the variables and the default value .
|Default Output is populated||Default Output is blank|
|Lookup and Destination are unique||Destination value is replaced by the default value||Destination value is left blank|
|Lookup and Destination are identical||Both lookup and destination values are replaced by the default value||Lookup and destination values are NOT replaced.|
To enter large numbers of lookups, use the "Import from CSV" feature. Enter the CSV (comma-separated value) formatted text in the order of Lookup Value, Output value and corresponding Notes. The Lookup Value is entered into the Lookup Match field and the corresponding output value is entered into the Destination field.
One example of a lookup-output value pair is product IDs linked to product names. A product might have an ID of "123" and a name of "LED TV". Another product might have and ID of "789" and a name of "Plasma TV". In both these situations, the value of the lookup-output pair is the product's ID, while the value of the lookup-output pair is the English-readable name of the product.
To add lookup-output values in bulk:
This feature exports the Lookup Values into a CSV file. Enter the values for Lookup Match, Output, and Notes in their respective fields and click the Export to CSV button. At least one instance of lookup match, output, and note value is required to perform a successful export. If all the three lookup fields are blank, data is not exported.
This feature is compatible with most modern browsers, with the exception of IE. If you are using Firefox or Chrome, the values are directly exported into a
lookup.csv file. In a Safari browser, the CSV-formatted values are exported into a new browser tab instead of a .csv file.
You have a list of product IDs in your system. However, you find that looking at product ID numbers gives you a headache. When you look at the ID number, you don't immediately know if it corresponds to a Blu-ray player or a bag of kitty litter. The Lookup Table Extension allows you to match a readable value, such as a product's name, to that product's ID number.
product_idvalue doesn't contain any information.
product_idvariable only contains one ID per product, so select string for Variable Type.
Add more Lookups, matching the
product_id "456" to "Sony Blu-ray Player" and "789" to "Panasonic Plasma TV". Add relevant notes for the lookups.
Now, when the Lookup Table extension runs, it looks for the product IDs in the
product_id variable and populate the
product_name variable with the corresponding product name.