Skip to Content
This question has been flagged
6 Replies
4497 Views
Avatar
Mike clarke

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?

Avatar
Discard
Avatar
Chris TRINGHAM
Best 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 right way to do this (other than creating a new product) 

Avatar
Discard
Avatar
Pascal Vanderperre
Best 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 longer find its product product .  As already said in this forum, you have to unarchive  it  ! 

Avatar
Discard
Avatar
Andrés Aguilar
Best 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.

Avatar
Discard
Avatar
Info
Best 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. 

 

 

Avatar
Discard
Avatar
Mike clarke
Author Best 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.

Avatar
Discard
Chris TRINGHAM

Yes, agree that is the simplest approach!

Avatar
PLASGOCAS S.L.
Best 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 pain to add attribute to existing variants

Avatar
Discard