Skip to content

Lookup data

Edit a table the integration reads, such as a SKU map or carrier codes. Change it in a grid, or replace the whole file.

The lookup grid

  1. Pick a lookup from the list.
  2. Edit a cell, Add row, or Delete selected rows. You can paste a block straight from Excel.
  3. Select Save.

Saving checks the data against the lookup’s shape before it is stored. A bad value, such as a wrong column or a word where a number belongs, is refused, with the line and column to fix.

Select the Replace file tab to download the current file, edit it in Excel, and upload it back. The whole file is replaced.

The Replace file tab

Uploading an empty file would delete every row, so it is refused until you confirm you mean it.

Every save keeps the copy it replaced. Select Earlier copies to see them and restore one. Restoring keeps a copy too, so it can itself be undone.

The Earlier copies tab

If someone else saved while you were editing, your save is refused so their work is not lost. Reload and try again.