OdooWiki OCA HUB

Sales commissions based on product

sale_commission_product_based folder_open OCA/commission open_in_new
Sales License: AGPL-3

This module allows to have commissions based on a product or a product category.

In the commission, it will be possible to configure a set of rules that refer to a product or a product category, and a fallback percentage.

auto_awesome What this module does

AI-generated from the code · Odoo 12.0

Adds a new commission type that calculates salesperson commissions from rules set per product or product category, with a fallback percentage when no rule matches.

This module extends the sales commission feature so that commissions can be calculated based on the product sold, not just a single rate.

On a commission record you get a new type called "Based on Product with Fallback Percentage". When you pick it, two extra fields appear: a fallback percentage and a list of product rules.

Each rule links either one product or one product category (never both, and never neither) to a percentage. Rules are evaluated in order, so you can put more specific rules first. When a commission line is computed, the module looks for the first rule matching the sold product or its category; if one is found, that rule's percentage is used, otherwise the fallback percentage applies.

Products marked as commission free are skipped, as in the base commission module. The amount is calculated on the line subtotal.

Rules are managed from the commission form itself. Sales managers can create, edit and delete rules; salespeople and other internal users can only read them.

The module touches sale.commission, sale.commission.product_rule and the commission line calculation mixin.

Depends on

sale_commission
Models and fields (3)
  • sale.commission · extends an existing modelcommission_type, product_rule_ids (Product rules), product_fallback_amount (Fallback Percentage for Product)
  • sale.commission.line.mixin · extends an existing model
  • sale.commission.product_rule · new modelamount (Percentage), sequence, product_id, commission_id, product_category_id

Text generated by AI (DeepSeek) from reading the Odoo 12.0 code on GitHub; it may contain mistakes, so check the code before deciding. View the code on GitHub

Availability by version

Reviewed: 2026-11-03
Confirmed (verified in repository and branch) Estimated (unverified) No information

Confirmation status: 1 confirmed, 8 with no information of 9 versions.

Sources · Odoo 12.0

Confirmed on 2026-11-03 in branch 12.0 of OCA/commission.

terminal Installation and usage

OCA documentation · Odoo 12.0

Configuration

Source · Odoo 12.0

In order to create a commission based on products, set "Commission type" to "Based on Product with Fallback Percentage".

Configure then the "Product rules" and the "Fallback Percentage" as desired.

Each rule is evaluated based on its sequence.

A rule is matched when the product involved is the product of the rule, or has the rule's category.

The commission percentage is the "Percentage" of the matching rule, if any, or the "Fallback Percentage".

Usage

Source · Odoo 12.0
  • Create a commission having "Commission type" set to "Based on Product with Fallback Percentage", see Configuration for further details.
  • Create a sale order using that commission, see the module "Sales commissions" for the instructions on how to do that

No verified information in OCA: Installation.

info

Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.