Mapping

Data mapping is a key aspect of any system integration. In Flxpoint, mapping is handled in three ways:

  • Mapping templates
  • Mapping sets
  • Mapping rules
Dropdowns
  • Dropdowns can be leveraged using Mapping Templates, Mapping Rules, Workflow Rules, Filters / Saved Filters
  • Dropdowns have an indicator letting you know what type of field is being used. This can be various field types like Text, Numbers, True/False, Key/Value Pairs, etc.
  • Dropdowns have a search bar that allows you to search for what you're looking for Variant Category 1 Equals Accessories or Variant UPC Valid Equals True
Image 1

 

Mapping Templates

Mapping templates are primarily used to map external fields into Flxpoint internal fields. These are also used for internal building processes, such as creating products.

 

 

Mapping Sets

Mapping sets are a component contained within mapping templates. These sets allow simple look-ups to occur and map a value seen into a known value within the integration, such as "A" into "Alpha."

Use Case:

You may have a "Condition" field in a listing in Flxpoint, with values "new" and "refurbished."

In another system, "new" may be represented with "1" and "refurbished" may be "2."

Using a mapping set similar to :

→ "new" → "1"

→ "refurbished" → "2"

This will accommodate this mapping for a specific field, within a mapping template. While this may not be incredibly useful for only two values being mapped, as the subset of data needing mapped grows, mapping sets become a more valuable tool.

Image 1

 

Mapping Sets can then be applied in a Mapping Template for a specific field.

Image 1

 

Mapping Rules

Mapping rules are a component contained within mapping templates. These rules allow for conditional modifications to a specific field within a mapping template.

Use Case:

Perhaps you want to clean up titles as they are imported from a source for a specific brand.

One way to achieve this would be to create a mapping rule during the Get Inventory [Primary] process.

This rule could be structured as :

→ "If Brand = XYZ" then apply "Sentence Case" to title

Image 1

 

Mapping Rules can then be applied in a Mapping Template for a specific field.

Image 1