Search
Clear search
Close search
Google apps
Main menu

Set up Feed Rules

Feed Rules give you the ability to transform your data to match our Products Feed Specification requirements. Use Feed Rules to resolve errors and help us interpret the data in your feed. This article explains how to set up Feed Rules for your product data.

 

Before you begin

In order to use the Feed Rules feature, you'll need to first register and submit a feed in your Merchant Center account so that there is data to create rules with.

Use Feed Rules

To create a new Feed Rules for your feed:

  1. Navigate to the Feeds page under Products
  2. Select the feed you want to transform with Feed Rules
  3. Select the Rules tab
  4. Click Create Rule. If you have more than one target country and target language connected to this feed, be sure to select the country that you would like to apply the rule to.
  5. Select the attribute that you would like to transform with Feed Rules.
  6. Use the Rules Wizard to guide you to apply a rule. The Feed Rules feature works with a cascading function, which means that if you have multiple alternative rules, it will try to apply the first one first. If that does not work (because it doesn't yield a valid value), it will try the next one, and so on. Learn more about the different types of rules below.
  7. Click Save as draft
  8. If you want to save the rules, click Apply changes. Alternatively, you can click Discard changes to remove the draft rules.
  9. Upload, or fetch, the feed you have created the rules for to apply the new rules to your product data.

The Feed Rules page contains an Attributes table which provides an overview of target attributes covered by Rules.

Types of rules

When setting up Feed Rules for a target attribute, you’ll have a few different options depending on the attribute and the type of data transformation needed. These options allow you to set your rules based on an existing data source, find and replace data in an existing source, or extract data from a source. 

Use "Set to"

The Set to option allows you to populate a target attribute with a combination of inbound columns, from any of your primary or supplemental feeds, and static values. This lets you append your existing product data and augment it with additional values. Example: Adding a brand to a title. You can use the "Set to" rule in the following ways:
  • Set an inbound column name to a specified Google attribute
    • Example: Set Availability to: my_first_feed.stockstatus
  • Populate a target attribute with a single, set static string value
    • Example: Set Condition to: “New"
  • Populate a target attribute with any combination of inbound columns, static vaues, or processed values. Use the concatenation (or combination) feature to create a string from multiple columns or values. 
    • Example: Set Title to: my_first_feed.brand + " " + my_first_feed.title
Use "Take latest"
The “Take latest” option allows you to populate a target attribute by drawing from multiple data sources, using the value from whichever source was updated most recently. That means you may use “Take latest” to update pricing and availability attributes of your primary feed by creating a separate supplemental feed with updated price and availability attribute values.
  • Take latest of: my_first_feed.availability and my_supplemental_feed.availability
  • Take latest of: my_first_feed.price and my_supplemental_feed.price
  • Take latest of: my_first_feed.sale_price and my_supplemental_feed.sale_price
  • Take latest of: my_first_feed.sale_price_effective_date and my_supplemental_feed.sale_price_effective_date

Legacy online inventory update feeds 
If you want to use a separate feed for pricing and availability updates, you can do this by creating a supplemental feed and using the "Take latest" rule to update your primary feed. 

Save Feed Rules

To save your rules and apply them to your feed, click the Apply changes button. After your changes have been applied, you will need to reprocess your feed. The new rules will appear on the newest upload on your product data, and will be applied to each upload until you make changes to the rules again.

To edit an existing rule, click on the grey box containing the rule in the Rule column. Apply any changes to the rule, and then click Apply changes to save your changes. Upload your product data to apply the edits.

 

 

Was this article helpful?
How can we improve it?