Feed filters

Feed filters provide a powerful way to determine what data gets imported into your database and what not. Filters also allow you to shape your data by renaming, appending and concatenating fields. Filters are always attached to a feed and can only be created from the Feed detail screen.

The filter detail screen is divided into two parts: subject and action. The subject shows the feed, sequence and feed field. The action determines what the filter actually does.

Subject

  • Feed
    The name of the attached feed, for reference only.
  • Sequence
    Optional sequence number to determine the order in which filters are executed. Enter a numeric value.
  • Feed Field
    Select the field on which the filter is executed.

Action

There are 16 different filters, selected via the Do what listbox:

  • Change case
    Change the casing of the subject's contents (UPPER, lower, First, Words).
  • Decode HTML entities
    Decode HTML entities in the subject's contents. For instance © is decoded to ©.
  • Encode / Decode
    Select to either UTF-8 encode or decode the subject's contents. UTF-8 encoding is sometimes necessary when the datafeed is encoded in a different format (ASCII, ISO-8859-x, Windows-1252, etc)
  • Key-Value pairs
    Reserved for future use.
  • Search and replace
    Search and replace a subject's contents. 
    • Search for
      Enter the text to search for. 
    • Replace with
      Value you want to insert into your subject. You can insert the contents of other fields by using placeholders like {{csv-field}}. For instance, to insert the value of the category field, use {{category}}.
  • Search and replace RegEx
    Same as Search and replace but accepts regular expressions in the Replace with textbox.
  • Skip row if
    All rows with matching criteria are skipped during import. For instance, you could skip all rows where a category field contains a specific value.
  • Skip row if greater than
    Added in version 1.3. The row is skipped if its value as greater than the specified value. Note that this only works on fields with numeric values. 
  • Skip row if less than
    Added in version 1.3. The row is skipped if its value as less than the specified value. Note that this only works on fields with numeric values. 
  • Skip row if not
    All rows with non-matching criteria are skipped during import. For instance, you could skip all rows where no price value is present.
  • Skip row if not RegEx
    All rows with non-matching regular expression criteria are skipped during import. For instance, you could skip all rows not in a specified number of categories.
  • Skip row if RegEx
    All rows with matching regular expression criteria are skipped during import.
  • Strip HTML from field
    All HTML tags are removed from the field's contents. This can be helpful if a merchants html interferes with your site design.
  • Text after
    Append the field with specified text. Use {{csv-field}} placeholders to append the field with contents from another field.
    For instance, a DeliveryTime field might contain the number of days orders take to deliver. The Text after filter can be used to append " days" to the field's contents.
  • Text before
    Same as Text after, but appends text before the original content. For instance, a field DeliveryCost field might only contain a numeric value. The Text before filter can be used to add a currency sign before the amount.
  • Text replace
    Replace the complete contents of the field with the specified value. {{csv-field}} placeholders can replace the contents with the contents from other fields. Note how this is different from the Seach and replace filters, which only replace part of the original contents.