Odoo Help


Serial number import in sales order delivery

Shivendra Thakur
on 6/19/17, 7:12 AM 638 views

Hello Greetings, 

I am using odoo v 10 community edition, I use to do bulk purchase and sales through purchase and sales modules. Since our product is unique by serial number, it takes me more time entering the serial number of each product manually during my sales and purchase.

So, please assist me if there is any way to import the serial number or any alternative way.

Thank you.

Rohit Manandhar
On 6/23/17, 7:32 AM

I have all the serial number in excel for all the purchase and sells order. I want it to import during my purchase and sells.

Like I purchase 10 product with serial number 1 to 10 and during shipment process i want serial number 1 - 10 should be imported from the excel to ERP to that purchase order.

Again during sells, I sold 5 product lets say serial number 1,3,5,7,9.During delivery process,I want to import the serial number from excel instead of entering it manually.

Thanks and Regards


Shivendra Thakur
On 6/23/17, 5:44 AM

Thanks for your response, I want to import serial number in shipment during my purchase and in delivery during the sales process before validating the purchase and sales.

Thanks and Regards,


On 6/23/17, 5:09 AM

From where do you want to import the serial number ?

If it's from another model, you can use many2one field.


I answer in here because I don't have enough karma to answer your comment.

So if I understand, during all the process of the purchase, you want to have the serial number automatically written instead of to write it for each state of the purchase ?

on 6/23/17, 6:13 AM

I want to import from cvs file to my shipment during purchase.

Shivendra Thakur
on 7/30/17, 7:25 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 6/19/17, 7:12 AM
Seen: 638 times
Last updated: 6/23/17, 7:32 AM