This guide will walk you through the feed rules and introduce the brand-new comparison operators available for building powerful feed rules. These operators provide greater flexibility and control when filtering and modifying product data.

Introduction to Feed Rules

Feed rules in GoDataFeed act like SQL queries, allowing you to manipulate and optimize your product data before sending it to various shopping channels and marketplaces. Each rule consists of three key components:

1. SET field: Defines the new value or transformation to be applied to the target field.
2. TO field: Specifies the target field in your feed that you want to modify or populate.
3. WHERE condition: Establishes the criteria for which products the rule should be applied to. This is where comparison operators come into play.

Understanding Comparison Operators

Comparison operators are essential for constructing WHERE conditions in feed rules. They allow you to compare values in your feed data and determine which products meet specific criteria. GoDataFeed offers a variety of comparison operators, including:

• Equals (=): Checks if two values are identical.
• Not Equals (<>): Checks if two values are different.
• Greater Than (>): Checks if the left value is greater than the right value.
• Less Than (<): Checks if the left value is less than the right value.
• Greater Than or Equal To (>=): Checks if the left value is greater than or equal to the right value.
• Less Than or Equal To (<=): Checks if the left value is less than or equal to the right value.

Static Text vs. Variables

In GoDataFeed, WHERE conditions can utilize both static text and variables for comparisons.

• Static Text: This refers to fixed values like numbers (e.g., 100) or text (e.g., "instock").

• Variables: These are dynamic values represented as [P].[Name], where "P" signifies "Product" and "Name" refers to the specific field in your product data (e.g., [P].[Price] or [P].[ImageURL]).

Using variables allows you to create more flexible and dynamic rules that adapt to the specific values of each product.

New Comparison Operators

The following table summarizes the new comparison operators and their functions:

Image Dimension Comparisons

The new IMGW and IMGHoperators allow you to create rules based on specific image width and height requirements. This is particularly useful for:

• Ensuring image quality: target products with small images and replace them with higher resolution versions.

• Meeting marketplace image guidelines: filter out products that don't meet specific image dimension requirements of certain channels.

• Optimizing image sizes: identify images that are unnecessarily large and resize them for faster loading times.

File Size Comparisons

The SIZE operators enable you to create rules based on file sizes. This can be helpful for:

• Managing storage space: identify and remove products with excessively large files.

• Improving download speeds: target products with large files and compress them for better user experience.

• Meeting file size limits: filter out products that exceed file size restrictions on certain platforms.

HTTP Status Code Comparisons

The STAT and STA<> operators provide the ability to create rules based on HTTP status codes returned when accessing product URLs. This is useful for:

• Identifying broken links: target products with 404 status codes and update their URLs or remove them from your feed.

• Monitoring website availability: track product URLs returning 500-level errors and investigate potential server issues.

• Improving data quality: ensure product URLs are accessible and functioning correctly.

Examples of Use Cases

Here are a few examples of how the new comparison operators can be used in feed rules:

• This rule targets products with image widths or heights less than 500 pixels and replaces their image URLs with links to higher resolution versions.

  • SET: ImageURL
  • TO: https://www.yourwebsite.com/highresimages/[P].[ProductID].jpg
  • WHERE: [P].[ImageURL] IMGW< 500 OR [P].[ImageURL] IMGH< 500

• This rule excludes products whose image file sizes exceed 10 MB from the feed.

  • SET: Exclude
  • TO: TRUE
  • WHERE: [P].[ImageURL] SIZE> 10485760

• This rule sets the availability to "Out of Stock" for products whose URLs return any HTTP status code other than 200 (success).

  • SET: Availability
  • TO: Out of Stock
  • WHERE: [P].[ProductURL] STA<> 200

Additional Tips

• Combine multiple conditions: Use AND/OR operators to create more complex WHERE clauses.

• Use parentheses for clarity: Group conditions within parentheses to define the order of evaluation.

• Test your rules: Always test your rules before applying them to your entire feed to ensure they work as intended. You can use the rule preview, or feed preview feature to do so.

• Explore other operators: GoDataFeed offers a variety of other comparison and logical operators to further refine your feed rules.