The Query Editor allow users to copy and paste data into the rules section, and transform data easily when working with multiple conditions, condition groups, or text replacements within a rule. 

Steps to use the Query Editor

1. Click into an existing rule or add a new rule.
2. Click the three dots to the upper right within a rule and select 'Query Editor'. You can always select the help field once within the Query Editor to review the available fields that you can use to apply when working within the Query Editor as well as use the field look up feature within the help section to better review the attribute fields either at the [P] Product or [F] Feed level.
3. You can then begin to copy and paste any values as needed to complete setting up the conditions of the rule. It may be helpful to have your import data downloaded and opened in another window so you can refer to the product attribute fields from your import to know what values you should be mapping here.

Example

Below is an example of one way our account management team has transitioned data for a customer. The below example breaks down how to create a rule to set the Feed field "shipping_label" to the static term of "FREE" within the feed we are submitting to the channel.

We have a list of over 200 "Store_ID" values to base this on and to create a rule with over 200 conditions can take quite some time on the user's end. The video shows how we are able to copy the list of "Store_ID" values and transform the data in Excel then paste the values back into GDF to save the rule. This would allow the user to save time individually creating the rule or basing this off a merge file. 

Benefits & Functionality

• Can save time when it comes to creating rules with multiple conditions, condition groups, or text replacements within a rule based on a list of information.
• Ability to copy and paste text details and transform them into a rule.
• Allows the user to be able to better copy and paste the data from a formula created in Excel to text and transform that text into a rule within Godatafeed.

Important things to keep in mind

You can view the compiled query once you’ve copied and pasted the data into the editor for review before you save. This allows you to make changes to your text before you save and apply the rule.

The color code within the query editor will adjust to the new values once saved and compiled. You may need to type the values within the editor and click out to see these values reflected. 

Need further support in setting up a string function? Contact our support team and please provide 3-5 example sku's as well as the expected before and after values for our team to best assist you further.