Import All of Your Inventory Numbers by Location
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 Inventory Quantities.
2) Get a template / current snapshot (Optional)
- In the Inventory Quantities import screen, use Download Inventory Quantities Template (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 Download Inventory Quantities Template file minimizes mapping mistakes.
- Keep IDs clean: Make sure SKUs in your file exactly match what’s in Luminous (no extra spaces, correct casing).