Skip to main content

AI - Formula generator

Learn how to create your own data fields and filters using “artificial intelligence”

With the “AI formula generator”, you can generate a formula from natural language - without any programming knowledge. Simply describe the functions that your data field should fulfill in the form of a prompt and our AI will generate the appropriate formula for you.

You are here: Start -> Custom data fields or product filters -> AI formula generator

If you have not yet created your own data fields, the list will be empty.

If you have not yet created any filters, the list is empty.

Create data field with AI

  1. Click on “Create new datafield”.

  2. Give the data field a meaningful name. This should indicate the purpose so that the data field can be found and assigned more easily.

  3. Click on “Save”.

    The following window opens.

  4. Click on the “Create new parameter” field to define a data field that you would like to include in your prompt. Any number of source data fields can be defined.

  5. In these fields, you have to define the name and data type for the reference data field:

    • Reference data field: Enter a data field either from a feed or a data field you have already created as a reference.

    • Name: The name is an alias that you can use in your description (prompt) if you are referring to the reference data field.

    • Data type: You use the data type to determine whether the parameter data in the formula is treated as text or a number.

  6. Click on “Create”.

  7. In the “Prompt” field, enter a description (prompt) of what you expect from your data field or its formula, as precise as possible. Examples can be found below.

  8. Click on “Generate formula and test”. After a short moment, the result for a randomly selected article will be displayed below the prompt.

  9. Check the function of the data field by clicking on “Full feed test”.

  10. If everything is correct, save your entries via “Save changes”

Further information on creating and editing own datafields can be found here.

Create a filter with AI

  1. Click on “Add new product filter”.

  2. Name the filter. This should indicate the purpose so that the filter can be found more easily.

  3. Select from:

    • Whitelist: All items that meet these requirements will be included (imported or exported, depending on the purpose of the filter).

    • Blacklist: All items that fulfill these requirements will be excluded (not imported or exported, depending on the purpose of the filter).

  4. Click on “Save”.

    The following window opens.

  5. Click on the “Create new parameter” field to define a data field that you would like to include in your prompt. Any number of source data fields can be defined.

  6. In these fields, you have to define the name and data type for the reference data field:

    • Reference data field: Enter a data field either from a feed or a data field you have already created as a reference.

    • Name: The name is an alias that you can use in your description (prompt) if you are referring to the reference data field.

    • Data type: You use the data type to determine whether the parameter data in the formula is treated as text or a number.

  7. Click on “Create”.

  8. In the “Prompt” field, enter a description (prompt) of what you expect from your filter or its formula, as precise as possible. Examples can be found below.

  9. Click on “Generate formula and test”. After a short moment, the result for a randomly selected article will be displayed below the prompt.

  10. Check the function of the data field by clicking on “Full feed test”.

  11. If everything is correct, save your entries via “Save changes”

Further information on creating and editing filters can be found here.

Edit formula

You can regenerate the formula at any time using a new, customized prompt and clicking on “Generate formula and test”. This overwrites the previous formula. To correct it, you can refer to the last formula created in the data field in the new prompt.

It is also possible to adjust the formula manually.

  1. Click on the “Formula generator”. This will switch you to manual editing mode, where you can view and check the formula created by the AI.

    You can also edit the formula, shorten it or add further functions. Simply edit the formula.

  2. Click "Save changes".

  3. If you want to return to “AI mode” after editing the formula, the following message window appears.

  4. Choose from

    • Keep old: Your changes to the formula will not be saved. You will be taken to the formula generator.

    • Renew: Your changes to the formula will be saved. The formula generator translates your changes into natural language.

Prompt examples

Example 1

Reference datafields: Title, description, price

Prompt: “String together title, description and price, separated by commas. Shorten the string to 50 characters if necessary.”

Example 2

Reference datafield: Price

Prompt: “Reduce my prices by 10% every Saturday and write ‘Saturday offer on’ with the respective date behind it.”

Example 3

Reference datafield: Name, color, size, price

Prompt: “Build a product name from name, color and size. Then add a currency symbol and round the price to two decimal places.”

Example 4

Reference datafield: Category tree

Prompt: “Replace | with > from my category tree”

Related Articles
Did this answer your question?