Edit Values: Replace multiple values (Google Sheets)

Paweł Updated by Paweł

Difficulty level: Pro.
If you're not sure how to proceed, or the function does not produce the right effects, please contact our Support Team.

Replace multiple values replaces many different original values with new ones. You can create conditions to specify the products for which you'd like to replace values.

To use this option you need to provide a file with two columns: old values that need to be replaced, and the new ones.

To use Replace multiple values, follow the simple steps below:

  1. Prepare a two-column Google Spreadsheet, with the old values on the left, and the new ones on the right
  1. In DataFeedWatch, scroll down to find the field you would like to map (e.g. Brand)
  2. From the first drop-down list next to it, select a main mapping type (e.g. Rename)
  3. In the next field select the Input Field or Internal Field that you would like to use
    Please note that Internal Fields (that are already mapped for the whole shop) will only be available in Map Fields tab.
  4. Click Edit Values on the right
  5. From the Mapping type drop-down menu, select Replace multiple values
  6. Click the Add from url and paste link copied from Google Spreadsheets
  7. To save changes, click Done

Optimization Case Studies:

Replacing sizes nomenclature with the standard S, M, L sizes

Did this article help you solve the problem?

Edit Values: Replace single value

Edit Values: Replace multiple values (Local Drive)