Main Mapping Types: Lookup table (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.

The Lookup table option allows you to replace old values with new ones, if you paste the link to your Google Sheet (or refer to the article for Local Drive, CSV).

The file must contain 2 columns: one with current values from your shop, and another column with new values. Make sure your file contains only one sheet inside.

To use the Lookup table option, follow the steps below:
  1. Log in to Google Sheets, and prepare the relevant file with two columns
    The first column must include the values as they are in your feed. And to the second one add the new values.
  2. In the upper-right corner, click Share > Copy link
    Make sure this link is available to anyone on the internet.
  1. On your mapping page (Internal Fields or Map Fields tab), scroll down to a given field (e.g. size)
  2. From the second drop-down list, select Use lookup table option
  1. Next to it, select the field to be searched for values from the first spreadsheet column (e.g. size input field)
  2. Below, paste the shareable link to your Google Sheet file
  3. Click IF, select the same field with values (e.g. Size), and is in list from the dropdown adding the same Google Sheets link
    This will let you only change these values if they exist.
  4. In Else > Rename, choose the same field with values (e.g. Size)
    The original values will be kept if you add this rule.
  5. To apply changes, click Save and Proceed

Optimization Case Studies:

Using standard S, M, L sizes instead of other non-standard sizes (like Little, Small, Medium, Large and Big)

Here's a step-by-step animation:

Did this article help you solve the problem?

Main Mapping Types: Combine

Main Mapping Types: Lookup table (Local Drive, CSV)