Luminous provides three dedicated import tools under Tools → Imports → Costs & Finance for updating cost and landed-cost data in bulk. Each tool serves a distinct purpose — choosing the right one depends on whether you are working with cost layers or with lot-level landed costs.
At a glance: which tool do I need?
| Tool | What it does | Use when… |
|---|---|---|
| FIFO Cost Layer Multi-Value | Replaces all existing cost layers for a SKU + warehouse with a new set you define | You need to seed or reset cost-layer history |
| Unit Cost Override | Updates the unit cost on existing active cost layers in place | You need to correct a wrong cost without touching quantities |
| Lot Landed Costs | Adds or updates a landed-cost value against a specific lot number + SKU | You track inventory by lot and need to record per-lot landed costs in bulk |
Note: The Unit Cost Override importer is tagged Destructive in the UI — review your data carefully before uploading.
Tool 1 & 2 — FIFO Cost Layer Multi-Value and Unit Cost Override
These two tools let you bulk-manage the cost layers attached to your SKUs. Full step-by-step instructions, column definitions, import modes, and common error fixes are covered in the dedicated article:
👉 How do I perform a cost-layer import and bulk cost override for SKUs in Luminous?
Tool 3 — Lot Landed Costs import
If your products are lot-tracked, you can bulk-assign a landed cost to each lot using the Lot Landed Costs importer. This is separate from the cost-layer tools above — it records the landed (all-in) cost against a specific lot batch rather than adjusting FIFO layers.
Step-by-step
- Go to Tools → Imports and open the Costs & Finance section.
- Click Lot Landed Costs.
- Click Download Lot Landed Costs Template.
- Fill in the template — each row represents one lot + SKU combination:
| Column | Required? | Notes |
|---|---|---|
LOT_NUMBER | Yes | The exact lot number as recorded in Luminous |
MASTER_SKU | Yes | The SKU the lot belongs to |
DESCRIPTION | No | Optional label or note for this cost entry |
LANDED_COST | Yes | The landed cost amount for this lot, as a number |
- Save the file, then on the same page click Select a File to upload it, confirm the column mapping on the Map Columns step, and review the Preview before running the import.
- Each row is validated and processed independently. If a row fails validation, that row is skipped and an error is recorded — but other valid rows in the same file are still saved. Review any reported errors, correct the affected rows, and re-upload just those rows.
- Once the import completes successfully, verify the results by navigating to the relevant lot records in Luminous.
Tips
- One row per lot. Each
LOT_NUMBER+MASTER_SKUcombination should appear once per file. - Lot number must exist. The lot must already be recorded in Luminous before you can assign a landed cost to it via import. Rows whose SKU or lot number cannot be found are skipped without being saved, so double-check spelling if a lot's landed cost does not update.
- LANDED_COST must be a number. Do not include currency symbols or commas.
- You can import multiple SKUs and multiple lots for each SKU in a single file — each row is processed independently.
Landed costs on purchase orders
If you need to record additional shipping, freight, or duty charges against a purchase order (rather than against a lot), those must be added per-PO after import — they cannot be set in bulk through an import file. See:
👉 How do I add additional (landed) costs to purchase orders when bulk importing?