FeedArmy Import Rules
By default FeedArmy imports all required data, however, there are occasions where you need to either create a missing import attribute or to create custom rules and or combinations. In this tutorial, I will explain how to set these up.
What can I do?
An import rule allows you to change the target attribute automatically when importing data, by using one of the following options.
- Use values from an existing source attribute
- Create a custom value
- Create a custom value based on criteria in a feed field
To create a rule, simply choose your target attribute and select one of the available options. Certain target attributes will not have source attribute available due to Google Shopping requirements.
Use values from an existing source attribute
The source attribute is defined by the credentials you have set up. For example, if you have set up a Shopify connection, then the import source is Shopify.
By selecting this option, you can use any available source attribute to replace the target attribute with the import value.
For example: If you have a color assigned to Shopify Option 1, then you first select the color target attribute, then choose option 1 from the existing source attribute option.
Create a custom value
You can also create custom combinations using both source attributes and text or only use one of the two values.
Let’s say we want to add the brand name at the end of the title. We then simply select our target attribute title, then choose the option to create a custom value. From the drop-down choose a title and add an input field.
You can now add your own text in the input field.
You can also use multiple input field and source attributes without restrictions.
Create a custom value based on criteria in a feed field
Using this option will allow you to create if else conditions. This is a great tool if you want to create values based on certain rules.
Example: If we want to add the word education in custom labels 0 for every time the word school is found in the title.
Then we would select our target attribute custom labels 0 and create a rule as following:
If title contains school : value = education (example in the image below)
We can also choose multiple conditions by clicking on +Condition or set the else rule.
- is absent
- has value
- does not have value
- does not equal
- does not contain
- starts with
- does not start with
- ends with
- does not end with
- less than
- less than or equal to
- greater than
- greater than or equal to
- is valid barcode
- is not valid barcode
The else rule allows you to set a value if nothing is found. You can choose one of the following options :
- use values from existing source attribute
- remove values that you may have submitted for this attribute
- create custom value
- preserve any value that you may have submitted
If the first rule is matched, any other condition down the line will be ignored. Make sure that you take this into consideration when creating the if rules as you might need to reorder how they are listed.
Things to remember
Do remember that the rules you set will always be assigned to new products, for existing products you need to enable update rules.
If you choose to apply these to existing product all edits you have manually made to these specific rules will be overwritten. It is best to always download a copy of your data (Advanced > Download), in the event of an error that you can upload via CSV (Step 4).
If you only need to make certain changes once, then I recommend using search and replace.