Stock Inventory Validator
A physical inventory count usually arrives as an Excel file typed by several people, and its mistakes only surface while it is being loaded, one at a time: a product code with a typo, a shelf that does not exist, a lot nobody wrote down. This module checks the whole file first and lists every problem, row by row, on one screen. Fix the file, upload it again, and repeat until it comes back clean. Nothing in your stock is changed while you check.
- ✓ See all the errors at once, with the Excel row number, instead of finding them one at a time
- ✓ Catches duplicated lines, unknown products, missing lots or serial numbers, wrong locations and invalid quantities
- ✓ Works with column headers in English or Spanish, and never modifies your inventory
How it works
1. Open it next to Physical Inventory
In Inventory, open Operations > Adjustments > Validate Inventory File. It sits right under Physical Inventory and is available to inventory administrators.
2. Upload your Excel file
The file needs one header row with the columns Name, Internal Reference, Location, Lot/Serial (optional) and Counted Quantity. Upload it and press Validate.
3. Read every error in one list
The same window comes back with how many rows were checked and one line per problem: the Excel row, the column at fault, the product and location written in that row, and what is wrong with it. Correct the file and validate again, as many times as you need.
4. Group the errors to fix them by kind
With a long file, View Grouped Errors opens the same errors in a new browser tab, grouped by message with a count on each group, so the window you are working in stays open. A wrong shelf repeated on fifty rows becomes one group to fix in one go.
5. Load the file once it comes back clean
When nothing is wrong, the window says so and how many rows it checked. The file is now ready to be loaded into your physical inventory.
Good to know
- It only checks the file. It does not load the count into your inventory or change any quantity; loading it is a separate step.
- Only the first sheet is read, and only Excel files (.xlsx). Empty rows are skipped, and the column headers can be in English or in Spanish.
- A product is found only when its name and internal reference both match the same product. Archived products and locations are not found.
- Locations can be written as their full path (WH/Stock/Shelf 1) or by their name alone, and must be internal stock locations.
- A quantity typed as text with a comma, such as 1,5 or 1,000, is rejected on purpose, because the comma can be read either as a decimal or as a thousands separator. Use a number cell or a period for decimals.
- A product tracked by lots or serial numbers needs one on every row, except when its counted quantity is 0.
- With several companies, the file is checked against the products and locations of the company you are working in, plus those shared by all companies.
Kaitim · Odoo 18.0
A physical inventory count usually arrives as an Excel file typed by several people, and its mistakes only surface while it is being loaded, one at a time: a product code with a typo, a shelf that does not exist, a lot nobody wrote down. This module checks the whole file first and lists every problem, row by row, on one screen. Fix the file, upload it again, and repeat until it comes back clean. Nothing in your stock is changed while you check.
- ✓ See all the errors at once, with the Excel row number, instead of finding them one at a time
- ✓ Catches duplicated lines, unknown products, missing lots or serial numbers, wrong locations and invalid quantities
- ✓ Works with column headers in English or Spanish, and never modifies your inventory
How it works
1. Open it next to Physical Inventory
In Inventory, open Operations > Adjustments > Validate Inventory File. It sits right under Physical Inventory and is available to inventory administrators.
2. Upload your Excel file
The file needs one header row with the columns Name, Internal Reference, Location, Lot/Serial (optional) and Counted Quantity. Upload it and press Validate.
3. Read every error in one list
The same window comes back with how many rows were checked and one line per problem: the Excel row, the column at fault, the product and location written in that row, and what is wrong with it. Correct the file and validate again, as many times as you need.
4. Group the errors to fix them by kind
With a long file, View Grouped Errors opens the same errors in a new browser tab, grouped by message with a count on each group, so the window you are working in stays open. A wrong shelf repeated on fifty rows becomes one group to fix in one go.
5. Load the file once it comes back clean
When nothing is wrong, the window says so and how many rows it checked. The file is now ready to be loaded into your physical inventory.
Good to know
- It only checks the file. It does not load the count into your inventory or change any quantity; loading it is a separate step.
- Only the first sheet is read, and only Excel files (.xlsx). Empty rows are skipped, and the column headers can be in English or in Spanish.
- A product is found only when its name and internal reference both match the same product. Archived products and locations are not found.
- Locations can be written as their full path (WH/Stock/Shelf 1) or by their name alone, and must be internal stock locations.
- A quantity typed as text with a comma, such as 1,5 or 1,000, is rejected on purpose, because the comma can be read either as a decimal or as a thousands separator. Use a number cell or a period for decimals.
- A product tracked by lots or serial numbers needs one on every row, except when its counted quantity is 0.
- With several companies, the file is checked against the products and locations of the company you are working in, plus those shared by all companies.
Kaitim · Odoo 18.0
Specifications
| Odoo Version | 18.0, 19.0, 20.0 |
| Tags | |
|---|---|
| Tags | |