Query Editor

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.

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. 

Purpose

To 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. 

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. 

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.

• Create and update rules using the GoDataFeed query editor. After validating the query, apply it to the rule editor and save your rule. Queries must adhere to the following syntax:

  SET [P/F].[Field]
  TO [P/F].[Field] "sample"
  REPLACE "sample" WITH "sample2"
  REPLACE "sample3" WITH "sample4"
  WHERE [P/F].[Field] equals to "sample"
  AND [P/F].[Field] equals to [P/F].[Field]
  OR [P/F].[Field] equals to [P/F].[Field]
  AND WHERE [P/F].[Field] equals to [P/F].[Field]
  
  

• Each tag should be on a new line

• The REPLACE tag uses the WITH keyword (EX: REPLACE "X" WITH "Y")

• Use the tag AND/OR WHERE for additional condition groups.

• You can use the compiled query to investigate issues.

• 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.