I encountered the following issue when importing inventory into Odoo 18:
- Tried directly importing product, location, batch number, and quantity (this method will add to the existing on-hand quantity at the same location).
- Directly export the rows of physical inventory and check "Need to update data" (this method will prompt that quantitative editing is restricted; clear the fields and keep only the external ID and counted quantity to import successfully.)
Situation 1:

Case 2:

The purpose is to update the inventory of the original product's corresponding location and batch number, but this quantitative constraint was found during import.