Advanced Ecommerce Pricelist Rules
by Atharva System https://www.atharvasystem.com/odoo-development$ 27.75
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
eCommerce (website_sale)
• Website (website) • Discuss (mail) • Invoicing (account) |
| Lines of code | 149 |
| Technical Name |
website_pricelist_rules |
| License | LGPL-3 |
| Website | https://www.atharvasystem.com/odoo-development |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
eCommerce (website_sale)
• Website (website) • Discuss (mail) • Invoicing (account) |
| Lines of code | 149 |
| Technical Name |
website_pricelist_rules |
| License | LGPL-3 |
| Website | https://www.atharvasystem.com/odoo-development |
Advanced eCommerce Pricelist
Rules
Extend Odoo pricelists with powerful new pricing rules based on eCommerce Categories and Product Tags. This module enhances pricing flexibility while preserving Odoo's standard rule priority and behavior for accurate and predictable pricing.
Key
Features
Extended Rule Scopes
Apply pricelist rules based on eCommerce categories and product tags in addition to standard product and category rules.
Product Tag Pricing
Define pricing rules for specific product tags to collections, or special product groups.
eCommerce Category Rules
Create dedicated pricing rules for website product categories without affecting internal product categories.
Priority-Based Pricing
Pricing rules are evaluated using a clear priority order to ensure predictable and accurate price computation.
Seamless Integration
Fully integrated with Odoo’s standard pricelist engine, preserving default behavior and compatibility.
Safe & Upgrade-Friendly
Built using clean model extensions and overrides, ensuring stability across upgrades and customizations.
How It
Works
New Pricelist Rule Options
Step 1When creating a new pricelist rule, dedicated options for eCommerce Category and Product Tag become available in the Apply To field, allowing more precise pricing control.
Select eCommerce Category
Step 2Selecting the eCommerce Category option displays a dedicated field where you can choose the desired eCommerce category to apply the pricelist rule. A dropdown shows all available website categories such as Desks, Furnitures / Chairs, etc.
Configure Discount for eCommerce Category
Step 3Example: Apply a 10% discount to the eCommerce category Furnitures / Chairs. Select the category, choose Discount as the price type, and set the discount percentage.
Discount Applied on Website
Website ResultA 10% discount is applied to all products in the configured Furnitures / Chairs eCommerce category on the website shop. Original prices are shown as strikethrough with the discounted prices displayed.
Product-Specific Rule Priority
PriorityIf a pricelist rule is applied directly to a specific product, and that product also belongs to an eCommerce category with its own pricing rule, the product-specific rule takes priority. Here, Office Chair is set to a Fixed Price of $100.00.
Priority in Action on Website
Website ResultOn the website, the Office Chair shows the product-specific Fixed Price of $100.00, while other chairs in the same category still use the eCommerce category discount rule (e.g., Conference Chair at $29.70, Office Chair Black at $108.45).
Apply to All eCommerce Categories
ConfigurationIf you select Apply on eCommerce Category and leave the Category field empty, the rule will apply to all eCommerce categories. For example, a 10% discount on all eCommerce categories.
All Products Discounted on Website
Website ResultThe rule is applied to all products across the website shop. Every product displays the discounted price with the original price shown as strikethrough.
Product Tag Rule Setup
ConfigurationWhen the Product Tag option is selected, choose the desired product tag from the dropdown (e.g., P1, P2, P3, P4, P5). The pricelist rule will apply to all products with that tag.
Tag Rule Priority (Sequence)
PriorityPricelist rule lines are processed in order from top to bottom. Because the rule for Product Tag P4 (20% discount) appears above the rule for P3 (5% discount), it has higher priority. Therefore, when both tags are present, the P4 pricing rule will be applied.
Product Configuration: Tags & Categories
ConfigurationA product like Customizable Desk can have both Product Tags (e.g., P3, P4) and eCommerce Categories (e.g., Desks) configured in the Sales tab under the eCommerce Shop section.
Tag-Based Pricing on Website
Website ResultProducts with tags P3 and P4 show the P4 rule (20% discount) applied because P4 has higher priority (sequence) in the pricelist. Products with only tag P3 receive the 5% discount instead.
eCommerce Category vs Product Tag Priority
PriorityWhen you create a new rule for an eCommerce Category, the rule line is automatically positioned above the Product Tag rule lines because eCommerce Category has higher priority than Product Tag. Odoo applies the first matching rule from top to bottom.
eCommerce Category Rule Applied
Website ResultThe 2% discount from the eCommerce category rule is applied to the Customizable Desk instead of the product tag rule, because eCommerce Category rules have higher priority than Product Tag rules.
Formula Price Type with Product Tag
ConfigurationThe standard Odoo configuration seamlessly works with the enhanced pricelist rules. Use the Formula price type with Product Tag rules to configure Based price, Other Pricelist, Discount, Round off, Extra Fee, and Margins.
Formula Price Type with eCommerce Category
ConfigurationApply the Formula price type to an eCommerce Category rule. In this example, the Desks category has a 5% discount with a $10.00 extra fee, calculated on the Sales Price.
Calculated Price on Product Page
Website ResultThe price on the product detail page is calculated based on the configured pricelist rule. The Customizable Desk shows the discounted price with the original price displayed as strikethrough, including product variant options.
Complete Priority Order
PriorityCreated rule lines are automatically positioned according to the defined priority order. Odoo evaluates pricelist rules from top to bottom. The priority order is: Product Variants > Products > Categories > eCommerce Categories > Product Tags > All Products.
Applied Everywhere in the System
Website ResultThe configured pricelist rules are applied everywhere in the system, including the Compare page, Wishlist page, Search results, Product page, and Shop page. Prices are consistently displayed with discounts across all views.
You may
also like
Atharva System
Innovating Odoo experiences for Enterprise and Community users.
Please log in to comment on this module