AI Liquid for Step 2: Matching Column

AI prompts can help customise liquid mapping. You can change the liquid mapping via the AI prompt, which is currently in Step 2: Matching Column's Smart Setting. We will show an example of a prompt below:

Title field

1. Combine source data

Prompt: Combine source data column “brand” and column “title” with a dash
Output: {{ data[“brand”] }} - {{ data[“title”] }}

2. Uppercase the first character

Prompt: Uppercase the 1st character of the source data column “title”
Output: {% assign t = data[“title”] | default: “” %},{{ t | slice: 0,1 | upcase }}{{ t | slice: 1 }}

3. Replace the word

Prompt: Replace the word “failure” to “success” in source data column “title”
Output: {{ data[“title”] | replace: “failure, “success” }}

4. Remove all html tag

Prompt: Remove all html tag in source data column “title”
Output: {{ data[“title”] | strip_html }}

5. Replace words starting with a specific character with another word

Prompt: Find word start with “fa”, then replace it with “success” in source data column “title”
Output:
{% assign transformed_title = “” %},{% for w in data.title | split: ” ” %}, {% assign first_two = w | downcase | slice: 0,2 %}, {% if first_two == “fa” %}, {% assign transformed_title = transformed_title | append: “success” %}, {% else %}, {% assign transformed_title = transformed_title | append: w %}, {% endif %}, {% unless forloop.last %}, {% assign transformed_title = transformed_title | append: ” ” %}, {% endunless %},{% endfor %},{{ transformed_title }}

6. Remove html tag

Prompt: Remove html tag in source data column “title”
Output: {{ data.title | strip_html }}

7. Source data field empty, use default value

Prompt: use source data column “title”, if empty default to “No title”
Output: {{ data.title | default: “No title” }}

8. Source data field empty, use another column

Prompt: use column “title”, if blank, then use column “title2"
Output: {% if data.title | strip %}{{ data.title }}{% else %}{{ data[“title2”] }}{% endif %}

9. If condition when its 1, then use another column

Prompt: if column “type” is 1, use column “title”, else use column “sub_title”
Output: {% assign type_num = data[“type”] | plus: 0 %}{% if type_num == 1 %}{{ data.title }}{% else %}{{ data[“sub_title”] }}{% endif %}

Quantity Field

1. Use a column value to update quantity

Prompt: If column "a" value is "HIGH", return 10, else return column "qty"
Output: {% if data["a"] == "HIGH" %}10{% else %}{{ data["qty"] }}{% endif %}

2. Compare a column value

Prompt: If column "qty" value is less than 5, return 0, else return column "qty"
Output: {% if data["qty"] < 5 %}0{% else %}{{ data["qty"] }}{% endif %}

3. Perform arithmetic using two columns

Prompt: If column "qty" value is less than 300, return column "qty" minus column "b", else return column "qty"
Output: {% if data["qty"] < 300 %}{{ data["qty"] | minus: data["b"] }}{% else %}{{ data["qty"] }}{% endif %}

4. Multiply by another column

Prompt: If column "qty" value is less than 0, return column "qty" multiplied by column "a" (as a positive number), else return column "qty"
Output: {% if data["qty"] < 0 %}{{ data["qty"] | times: data["a"] | abs }}{% else %}{{ data["qty"] }}{% endif %}

5. Use a comparison with "less than or equal to"

Prompt: If column "qty" value is less than or equal to 30, return 5, else return column "qty"
Output: {% if data["qty"] <= 30 %}5{% else %}{{data["qty"]}}{% endif %}

6. Use a "greater than" comparison

Prompt: If column "qty" value is greater than 10, return 15, else return column "qty"
Output: {% if data["qty"] > 10 %}15{% else %}{{ data["qty"] }}{% endif %}

7. Use a "greater than or equal to" comparison

Prompt: If column "qty" value is greater than or equal to 20, return 50, else return column "qty"
Output: {% if data["qty"] >= 20 %}50{% else %}{{ data["qty"] }}{% endif %}

8. Check whether a value starts with specific text

Prompt: If column "qty" value starts with "Incoming", return 0, else return column "qty"
Output: {% assign qty_start = data["qty"] | slice: 0, 8 %}{% if qty_start == "Incoming" %}0{% else %}{{ data["qty"] }}{% endif %}

9. Check whether a value ends with specific text

Prompt: If column "qty" value ends with "delivered", return 0, else return column "qty"
Output: {% assign qty_len = data["qty"] | size %}{% assign start_pos = qty_len | minus: 9 %}{% assign qty_end = data["qty"] | slice: start_pos, 9 %}{% if qty_end == "delivered" %}0{% else %}{{ data["qty"] }}{% endif %}

10. Check whether a value is within a range

Prompt: If column "qty" value is between 20 and 50, return 20, else return column "qty"
Output: {% if data["qty"] >= 20 and data["qty"] <= 50 %}20{% else %}{{ data["qty"] }}{% endif %}

11. Combine multiple conditions with AND

Prompt: If column "a" value equals "disponible" and column "qty" is less than or equal to 0, return 1, else return column "qty"
Output: {% if data["a"] == "disponible" and data["qty"] <= 0 %}1{% else %}{{ data["qty"] }}{% endif %}

12. Return a constant value

Prompt: For all products, return 15 regardless of column "qty" value
Output: {{ "15" }}

13. Divide one column by another

Prompt: For all products, return column "qty" divided by column "a"
Output: {{ data["qty"] | divided_by: data["a"] }}

Updated on: 07/07/2026