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
- Open Min/Max, also called Order/Line Points in some workspaces, and drag your file onto the table.
- 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.
- Match your item, Minimum, and Maximum columns. For location, reason, and expiration, choose a file column or a shared value for all rows.
- 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.
- 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.