Main Mapping Types: Lookup table (Local Drive)

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 upload a comma separated CSV (or please refer to the article for Google Spreadsheet).

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. Prepare the relevant file with both columns included
  2. Save your spreadsheet as comma separated CSV
  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
  3. In the next field, select the field to be searched for values from the first spreadsheet column (e.g. size internal field)
  4. Upload your CSV

Optimization Case Studies:

Applying standard sizes: S, M, L for non-standard sizes in your input (e.g.) Little, Small, Medium, Large and Big


Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)