How to Bulk Replace Values in Your Product Feed

Posted on June 20, 2018 by Monica Axinte

bulk-replace-product-feed  

Whenever you need to update your feed, creating repetitive rules is a nuisance.

In DataFeedWatch you can quickly create bulk edits and rules with the Replace Multiple Values feature.

Replace multiple values does the name says: replaces in one fell swoop occurrences of multiple strings.

This feature is very powerful and versatile because it allows for speedy edits and changes.

 

Bulk edits with Replace Multiple Values

In the mapping interface you can find this feature in the Edit Values section. By selecting it you will be able to find and replace multiple texts in your input fields with the corresponding values in the lookup table.
edit_values

If you want to use this mapping type, then all you need to do is upload an Excel sheet containing two columns:

1. The First Column: the original list of unique values you want to replace
2. The Second Column: the new list of values

The Excel document can be uploaded from your computer, or via Google Spreadsheets if more team members are collaborating on a file.

Everything is best explained through examples, so let’s see how you can use them to replace rules in one fell swoop.

 

Example: How to Standardize the Colors in your Product Title 

For example, it is best practice to flatten the colors in your feed into something a user would search for.

Let's say the feed you imported in DataFeedWatch Looks like this:

product-feed

If you would like to standardize the colors in your title, because as we have learned in the feed optimization tips and trick post, it increases the CTRs of your listing ads, here's what you would have to do:

1. Create an Excel Document with two columns that contains the original and the new values. 

Screen Shot 2018-06-20 at 16.02.18

2. Create an internal field (so you can always have in your library of rules) called Standardized_Title and map it from your shopping cart Title

standardized_title

3. Go to Edit Values and select the Replace Multiple Values option. 

replace_multiple_values

4. Upload the .csv document from your computer or provide the URL of the Google Spreadsheet and save the mapping. The new field will have the standardized colors instead of the original ones.

lookup_table

5. The outcome values for <Standarized_title> field will be:

standardized_colors

For any given field you need to provide a list of strings you want to replace and a corresponding list of new strings to replace them with.

 

Conclusion

This feature comes with many advantages for the feed marketers, as it helps normalize the feed product database. 

If there are bulk edits that you would like to apply to your feed, and you don't know where to start just write us an email at support@datafeedwatch.com and we will assist you. 

 

 

About DataFeedWatch

DataFeedWatch is data feed optimization and management software that enables merchants on Magento, Shopify, Volusion3Dcart, BigCommerce, WooCommerce, OpenCart, VersaCommerce, and numerous other shopping carts to optimize their product data feed for Google and 1000+ Shopping Channels in 50 countries. The most intuitive and easy data feed management and optimization tool on the market. Free trial and live demo available.

Posted in: DataFeedWatch News

Written by Monica Axinte

Monica Axinte is the VP of Marketing for DataFeedWatch.
Find me on:

Related posts

  Whenever you need to update your feed, creating repetitive rules is a nuisance. In DataFeedWatch you can quickly create bulk edits and rules with ...
  Whenever you need to update your feed, creating repetitive rules is a nuisance. In DataFeedWatch you can quickly create bulk edits and rules with ...
  Whenever you need to update your feed, creating repetitive rules is a nuisance. In DataFeedWatch you can quickly create bulk edits and rules with ...
  Whenever you need to update your feed, creating repetitive rules is a nuisance. In DataFeedWatch you can quickly create bulk edits and rules with ...

Share This!

Subscribe to Email Updates