How to Fix Sale Price for Variant Values in Odoo 18 (Ent)
In Odoo 18, managing product variants and their associated pricing can be a challenge for businesses with complex product catalogs. A common need is to "Fix Sale Price" for variant values, meaning setting specific prices for different product variants (like size, color, etc.) without allowing automatic price adjustments based on certain rules or configurations.
This blog will walk you through how to achieve this functionality in Odoo 18 with clear, actionable steps.
1. Introduction to Product Variants in Odoo
In Odoo, a product variant refers to a specific version of a product, such as different sizes, colors, or other attributes that vary within the same product category. For instance, a t-shirt may come in different sizes (S, M, L) and colors (Red, Blue, Green). Each of these combinations creates a variant of the base product.
Variants are a key feature of Odoo’s product management, but pricing these variants can be tricky if you're aiming to set fixed prices for each variation.
2. Why Fix Sale Prices for Variants?
Fixing the sale price for specific variants is useful when:
You want to ensure the price for certain variants doesn’t change due to rules, discounts, or automatic price adjustments.
You need to manage pricing for custom products where each variant has a unique cost structure.
You wish to have better control over how prices are calculated per variant rather than relying on global pricing rules or formulas.
3. Step-by-Step Guide to Fix Sale Price for Variant Values
Here’s how you can set fixed prices for product variants in Odoo 18.
3.1. Setting up Product Variants
Before you can set prices for variants, you need to have product variants created.
Go to the Products module:
Navigate to the Sales or Inventory module in Odoo.
Create a new product:
Click on the Products menu, then select Create.
Fill in the necessary details for your product (like name, category, etc.).
Enable Variants:
In the Product Type section, choose Storable Product (or Consumable if necessary).
In the Variants tab, check the options under Attributes. For example, if you want to add size and color as variants, create attributes for both.
Create an Attribute (e.g., Size, Color).
Under each attribute, create possible values (e.g., for Size: S, M, L; for Color: Red, Blue, Green).
Save the Product.
3.2. Enabling the "Fixed Price" Option for Variants
Once you've set up your product variants, the next step is to enable the feature that lets you fix prices for specific variants.
Navigate to the "Variant Pricing" Section:
After creating your product with variants, go to the Variants tab in the product details page.
Activate "Fixed Price" for Variants:
In the Sales section, you will find the option to adjust the Sale Price for each individual variant.
To fix the price, click on the Edit button next to each variant and manually set the desired sale price.
Disable Automated Price Rules:
Make sure any automated pricing rules (such as price lists or discounts) are either deactivated or configured in a way that doesn’t interfere with the fixed price for the variants.
3.3. Editing the Sale Price for Each Variant
After enabling the fixed price option for each variant, you need to manually set the sale price.
Set Price for Variants:
Under each variant, click Edit, then set the fixed sale price for that specific variant.
You can also set Cost Price if necessary for internal purposes, but the Sale Price will be the fixed price for customers.
Save Changes:
Once you’ve set the price for each variant, be sure to Save the changes.
3.4. Testing the Changes
Create a Sales Order:
Go to the Sales module and create a new Sales Order.
Select the product with variants, and the available variants should show up.
Check Variant Prices:
When selecting different variants, ensure the fixed price is correctly reflected for each variant. Prices should now be locked and won't change based on any pricing rules or adjustments.
Confirm the Invoice:
Once you confirm the sales order, proceed with the invoicing process to ensure that the fixed prices are maintained throughout.
4. Tips for Managing Prices for Multiple Variants
Bulk Price Updates: If you need to change the price of variants in bulk, you can export the product variants to Excel, make your price adjustments, and then import the updated prices back into Odoo.
Use Pricelists for Discounting: While the sale price is fixed for variants, you can still use pricelists to offer specific discounts for different customers or customer groups.
Use Odoo Apps for Advanced Pricing: If you need more complex pricing rules, consider using Odoo apps like "Pricelist" or third-party modules available in the Odoo App Store.
Conclusion
Setting fixed sale prices for variants in Odoo 18 is a straightforward process that allows you to gain better control over your pricing structure. By following the steps outlined above, you can ensure that each product variant is priced exactly as you intend, free from external price adjustments or automated rules. This is particularly useful for businesses with customized products or those offering a wide range of variant combinations.
By mastering variant pricing in Odoo 18, you can enhance the efficiency of your sales process and offer transparent pricing to your customers.