Here is a quick explainer on how to upload inventory numbers by location via the import tool.
Step-by-step using the Imports tool
1) Go to Imports tool
Left navigation pane: Click Tools → Click Imports
On the Imports page, click Update Inventory Quantities.
2) Get a template / current snapshot (Optional)
In the Update Inventory Quantities screen, use Export Inventory Quantities (top-right) to download a file you can edit and re-import.
Tip: Exporting ensures your column names match what the importer expects.
3) Choose where and how to update
Select warehouse: pick the location you’re updating.
Update type:
Add to quantities – increases existing on-hand by the amounts in your file.
Overwrite quantities – replaces existing on-hand with the amounts in your file.
4) Upload your file
Click Choose file and select your spreadsheet (Excel/CSV as supported by your tenant).
Click Next (or proceed to the Map Columns step).
5) Map columns
In Map Columns, map each required system field to the column in your file (e.g., SKU, Quantity, etc.).
Ensure every required field is mapped before continuing.
6) Preview the import
Review a sample of parsed rows in Preview.
Confirm warehouse, update type, and column mappings look correct.
7) Run the import
Start the import to move to Import Progress.
You’ll see real-time status as rows are processed.
8) Review errors (if any)
Open Import Errors to download the error report.
Fix the issues (e.g., missing SKU, invalid quantity, unmapped column) and re-import the corrected rows.
Tips & good practices
One warehouse at a time: Run separate imports per warehouse for clarity.
Choose the right mode: Use Overwrite for full stock counts; Add for receipts/adjustments.
Start with an export: Using the Export Inventory Quantities file minimizes mapping mistakes.
Keep IDs clean: Make sure SKUs in your file exactly match what’s in Luminous (no extra spaces, correct casing).