Hello,

You should change product_id in sale.order.line from many2one to many2many.

But if you change priduct_id many fields in order_line(in sale.order) are depending on it(like description,price etc). you should change them too.

Hope this helps

Be cauitious: Making the product fields as m2m would break Odoo logic totally (procurement, invoicing etc.)

For sale orders we developed this app  - https://apps.odoo.com/apps/modules/10.0/product_selection_wizard_sale/- may help you. It let search products and then add them at once (but different lines). For purchases a similar app with same core is going for a release. It is a payable module, regretfullu

Hello Divya,

For the same requirement I changed order_line field to many2many.

#'order_line': fields.many2many('sale.order.line', 'order_id', 'Order Lines', readonly=True, states={'draft': [('readonly', False)], 'sent': [('readonly', False)]}, copy=True),

After that it lists all order lines.

As suggested by shahshank added following line in sale_order_line class

'm2m_prod': fields.many2many('product.product', 'm2m_table', 'order_lineid', 'product_id', 'M2M products'),

But still it lists all order lines.

do we have to modify sale_view.py also?

when creating many to many field for order lines , It is showing the list of existing order lines but it must show existing products.

Hello Divya,

Default structure of orderline is one2many . Good choice would be to use many2many structure where u can add muliple product and then you can design your business logic according to many2many flow.