Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Hi all,
We have an existing product with stock that is tracked via lot/serial number. This stock now has a new variant. If we add an attribute to the product the stock on hand goes to 0.
How do we move the existing stock to one of the variants and preserve the lot numbers? We could just write off stock and then adjust quantity with the new variant but not sure if this is going to cause issues with duplicate serial/lot numbers later. Also this seems kind of hacky?
Is there a better way?
If I understand correctly, you had a product with no attributes / variants and you now have created some.
I found that when you do this, the "dummy variant" record on product.product is archived but not deleted.
So, if you change the archive flag to active to "restore" this record on product.product it becomes visible again and the inventory balance and the sales history should be there. You'd need to check where it can be used.
Obviously this is also a bit "hacky". I don't think there is a right way to do this (other than creating a new product)
It's a shame but it is possible ;).
we have a template and its product A, internal ref a000, 10 qt in stock.
Over time, things change.
We need more color than a single one white color so far.
To start, we configure a single variant: color: white and you will see that the existing product product has become the white variant, ref a001, qt on hand 10, etc.
In the second step, we can add the other colors ...;)
But if we configure everything in one step, the product template has a qt of 10 but we no longer find its product product . As already said in this forum, you have to unarchive it !
Just add a new attribute (e.g. size) to your product, with one value (e.g. small), and it will update your other existing attributes values (e.g. color). So if you had only two values in the color attribute (e.g. blue, black), and suddenly you add "white", it will not update unless adding the new attribute as mentioned before. After the update is done, you can delete the "size" attribute, and automatically this data will be erased from the variants. Credit to "How to Odoo" channel in youtube.
If you have added stock to wrong variant by mistakes in the purchase order, then better option would be return the transaction from where you received the stock and reprocess it with the right products and lot/serial.
I recommend to return the products from where you received it with wrong variant and then repurchase it with right variant.
If that's not possible for you then inventory Adjustment is a good option.
Thanks Setu and Chris,
Chris has described the issue that we face. Will just write-off the existing products. Create a new product with vairants and then update the quantity and adjust the lot serial numbers. Seems like this approach will have less issues.
Yes, agree that is the simplest approach!
In my scenario i have a product with atribute material=steel,pvc (all of them black) with sales purchases and lots and now i want to add another atribbute color=black,white (now i want to add white color) so i want to have steel+black,steel+withe,pvc+black,pvc+white, but what happens whit existing variant that only have steel attribute and history of sales purchases stock and lots ... archive or delete is not an option.
Its a normal behaivor to have a product and extend it later, and now its a pain to add attribute to existing variants
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
