Change Sales Price of all variant based on adding or remove any Values on Attributes and Variants page on Product Template

[aashutosh1710]

module: product_variant_sale_price
version: 18.0

Steps to reproduce

• Create one Product which having 4 or 5 Variant.
• Change the Sales Price on the each Variants as per module functionality.
• Now add or remove any Values on Attributes and Variants page on Product Template.

Current behavior

• Override the Sales Price of all variant which we set variant specific and set same Sales Price on all the Variants.
• Change Sales Price of all variant based on adding or remove any Values on Attributes and Variants page on Product Template.

Expected behavior

• Custom set Sales Price did not requires to be override when adding or remove any Values on Attributes and Variants page on Product Template.

Example

• Create one Product with Name as "Test Product 1", Sales Price as 33 $ and having Attributes and Variants as Color : Red, Green and Size : M, XL.
  So 4 variants are created each with 33$ as Sales Price
• Change Sales Price of Variant RED, M to 44$, RED, XL to 55$, Green, M to 66$, Green, XL to 77$.
  So now each variant has a Different Sales Price as per this module functionality.
• Go to Product Template > Attributes and Variants page > Adding New variant Color : Blue or same way Remove any variant like Color : Red and save it.
• Go to all Product Variants related to "Test Product 1",
  Notice that all custom set price like Green, M to 66$, Green, XL to 77$ override with common price same as 33 $ of Product Template.

[talhailyas2680]

When user add or remove an attribute or attribute value on a product template, Odoo automatically updates the variant combinations. This process involves:

Recalculating all possible combinations based on the current set of attributes and values.
Deleting old variants that no longer match the updated combinations.
Creating new variants for all valid combinations, including any new ones generated by the added attribute or value.

Because of this behavior, the previously set custom sale prices on the old variants are lost, and the newly created variants inherit the template’s default list_price.

This is not a bug in the module — it is how Odoo manages variant creation. Each time the variant combinations change, the system treats new variants as completely new records, and there is no automatic way to preserve the old prices for these newly generated variants.

In short: adding/removing attributes or values always triggers variant recreation, so any custom prices set on old variants cannot be retained automatically.

[diggy128]

This is a very problematic behavior when you have different fixed prices per variant.

Has anyone found a way to stop this?

We also have variant images deleted as well (which is expected as the variants are deleted and recreated).

[diggy128]

This is a very problematic behavior when you have different fixed prices per variant.

Has anyone found a way to stop this?

We also have variant images deleted as well (which is expected as the variants are deleted and recreated).

If anyone needs it:
REMOVE (from product_template):
def _create_variant_ids(self): res = super()._create_variant_ids() for tmpl in self: tmpl.product_variant_ids.with_context(skip_update_fix_price=True).write( {"fix_price": tmpl.list_price} ) return res