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'])

Related Posts	Replies	Zobrazenia
Product Categories_HR product categories	0 mar 15	3081
Product Not Showing in POS? product pos categories	4 aug 25	2289
Difference between "Product Category" and "Categories" on the product configuration page? Solved product categories website_builder	1 jan 25	3601
How to sort products in "Products by categories" by alphabetical ? Solved product v7 categories	4 feb 24	12578
Limit products categories to company assigned to multi-company Odoo 12 product categories multi-company	4 dec 22	9308

This question has been flagged

Enjoying the discussion? Don't just read, join in!