Start an import
- 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.
- The import opens at Match your columns. Nothing changes until you select Start import.
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.
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
- 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.
- 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.
- 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.