Hi everyone,

I'm currently using Odoo 18 to manage a store with many products that have multiple variants (size, color, etc.), and updating the stock count manually has become quite time-consuming. I have to go add each product variants one by one to update stock levels.

I’ve tried adding stock counts of each variants through an Excel file, but when I do, it adds the product as a new item rather than updating the stock for existing variants. To be able to update the stocks, I need to add the variants under the "Update Quantity" option one by one, which is very tedious.

Does anyone know of an easier or more efficient way to upload or update stock counts for products with many variants in Odoo 18?

Any advice or recommendations would be greatly appreciated! Thanks in advance.


Attached is screenshot if it helps understanding my enquiries:
https://drive.google.com/file/d/17MYH8iSZOwE74l2I3pYQegc8TbDLKSmM/view?usp=sharing