What is Formulas
Formulas are expressions used to create new values based on existing data. You can use them to combine text, format numbers, add logic (like “if this, then that”), or clean up fields automatically.
In Plytix, formulas help you get your product information into the shape you need, whether that’s adding units to dimensions, generating product names, or prepping content for different channels. They don’t change your original data; they just create new fields that follow the rules you set. This makes it easier to manage product content at scale, without doing everything by hand.
Examples
| Use case | Example formula | Output example |
|---|---|---|
| Combine brand and product name | concat([Brand], ” “, [Product Title]) | Nike Air Zoom Pegasus |
| Add unit to numerical field | concat([Length], ” cm”) | 120 cm |
| Show text if stock is 0 | IF([Stock]=0, “Coming soon”, “”) | Coming soon |
| Generate a unique ID | concat([SKU], “-“, [Color]) | 1234-Red |
| Display default if empty | IFEMPTY([Material], “Not specified”) | Not specified |
| Round a number | round([Weight], 2) | 2.35 |
Good to know
Formulas don’t change your source data. They’re used to generate new values without overwriting the original fields.
They’re ideal for bulk editing. Apply the same transformation logic across thousands of SKUs in one go.
Common in PIMs. Many Product Information Management systems (including Plytix) use formulas to help teams automate and scale product content workflows.
Useful for localization. You can adjust content by region (like adding currency, units, or language tweaks) without creating duplicate entries.
No technical skills needed. Most formulas use a straightforward syntax designed for business users familiar with spreadsheets.
Know more