Internal Reference Part Code Database

Question

Hello, I am looking for a solution to manage our internal part codes.

We are implementing a system using a sequential 6 digit part code.... 000001, 000002 ........ 999999

We wish to be able to upload a csv/excel file of products, and for the system to read the database and assign the next available sequential # to the list of products.

For example, imagine 000001 to 009847 have already been assigned. We upload a CSV with 100 lines and we want the system to auto assign numbers 009848 to 009947

Niyas Raphy (Walnut Software Solutions) · Answer

Hi,
This can be done from code or from the user interface using the Sequence in Odoo. For generating automatic sequence number from the code, see this: How to Add New Sequence in odoo [1]

For Doing it from the user interface, see this : Assign Sequential Value For Field Using Automated Action And Sequence [2]

Thanks

[1] https://www.youtube.com/watch?v=ZfKzmfiqeg0
[2] https://www.youtube.com/watch?v=Cz5eM5FDmTE

This question has been flagged

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