Feed Modification Examples TopOpen

Set

Set the value of a field to any number of constants and/or field values. Will completely overwrite the previous value of the field. Primarily used for appending values and setting default values for empty fields.

  • Prepend Brand to beginning of Title
  • Set Title Brand Title
  • Append Size and Color to end Title
  • Set Title Title Size Color

Set Multi-value

For setting fields with multiple values. Only applicable to certain fields which accept multiple values and still works when the field does not yet have a value.

  • Add "electronics" AdWords Label
  • Set Multi-value AdWords Labels electronics
  • Add Gender value AdWords Label
  • Set Multi-value AdWords Labels Gender

Unset

Remove the value of a field in the feed, leaving it blank or out of the feed (when applicable).

  • Unset the MPN field
  • Unset MPN
  • Unset the Shipping Cost field
  • Unset Shipping Cost

Find & Replace

Within a given field, find a constant or field value and replace with another constant or field value.

  • Replace "violet" with "purple" in titles
  • Find & Replace Title Violet Purple
  • Remove "Free Shipping" from descriptions
  • Find & Replace Description Free Shipping (empty)

Find & Replace (Regex)

Find & Replace functionality, but with the addition of regexes and capturing groups.

  • Find various "red" colors and replace all with Red. The (?i) means case-insensitive. The | (pipe) char acts as an "or".
  • Find & Replace (Regex) Title (?i)scarlet|ruby|crimson Red
  • Remove everything but the last leaf node of the Internal Category (AKA Product Type). \1 is the captured (.+) value.
  • Find & Replace (Regex) Internal Category > (.+)$ \1

Change Case

Change the case of a field to: Sentence case, Title Case, UPPER CASE, or lower case.

  • Capitalize first letter of sentences in description
  • Change Case Description Sentence Case
  • Set MPN to all caps
  • Change Case MPN Upper Case

Change Case (Smart Title)

An enhanced version of Title Case with lots of extra options. Ideal for fixing entirely upper case source feed titles.

  • Capitalize first letter of sentences in description
  • Change Case (Smart Title) Title Skip Under: 3 chars Force Titlecase: Ax, Go Preserve Case: USA, DMZ, WWW Articles: an, the, of, to, as, and, for, from
  • Skip Under: Words under this length will remain in their original case.
  • Force Titlecase: Force title case on words that would otherwise be skipped because of the Skip Under.
  • Preserve Case: Do not title case these words that would otherwise be title cased.
  • Articles: List of common article-type words to force lower case, unless at the beginning of the field.

Dedupe (Specific)

Remove duplicates of a given word or phrase. Choose which duplicate to keep, first or last. Duplicates do not need to be adjacent to be removed (e.g., "Nike Air Nike Shoes" would become just "Nike Air Shoes").

  • Remove duplicates of the word "Nike" from the Title
  • Dedupe (Specific) Title Nike Keep: First
  • Remove duplicates of Brand field value from the Title
  • Dedupe (Specific) Title Brand Keep: First

Dedupe (All)

Remove duplicates of all words. Choose which duplicate to keep, first or last. Optionally, provide words to ignore and leave as duplicates.

  • Remove all duplicate words from the Title
  • Dedupe (All) Title Ignore Words: (empty) Keep: First
  • Remove all duplicate words from the Title except the words: A, Tom, Paper
  • Dedupe (All) Title Ignore Words: A, Tom, Paper Keep: First

Normalize Spacing

Clean up all of the spaces in a given field, leaving just one space between each word. Helpful when appending fields and values to other fields.

  • Remove extra spaces from Title
  • Normalize Spacing Title

Append Query String

Append a query string (?abc=123&...) to the end of a URL. Preserves any existing query string. The beginning ? should not be included. Assumes entire query string has already been encoded.

  • Add tracking parameters to AdWords Redirect URL's
  • Append Query String AdWords Redirect URL source=Google&campaign=2014Q3
  • Set mode of an image URL
  • Append Query String Image URL size=large

Append Query String (Encoded)

Same as Append Query String except it assumes field values are unencoded. Constant values must still be manually encoded. In the first example, since Titles usually have spaces, we will encode the spaces with +'s.

  • Add tracking parameters to URL
  • Append Query String (Encoded) URL keyword={Title}&sku={Unique ID}
  • Example with encoded constants
  • Append Query String (Encoded) URL campaign=October+2014&cat=sports%2Foutdoors

Calculate

Set a field value to the result of a mathematical calculation of field and/or constant values. Use "string substitution" syntax (%s) for accessing field values.

  • Set Shipping Cost to 10% of price
  • Calculate Shipping Price %s * %s Price 0.10
  • Temporarily reduce prices by 15%
  • Calculate Price %s * %s Price 0.85


Schedule Demo

Our sales engineers are happy to set up a time for you to preview VersaFeed's software.
Please tell us a little bit about your business and we'll get back to you ASAP.












* Required field

VersaFeed Requirements

  • No firearms or accessories, medical supplies, vitamins or supplements
  • Minimum Google Shopping budget of $20,000/month
  • Minimum inventory size of 1,000 products
  • Minimum 6-month commitment on all plans

Human Test Image