It sometimes happens that the selling price including VAT of a product has no direct relationship with the price excluding VAT. Similarly, the selling price of different variants of the same product may be different and result from various combinations.
I suggest creating the following fields:
- retail_price : on the model of the list_price field, this price will be a price including tax and will serve as the base price during a sale with a price list including tax.
- markup_price : supplement that will be added to the template price (list_price or retail_price depending on the selected price list) of the item to give the base price of the variant.
The base price of a variant before the application of the tariff will be:
if a Tax Included Price List is selected:
- base_price = product.template.retail_price + product.product.markup_price
if a Tax Excluded Price List is selected :
- base_price = product.template.list_price + product.product.markup_price
Addition of 2 modules to keep independence and not to impose the presence of fields in the product sheet :
For adding and managing the 2 respective fields.