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

Publications associées	Réponses	Vues
Product Categories_HR product categories	0 mars 15	3092
Product Not Showing in POS? product pos categories	4 août 25	2344
Difference between "Product Category" and "Categories" on the product configuration page? Résolu product categories website_builder	1 janv. 25	3652
How to sort products in "Products by categories" by alphabetical ? Résolu product v7 categories	4 févr. 24	12596
Limit products categories to company assigned to multi-company Odoo 12 product categories multi-company	4 déc. 22	9330

Cette question a été signalée

Vous appréciez la discussion ? Ne vous contentez pas de lire, rejoignez-nous !