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:
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.
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".
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.
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 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.
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".
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"
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.