I am implementing Odoo for my auto parts store and my products have many part numbers from different manufacturers and suppliers
I need to add a custom field to the product model that will allow me to capture these part numbers. Each product may have many part numbers to be captured
For example, I have a product with internal reference number ALTR00001. This product has cross reference numbers 0124325001 and ALT3260
I would need to add a field that can store these values, linked to the product and be searchable by adding it into the search filters so that I can quickly find products by their cross reference numbers when creating quotes and sales orders
Using advanced search is not a good option as its way too slow and cumbersome
Can anyone help?