Skip to Content
Menu
This question has been flagged
1 Reply
3099 Views

I am trying to find a solution how to update the price list for new added products. Each of our products have multiple product variants. All prices are set at product variant level and not product level. 

The public price is set to 0 and are managed through the price lists. 

When i create a new product + product variants, i do not find a way how to find all the product variants that are not attached to any price list. 

anyone can guide me how to find a solution. I am on V14.


Avatar
Discard
Best Answer

This is not possible in the Odoo standard. Not even in V15. There are add-ins that allow a variant update, but even these have various restrictions. Among other things, the problem is that there is a base price for variants and a variant additional price from which the total price results. So if you use the base price and the additional price, you have to have them available separately when updating, which is usually not the case.

If anyone knows a solution to the problem, I am also very interested.

Avatar
Discard

This used to work just fine. We've been on Odoo9 and can set the price of variants on the pricelists. We're now migrating to Odoo16 and it looked like this is no longer possible and has become convoluted and not intuitive at all. Looking at the model, it would appear that there's some capability to price variants as the enumeration for the column product_pricelist_item.applied_on has the following values;

('3_global', "All Products"),
('2_product_category', "Product Category"),
('1_product', "Product"),
('0_product_variant', "Product Variant"),

This very much suggests that the developers intended to allow pricing at multiple levels. Eventually, I found that it actually works well by setting the configuration as follows;

Configuration->Product Catalog: Variants = True
Configuration->Pricing: Pricelist = True, Advanced Price Rules

When you go to add a new item to a pricelist, you can select what you want to price as per the enumeration values above.

Related Posts Replies Views Activity
0
Feb 21
1265
0
Aug 15
3235
1
Dec 24
834
0
Apr 24
247
2
Jan 24
817