How to use Field Mapping to optimize your feed
Field mapping in Feed Center allows users to assign values to product fields, ensuring consistency across product listings. Additionally, implementing rules enables greater flexibility, allowing for automated modifications based on specific conditions.
1. Understanding Field Mapping
- Inputting Values for a Field
- Saving the Mapping Settings
2. Adding Rules for Field Mapping
- Types of Rules
- Benefits of Using Rules
- Setting Up Rules
3. Default Rules in Feed Center
4. Important Notes
Field mapping allows you to assign specific values to product fields to maintain uniformity and improve data quality.
To get started, in Feed Center, click on the feed that you want to map value for products then you'll able to see list of feed field as below:
There are three methods to input a value for a field:
Choosing a Variant
To ensure product titles display only the product name without the variant name:
Click on the feed to be edited.
Select [P] Product Title from the drop-down list.
Save the changes.
The product now has the title of itself only, and do not include the variant's name
Combining Multiple Variants
To include both the product name and variant name in the title:
Select [P] Product Title from the drop-down list.
Add a hyphen and choose [P] Variant Title.
Save the changes.
The product now has the title that includes both its name and the variant's name
Typing Text or Numbers
You can manually enter values for fields.
- Text Example: Set identifier_exists to false to indicate the absence of a GTIN.
- Number Example: Assign a sale price effective date by inputting the date manually.
Click Save Settings on the top right to apply the field mapping settings to all products in the feed.
Once you click it, your Mapping setting will be saved and applied for all products . This means that this Mapping setting will be applied for all existing products in your feed and all previous product's data will be overidden.
After pressing Save Settings, you are able to see the newly assigned value when you click on your current feed.
Rules enable dynamic modifications to product data, allowing changes based on specific conditions.
Set To Rule
Assigns a value to an attribute based on existing product attributes or static inputs.
Extract Rule
Extracts specific terms from product data and assigns them to a defined attribute.
Adding missing required data:
For Example: Extracting color from the product title.
Resolving errors: Example: Assigning identifier_exists = false for products without GTIN.
Optimizing feed: Example: Enhancing title with additional attributes like color and SKU.
Navigate to Feed Center > Select a feed > Field Mapping > Click Add Rule to set up rules.
Click Add Rule next to the relevant field (e.g., color).
Choose Rule Type: Extract.
Set the source as Product Title.
Input the keywords to extract. You can input multiple words or phrases, and our app will find a matching value within the product title.
By choosing Whole words only, our app only extracts the color if it matches with the entire keyword as entered (for example, it does not take the word "white" inside the word "off-white"). By choosing Case sensitive, our app only extracts the color if it matches exactly to the keyword entered (for example, it does not take the word "Purple" with a capital P).
Assign the extracted value to the Color field.
Apply to relevant product groups and save.
You can create more than one sub-condition to filter a product group. Simply click on Sub-condition to create an AND condition.
You can also create more than one condition. Simply click on Condition(s) to create an entire IF condition.
Click Save for the Rules to be applied.
Afterwards, you will be able to see the Rules next to the field brand. Moreover, all the Rules you created are also displayed on the top right of the Field Mapping tab.
Presumably, some of your products are custom and they do not have the field gtin. As a result, these products are disapproved by Google. You want to indicate Google that gtins are not available for your product using the attribute identifier exists.
Click Add Rule next to gtin.
Choose Rule Type: Set To.
Assign identifier_exists = false.
Apply only to products missing a GTIN.
Save the rule.
Having a qualified product feed is not enough to maximize your reach and sales. To achieve it, you need to optimize your feed, and one of the fields that needs to be prioritized is your product title.
Click Add Rule next to title.
Choose Rule Type: Set To.
Include relevant attributes.
For example: If you are selling electronics and you want to include more information such as color and SKU in your title, you can choose these fields from the drop down list and type the punctuation to organize the title neatly (e.g. you can add a dash, or parentheses)
Apply the rule to specific product categories such as products having "Apple" as its brand
Save the changes.
Feed Center provides 6 default rules: 3 rules for Availability, 1 rule for Price, 1 rule for Shipping Weight and 1 Rule for Image Link
For example:
Availability: Sets items as "in stock" or "out of stock" based on inventory levels.
Out of Stock: If [P] Inventory < 0, [F] Availability = “out of stock”
In Stock: If [P] Inventory > 0, [F] Availability = “in stock”
These default rules can be turned off or customized based on user needs.
If a product satisfies many Rules, the Rule that has the highest ranking will be applied. You can also drag and drop to change the Rules ranking. In this example, the Rule 1 will be applied for this product.
When you set Rules for your feed, it will be more powerful than Mapping. An attribute set by Rules will always override its value set by Mapping, regardless of whether you enter the value of Rules first or Mapping first.
If both the Rules and Mapping are not applicable to an attribute (no product meets the conditions or the Rules are set incorrectly, there is no value assigned by Mapping), the value of that attribute will be null.
Field mapping and rules in Feed Center provide powerful tools to manage product data efficiently. By leveraging mapping settings and dynamic rules, you can enhance product visibility, comply with platform requirements, and optimize your feed for better performance.
If you have any further question about the Category, don't hesitate to contact us via in-app live chat or email at support@socialhead.io
Table of Contents
1. Understanding Field Mapping
- Inputting Values for a Field
- Saving the Mapping Settings
2. Adding Rules for Field Mapping
- Types of Rules
- Benefits of Using Rules
- Setting Up Rules
3. Default Rules in Feed Center
4. Important Notes
Understanding Field Mapping
Field mapping allows you to assign specific values to product fields to maintain uniformity and improve data quality.
To get started, in Feed Center, click on the feed that you want to map value for products then you'll able to see list of feed field as below:
1. Inputting Values for a Field
There are three methods to input a value for a field:
Choosing a Variant
To ensure product titles display only the product name without the variant name:
Click on the feed to be edited.
Select [P] Product Title from the drop-down list.
Save the changes.
The product now has the title of itself only, and do not include the variant's name
Combining Multiple Variants
To include both the product name and variant name in the title:
Select [P] Product Title from the drop-down list.
Add a hyphen and choose [P] Variant Title.
Save the changes.
The product now has the title that includes both its name and the variant's name
Typing Text or Numbers
You can manually enter values for fields.
- Text Example: Set identifier_exists to false to indicate the absence of a GTIN.
- Number Example: Assign a sale price effective date by inputting the date manually.
2. Saving the Mapping Settings
Click Save Settings on the top right to apply the field mapping settings to all products in the feed.
Once you click it, your Mapping setting will be saved and applied for all products . This means that this Mapping setting will be applied for all existing products in your feed and all previous product's data will be overidden.
After pressing Save Settings, you are able to see the newly assigned value when you click on your current feed.
Adding Rules for Field Mapping
Rules enable dynamic modifications to product data, allowing changes based on specific conditions.
Types of Rules
Set To Rule
Assigns a value to an attribute based on existing product attributes or static inputs.
Extract Rule
Extracts specific terms from product data and assigns them to a defined attribute.
Benefits of Using Rules
Adding missing required data:
For Example: Extracting color from the product title.
Resolving errors: Example: Assigning identifier_exists = false for products without GTIN.
Optimizing feed: Example: Enhancing title with additional attributes like color and SKU.
Setting Up Rules
Navigate to Feed Center > Select a feed > Field Mapping > Click Add Rule to set up rules.
1. Adding Missing Required Data
Click Add Rule next to the relevant field (e.g., color).
Choose Rule Type: Extract.
Set the source as Product Title.
Input the keywords to extract. You can input multiple words or phrases, and our app will find a matching value within the product title.
By choosing Whole words only, our app only extracts the color if it matches with the entire keyword as entered (for example, it does not take the word "white" inside the word "off-white"). By choosing Case sensitive, our app only extracts the color if it matches exactly to the keyword entered (for example, it does not take the word "Purple" with a capital P).
Assign the extracted value to the Color field.
Apply to relevant product groups and save.
You can create more than one sub-condition to filter a product group. Simply click on Sub-condition to create an AND condition.
You can also create more than one condition. Simply click on Condition(s) to create an entire IF condition.
Click Save for the Rules to be applied.
Afterwards, you will be able to see the Rules next to the field brand. Moreover, all the Rules you created are also displayed on the top right of the Field Mapping tab.
2. Resolving Errors
Presumably, some of your products are custom and they do not have the field gtin. As a result, these products are disapproved by Google. You want to indicate Google that gtins are not available for your product using the attribute identifier exists.
Click Add Rule next to gtin.
Choose Rule Type: Set To.
Assign identifier_exists = false.
Apply only to products missing a GTIN.
Save the rule.
3. Optimizing Your Feed
Having a qualified product feed is not enough to maximize your reach and sales. To achieve it, you need to optimize your feed, and one of the fields that needs to be prioritized is your product title.
Click Add Rule next to title.
Choose Rule Type: Set To.
Include relevant attributes.
For example: If you are selling electronics and you want to include more information such as color and SKU in your title, you can choose these fields from the drop down list and type the punctuation to organize the title neatly (e.g. you can add a dash, or parentheses)
Apply the rule to specific product categories such as products having "Apple" as its brand
Save the changes.
Default Rules in Feed Center
Feed Center provides 6 default rules: 3 rules for Availability, 1 rule for Price, 1 rule for Shipping Weight and 1 Rule for Image Link
For example:
Availability: Sets items as "in stock" or "out of stock" based on inventory levels.
Out of Stock: If [P] Inventory < 0, [F] Availability = “out of stock”
In Stock: If [P] Inventory > 0, [F] Availability = “in stock”
These default rules can be turned off or customized based on user needs.
Important Notes
If a product satisfies many Rules, the Rule that has the highest ranking will be applied. You can also drag and drop to change the Rules ranking. In this example, the Rule 1 will be applied for this product.
When you set Rules for your feed, it will be more powerful than Mapping. An attribute set by Rules will always override its value set by Mapping, regardless of whether you enter the value of Rules first or Mapping first.
If both the Rules and Mapping are not applicable to an attribute (no product meets the conditions or the Rules are set incorrectly, there is no value assigned by Mapping), the value of that attribute will be null.
Field mapping and rules in Feed Center provide powerful tools to manage product data efficiently. By leveraging mapping settings and dynamic rules, you can enhance product visibility, comply with platform requirements, and optimize your feed for better performance.
If you have any further question about the Category, don't hesitate to contact us via in-app live chat or email at support@socialhead.io
Updated on: 14/03/2025
Thank you!