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.

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
    Lookup-table-1
The first column must include the values as they are described in your feed. And in the second one, please include the new values.
  1. In the upper-right corner, click Share > Get shareable link

  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
Lookup-table-2
  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

Optimization Case Studies:

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

Contact

Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)