Skip to main content
When you already have agreed Min/Max targets in a spreadsheet, upload them to Lantern together instead of opening each item. For example, you may have reviewed a list of products for a customer commitment and chosen a different Min and Max for each one. An upload saves those quantities as overrides. They hold your chosen targets until their expiration or until you change or remove them. Use an end date for a temporary commitment so you can return to Lantern’s recommendations afterward.

Choose the quickest way to make the change

Prepare your file

Use a CSV or XLSX file, with one row for each item and location you want to change. Keep item and location IDs as text in Excel so leading zeros stay intact. Keep only the rows you want to change: hidden and filtered-out Excel rows are included in the import. See file requirements for accepted dates, numbers, and formulas. Include both Minimum and Maximum on every row, even when updating an existing override. Zero is a valid quantity; quantities must be nonnegative and Minimum cannot exceed Maximum. Lantern rounds each quantity to a whole unit. Use each item/location pair only once in the file. Your column names do not need to match Lantern’s labels. You choose which columns supply each field before applying the changes.

Upload and review

  1. Open Min/Max, also called Order/Line Points in some workspaces, and drag your file onto the table.
  2. In Match your columns, choose the worksheet to import if the workbook has more than one. Check First row is column names against your file.
  3. Match your item, Minimum, and Maximum columns. For location, reason, and expiration, choose a file column or a shared value for all rows.
  4. Choose the duration deliberately. Expiration starts as Permanent when no expiration column is detected. Use Specific date for a temporary commitment, or map a column containing the end dates.
  5. Review the sample rows, including the item IDs, locations, quantities, reason, and expiration. Confirm that the file contains only the items you intend to change, then select Start import.
Uploading and matching columns lets you review the file before you start the import. Once started, its rows are saved as overrides. For an item/location that already has an active override, the uploaded values replace it. A saved row also shows its item/location on Min/Max again if it was hidden. Where your account can add items to locations, a row for an item/location Lantern does not have yet adds it.

Check the result and put it into use

Check the Updated, Failed, and any Duplicates skipped counts. If some rows failed, correct and upload them again. Return to Min/Max and check the affected targets and Override History. Saved overrides may take a few minutes to appear on the dashboard. Use history to review their values, reason, and expiration, or to edit or remove them later. The upload saves overrides in Lantern. To carry the reviewed targets into your buying process, follow Apply reviewed targets.