Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
If the requirement is only to search products with 'Supplier Product Code', then there is no need for creating any functional field. Create a related field and Include this field in Search View.
'product_code' : fields.related('seller_ids', 'product_code', string='Supplier Product Code', type='char', size=64)
I started working on that. So far I found out how to add the field showing the Supplier Code of the default Supplier but have issues making it searchable.
In /product/product.py change the function _calc_seller adding field:
'seller_product_code': main_supplier and main_supplier.product_code or False
then in the class product_product add field:
'seller_product_code': fields.function( _calc_seller, type='string',string='Supplier Reference Code',multi="seller_info"),
You can easily make it visible in the tree view. just add:
<field name="seller_product_code" string="Supplier Refference"/>
in product_product_tree_view in /product/product_view.xml
Now to search in this field is more complicated cause it is a calculated field: fields.function( _calc_seller,... Either it has to be stored (I couldn't make it work), or to provide _fnct_search (how do you do that?) Or maybe it doesn't need to be function field since the Supplier Code is already in stored in the database, but it uses function to get the code of the default supplier (the one with the most priority).
Can someone can help with this?
Hi @Branimir, I am also looking for the same kind of feature. User shall be able to search products by "Supplier Product code".
I tried your above solution. But did not work for me. Please help me if I need to do any thing more.
I am getting following error:
ProgrammingError: column product_product.seller_product_code does not exist LINE 1: ...ct."default_code",product_product."name_template",product_pr...
I could not find place to comment. So I am putting in answer block. Sorry.
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.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 6/27/13, 4:55 AM|
|Seen: 5265 times|
|Last updated: 9/24/17, 4:57 AM|