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

Post Terkait	Replies	Tampilan
Product Categories_HR product categories	0 Mar 15	3212
Product Not Showing in POS? product pos categories	4 Agu 25	2799
Difference between "Product Category" and "Categories" on the product configuration page? Diselesaikan product categories website_builder	1 Jan 25	3945
How to sort products in "Products by categories" by alphabetical ? Diselesaikan product v7 categories	4 Feb 24	12743
Limit products categories to company assigned to multi-company Odoo 12 product categories multi-company	4 Des 22	9481

Pertanyaan ini telah diberikan tanda

Menikmati diskusi? Jangan hanya membaca, ikuti!