Computed Attributes with Formulas
Create endless possibilities with formulas
- Generate data that is computed using other attributes. This data is calculated dynamically and is always up-to-date with the other attributes.
- Examples of computed attributes can include selling prices or metric conversions.
- This saves you the effort of updating multiple stages of information.
When creating a new attribute, you can toggle whether it will be a computed attribute or not. This has plenty of amazing uses. You can create formulas which are generic for all families, or specific to certain families. For example, a sales price based on cost price may have different percentage increases based on the type of product.
You can concatenate text which allows you to dynamically create descriptions of other attributes like Length, Width and Height. When you need to export into a certain format, you can also add carriage returns and special keywords such as "Feature" or "Length". The formulas will act on an individual language level, so for the French channel, they will concatenate the French text. You can also create a formula for label/value pairs, which means label and value are both dynamic.
For example, this:
Will become this:
You can also add mathematical operations. These values will change dynamically as the data changes, so you don't have to manually compute them each time. For example, the sales price might be calculated like this:
Computed attributes can also retrieve and display the URLs for images or files associated with each product.
For example, a computed text attribute with the following formula
[Image1] & CHAR(10) & [Image2] & CHAR(10) & Image3]
would return the URLs for the three images on three separate lines. This is useful if certain exports require image URLs in this format.
You can find a guide to all our functions here.
More functions are going to be added to the formulas soon, so keep an eye out!