Your Product Data Feed is the foundation for success in Google Shopping. A well organized and optimized feed can help you to better connect to relevant Shoppers when they are searching in Google, Bing and more.

Not only can our platform create a product feed for you, but you can take it a step further and optimize the data with Feed Rules.

The editable fields are as follows:

Additional Image Links

Ads Redirect URL

Age Group

Availability

Brand

Color

Condition

Custom Labels 0-4

Description

Gender

GTIN

ID

Identifier Exists

Image Link

Is Bundle

Item Group ID

Link

MPN

Material

Multi-Pack

Pattern

Product Type

Promotion ID

Sale Price

Shipping

Shipping Dimensions: Height, Length, Width

Shipping Label

Sizes

Title

Exclude From Channel

Include In Channel

Refer to https://support.google.com/merchants/answer/7052112?hl=en for a detailed overview of each attribute.

To get started, head to the "Feed Rules" portion of the feed tool.

Next, select the field you wish to create a rule for. By default, you'll notice "Additional Image Links" is selected. Click the X in the selection box to reveal a drop down where you can locate your desired field (unless, of course, you want to adjust additional image links).

Once you've selected your field, click "Add Rule."

Now it's time to build your rule. This process is split up into several parts:

Part 1: Rule Definition

This determines the type of rule you'll be using to edit your attribute and modify products. There are currently 4 Rule Types that can be built depending on the attribute you select.

Fixed Attribute Value

Channels like Google have preset values that can only be used when submitting feeds, such as for attributes Age Group and Gender. For this rule type, you must select an attribute to set before saving.

Text Attribute Builder

A drag and drop text string builder that allows you to select from pre-existing attributes as well as being able to add Custom Text, to restructure your chosen attribute entirely, such as when rebuilding Product Titles.

Find Replace

Build a custom template to find specific words or phrases within an attribute and replace them entirely with that of your choosing.

Extractor

Also utilizes templates allowing you to extract data from one attribute to be inserted for another. For example, if color exists in your product title but not for the actual color attribute, you can create a rule for color to extract the value from the title.

Part 2: Filter Products

Build filters to ensure your modifications are only applied to products that match your criteria. By not creating a filter, you are enabling a rule to apply to ALL PRODUCTS in your feed. Filters can consist of single attribute criteria or multi-attribute criteria by clicking Add Filter to build each additional criteria desired.

IMPORTANT NOTE: AND vs OR Filters

Filters can differ by their function using AND / OR logic. To create an OR logic, a filter must have multiple values entered at once:

To create AND logic, there must be multiple filters that all determine the select criteria:

Part 3: Product Channels

Use this section to determine which channels you wish to have rules applied to. Simply check off your desired channels and uncheck those you do not wish to apply rules to:

Note that your channels will also be listed on the rule itself:

Part 4: Saving & Previewing Rules

Once you are satisfied with your modifications, you will have to save your rule to then be able to preview the changes under Selected Rule Preview. Note that if you are unsatisfied with your rule or made a mistake in your set up, you can return to Edit Rule to adjust at any time.

The modified attribute will be displayed under its respective column, labeled with "modified:"

All column headers are filterable using the filter icon to the right of the column name. You can adjust which columns are displayed by clicking on the three-bar icon to at the top right corner:

Additionally, you can export the entire table into a CSV file using the export icon:

Last Step: Send Your Feed

To ensure your modifications take affect, you will have to send your feed to your respective channels. Do so by navigating to Feeds > Send Feed:

Note that you will have to send each channel feed separately if you are currently linked to more than one channel.

Also note that average processing times vary from channel to channel with Google and Bing taking up to 2 hours or more to show changes while Facebook may show changes within minutes.

Still have questions? Contact us via email at support@salesandorders.com or via in-app Live Chat!

Did this answer your question?