Formula Fields (IA)

Create custom fields directly in your catalog - no need to edit your source file. Use formulas to calculate values, combine fields, or create new attributes, with help from AI.

What you can do ?

You can

• Compute values (e.g. margin, discount, VAT…),

• Define fields (e.g. brand + product name)

• Create conditions (e.g. flag out-of-stock items)

• Normalize data (e.g. round prices, format text)

How to use it Fields ?

1

Go to Catalog > Fields

• Click ➕ Add Formula Field

• Choose a name and a field type (number, string, boolean, date)

2

Write your formula

You can either:

• Type it manually using field names like {{price}}, {{brand}}, etc.

• Or click ✨ Ask AI and describe what you want in plain English or French.

Examples

({{price}} - {{cost_price}}) / {{price}}      → margin
CONCAT({{brand}}, " ", {{name}})             → combined title
IF({{stock}} == 0, "OUT", "IN")              → stock flag

3

Check your result

• A preview shows up to 10 sample rows

• Errors appear in red (wrong field, missing parenthesis, etc.)

4

Save

Once validated, your new field is added to your catalog and updated automatically during each sync

How to use AI Fields Assistant ?

Describe what you want, for example :

Prompt: Create a margin percentage between price and cost price.
AI: ({{price}} - {{cost_price}}) / {{price}}

Another example:

Prompt: Why is my formula not in % unit ?

The AI will explain and fix it.

Best practices

• Keep field names consistent (price, cost_price, etc.)

• Always use preview before saving

• Use ROUND() for numeric fields

• Use quotes for text values (“OUT”, “IN”)

• Avoid spaces or special characters in field names

Notes & limits

• Works only with fields in your current catalog

• No cross-table formulas yet

• Up to 200 characters per formula

• Available for Editor and Admin roles only

Example use cases

Goal	Formula	Result
Calculate margin	({{price}} - {{cost_price}}) / {{price}}	0.25
Label stock status	IF({{stock}} == 0, "OUT", "IN")	“IN”
Build SEO title	CONCAT({{brand}}, " ", {{name}})	“Nike Air Max”
Round price	ROUND({{price}}, 2)	49.99