Add variant to existing product with stock & lot numbers - How to move stock?

Question

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?

Chris TRINGHAM · Accepted Answer

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 r

Pascal Vanderperre · Answer

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

Andrés Aguilar · Answer

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.

Info · Answer

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.

Mike clarke · Answer

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.

PLASGOCAS S.L. · Answer

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 p

Această întrebare a fost marcată

Enjoying the discussion? Don't just read, join in!