how to list products in sale order respective to selected product categories?

Question

Hi all,
Here i tried the following,
1.add a dropdown field for product category in sale oder line.
2.in that sale order line list the products respective to selected product category.
Please suggest any ideas
Thanks in advance.

Cybrosys Techno Solutions Pvt.Ltd · Accepted Answer

Hi,
you can use this method. you have to do things in the sale order line then you must inherit sale.order.line.
class SaleOrderLineExt(models.Model):
_inherit = 'sale.order.line'
categ_id = fields.Many2one('product.category')
@api.onchange('categ_id')
def _onchange_categ(self):
return {'domain': {'product_id': [('categ_id', '=', self.categ_id.id)]}  I think this will help you, don't forget to add this category field in the UI.
Regard,

Krupesh Laiya · Answer

Make onchange for the product category.
select category then search product ids on the basis of category_id pass the domain of product ids in return result of onchange hope this will help you.

kazi sidou · Answer

Is this code coorect  :
@api.onchange('x_product_categories')
def _show_list_of_products(self):
for order in self:
selected_category_id = order.x_product_categories
product_id = fields.One2many('product.product' , domain=['category_id', '=','selected_category_id'])

Bài viết liên quan	Trả lời	Lượt xem
Product Categories_HR product categories	0 thg 3 15	3096
Product Not Showing in POS? product pos categories	4 thg 8 25	2391
Difference between "Product Category" and "Categories" on the product configuration page? Đã xử lý product categories website_builder	1 thg 1 25	3672
How to sort products in "Products by categories" by alphabetical ? Đã xử lý product v7 categories	4 thg 2 24	12601
Limit products categories to company assigned to multi-company Odoo 12 product categories multi-company	4 thg 12 22	9338

Câu hỏi này đã bị gắn cờ

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!