Create new fields with feed management

Define new product properties based on existing information

Table of Contents

Using a "Contains Any" filter (simple)1. Manage your data source2. Define the field3. Preview and saveUsing custom SQL (advanced)1. Manage your data source2. Define the field using SQL3. Preview and save

Confect's feed management function works by processing existing product information in your feed, and returning a new field.

This is useful if you're looking to find and tag certain products based on their information, and use this to filter, or show in the design.

To create new fields, Confect supports "Contains Any" filters (searching for a specific word or phrase), and custom SQL (advanced).

Examples:

  • Tagging products that mention "waterproof" in the description
  • Tagging products that have a >20% discount
  • Diving price by 4 to show "pay later instalments"
Important ⚠️
We do not recommend using this function to override existing product fields (i.e. title, link, price), but only to define new ones.


Using a "Contains Any" filter (simple)

This type of feed management is very simple yet useful if you need to tag products based on whether the product field includes a specific word or phrase.

If you are unable to edit your existing data source and tag products, or if some information (i.e. "category") is unreliable, this can help you overcome those challenges.


1. Manage your data source

First, you have to go to the "Data sources" tab under "Settings".

Then, click the three dots next to your link, and press "Manage".

Here, click "Add field" in the top right, and select "Contains Any".


2. Define the field

Here, you will first name the new field you're creating. It is important that the name you select is not being used yet in your feed, otherwise it will be overwritten.

After that, select the field you want to scan for matches.

Lastly, click "Add case", write the word or phrase you want to look for on the left, and the tag you want to return on the right. You can add as many cases as you need.

At the bottom, you will find the "Fallback" value - this is optional; products will be tagged with this if they match none of the cases you have defined.


3. Preview and save

As the last step, click "Preview" in the top right to confirm that your new field is behaving as expected, and then click "Save".

Your new field may take a few minutes to process, after which you can use it to filter, show it in the design, or have it sent to Meta.


Using custom SQL (advanced)

Using SQL queries allows you to define new fields in many different ways, though can be more technical.

There is an AI model to turn your prompt into a Confect-compatible SQL query - which we highly recommend using.


1. Manage your data source

First, you have to go to the "Data sources" tab under "Settings".

Then, click the three dots next to your link, and press "Manage".

Here, click "Add field" in the top right, and select "Custom SQL".


2. Define the field using SQL

First, name the new field you're creating. It is important that the name you select is not being used yet in your feed, otherwise it will be overwritten.

Next, you have to add the query for the new field. For this step, we HIGHLY RECOMMEND clicking the "Use AI (beta)" button and adding a prompt.

Some commonly-used prompts include:

"Tag products that have at least a 20% discount"
"Divide the price by 4" (for pay-later instalments)
"Remove brand from the name"


3. Preview and save

As the last step, click "Preview" in the top right to confirm that your new field is behaving as expected, and then click "Save".

Your new field may take a few minutes to process, after which you can use it to filter, show it in the design, or have it sent to Meta.