Mapping types

The mapping type is the first thing a rule does. It makes the starting value, and then the rule's edits change it. See Mapping fields for how rules work and Edit values for the edits.

The examples on this page use this product:

Use

Use copies the value of one field, without changing it.

• Setting: the field to copy. You can pick an source field, a global store field, or a channel field higher in the list.
• Example: Use vendor gives Kiwi Outdoor Co.

Add static value

Add static value gives every product the same text.

• Setting: the text. It can include field values written as {{field}}. See Using field values in text.
• Example: new gives new.
• Example with a field: {{vendor}} - {{title}} gives Kiwi Outdoor Co - Merino Crew Tee.

Combine

Combine joins several parts into one value. Each part is either a field or some text.

• Settings:
  • Click + field to add a field, and + text to add text. A new text part starts as one space.
  • separator (optional). When you fill in a separator, Feedsmith puts it between the parts and skips any part that is empty or only spaces. When you leave it blank, Feedsmith joins the parts exactly as they are.

Without a separator, you add the spaces and punctuation yourself as text parts:

With a separator, empty parts are skipped, so you don't get stray dashes or slashes. Text parts that are only spaces are skipped too, so don't mix the two styles.

Text parts are used as typed. {{field}} inside a text part isn't replaced by the field's value, so use a field part instead.

Use lookup table

Use lookup table looks up the value of a field in a table of "old" and "new" values, and gives the new value.

• Settings:
  • The source field.
  • The table, with one pair per line, written as old => new or old,new.
  • Or a Google Sheets or CSV link, with old values in column A and new values in column B. You can use both, and Feedsmith reads the lines first and then the link.
  • Keep unmatched values. When ticked, a value that isn't in the table is kept as it is. When not ticked, it gives an empty value.
• How matching works: Feedsmith compares the whole value, ignoring upper and lower case and spaces at the start and end. The first matching line wins. Shirt doesn't match T-Shirts, because the whole value has to match.

Example with the source field product_type and this table:

T-Shirts => Apparel & Accessories > Clothing > Shirts & Tops
Jackets => Apparel & Accessories > Clothing > Outerwear > Coats & Jackets

Feedsmith reads a linked sheet again at most every 15 minutes, so a change to the sheet can take that long to show.

Extract from

Extract from looks for words from a list inside a field, and gives the first one it finds.

• Settings:
  • The source field.
  • The list, with one value per line, or a Google Sheets or CSV link (Feedsmith reads column A). You can use both.
• How matching works: Feedsmith goes down the list in order and gives the first value that appears in the source field as a whole word or phrase, ignoring upper and lower case. It gives the value as written in your list. If nothing matches, the result is empty.

Example with the source field title and this list:

Navy Blue
Blue
Red

Put longer values above shorter ones that they contain. If Blue were above Navy Blue, the first title would give Blue.

Leave empty

Leave empty gives an empty value. Use it to blank a field for some products.

• Example: Only if product_type is equal to Gift Card, Leave empty, then Otherwise Use barcode. Gift cards get no gtin, and everything else uses its barcode.

Edits that only add to a value, e.g. Add prefix, are skipped on an empty value. Overwrite still works.