How do I bulk-update cost layer and landed cost data across multiple SKUs using an import?
Last updated: September 25, 2026
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 |
|---|---|---|
| Yes | The exact lot number as recorded in Luminous |
| Yes | The SKU the lot belongs to |
| No | Optional label or note for this cost entry |
| 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?