Odoo Help

Welcome!

This community 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.

0

How to add multiple products on single click in an order lines of Po/So order forms in openerp?

By
divya
on 11/11/14, 5:15 AM 1,943 views

Here in this screen shot products are adding one by one in orderlines by Add an item.

But, i want to import mutiple products at a time.

Hi Divya, as per my understanding i hope you are looking for Product Bundling kind of functionality.Kindly please let me know if my understanding is correct so that I can expedite the same.

Nilim
on 2/10/16, 9:58 AM
0
Dhananjay
On 2/8/16, 2:09 AM

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?

0
shashank verma
On 11/11/14, 5:45 AM

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.
 

Add Product one by one (one2many) is the best way because each sale Line product have different quantity, unit Price.

Prakash
on 11/11/14, 5:52 AM

But if we want to import 100 products at time, it is difficult way to form one by one. Is there any alternative way for it?

divya
on 11/11/14, 6:19 AM

yes the default structure of orderline is one2many @shashank, But changing it to many to many field will effect to any other forms in application?

divya
on 11/11/14, 6:22 AM

Openerp using Import options csv file data import. Refer http://www.slideshare.net/Audaxis/opendays-import-csv-2013v5

Prakash
on 11/11/14, 6:40 AM

@divya: If you are replacing o2m field by m2m field then it will effect other application. Because some of the modules might be refering to order_line(o2m field in sale_order class)

shashank verma
on 11/11/14, 8:22 AM
0

Hi Guys,

I Don't think converting o2m order lines field to a m2m or making the field product which is of m2o to an m2m. Here in the first case i don't think requirement will be acheived and comming to second case one orderline will have n number of products which doesn't seem to be correct.

Instead what i would prefer is to

Create a wizard which will pop up with a button click on form view and it will show the list of all products where you can select all the required products(Multiple products at once) and clicking on submit button in wizard will create an individual orderline in current order for every product selected.

This procedure is little bit lengthy, but i hope this will help you to acheive your requirement without disturbing the actual process or default modules.

Cheers

Kiran Kumar

0
divya
On 11/11/14, 6:29 AM

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

'm2m_prod': fields.many2many('product.product', 'm2m_table', 'order_lineid', 'product_id', 'M2M products'), Use this defination in sale_order_line class

shashank verma
on 11/11/14, 8:18 AM

Thanks @shashank

divya
on 11/11/14, 11:57 PM

Hi Shashank, I don't know if you'd reply or not, but can you please help me on this?

I am on Odoo v9, and can't change sale.order line to many2many from GUI. And nothing happens when I use the codes above in Technical> Views.

Kindly help me with this. Let me know how I can do it in Odoo v9 ?

Thanks.

Hamza rana
on 6/17/16, 5:47 PM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)

Stats

Asked: 11/11/14, 5:15 AM
Seen: 1943 times
Last updated: 2/8/16, 2:09 AM