Skip to main content
When you have changes for many items in a spreadsheet, import the file instead of entering each change by hand. Each row adds or updates one entry, and you review how Lantern reads your columns before anything is saved.

Start an import

  1. Open the page and drag your file onto its table. On Item Links, you can also drop the file on the page before you have any links.
  2. The import opens at Match your columns. Nothing changes until you select Start import.
If the import says file import isn’t available, ask your Lantern team for help.

Match your columns

Your column names do not need to match Lantern’s labels. Lantern matches the columns it recognizes, such as SKU or Item Number for Item ID, and you can change any match. For each field, choose one of:
  • A column from your file.
  • Use one value for all rows, where offered, to apply one value to every row. For example, choose one supplier for a supplier’s quote sheet that has no supplier column, or enter one reason for the whole file.
  • Permanent or Specific date, for Expiration, to give every row the same duration.
  • The default, for an optional field, shown as an option such as Default: 100% for an item link’s weight.
Required fields are marked with an asterisk. Start import stays unavailable until each one has a column or a shared value. If your workbook has several worksheets, choose the one to import. Check that First row is column names matches your file. The preview shows the first three rows as Lantern will read them, with any problems marked, so you can correct a match before you start.

What each row does

  • Adds or updates one entry. A row creates a new override or link, or updates the existing one for the same item and location (plus the supplier for lead times, or the source and target for item links).
  • Never removes entries missing from your file. Overrides and links that are not in the file stay as they are. Use the page’s own remove actions to end them. On Item Links, a new or changed link can replace links from your ERP for the same source item; see links from your ERP.
  • Uses the first row for a repeated entry. If two rows are for the same entry, only the first row is used, even if it fails. Later rows are skipped as duplicates.
  • Ignores blank rows. A row with no IDs or values in the matched columns is left out of the import and its counts, even if a cell such as its reason is filled.

Check the result

You can close the window while the import runs. It keeps running, and the page shows its progress. When it finishes, check Rows in file, Updated, Failed, and any Duplicates skipped. A failed row does not stop the others: updated rows are saved, and failed rows change nothing. Changes can take a few minutes to appear on the page.

Correct failed rows

  1. Select Download failed rows (or Download failed and skipped rows). The file keeps your original columns and adds each row’s original row number and the reason it failed.
  2. Correct the failed rows. If a skipped duplicate has the values you want, copy them into its failed row. Then delete the skipped duplicates; otherwise, uploading them would replace the rows that were already saved.
  3. Drop the corrected file on the same table. You can leave the added columns in. Choose any shared values again, because they are not part of the file.
The download is available for 30 days after the import. After that, correct your original file instead.

File requirements