Skip to Content

Odoo for Trade Promotions and Distributor Scheme Management

June 13, 2026 by
Odoo for Trade Promotions and Distributor Scheme Management
Pearl Solutions

Trade promotions are among the largest line items in an FMCG company's P&L and among the worst-tracked. Volume discounts, off-invoice allowances, free goods schemes, distributor rebates, and retailer-facing trade marketing budgets collectively represent 15–25% of gross revenue in many consumer goods businesses. Yet the majority of mid-size FMCG companies track all of this in a combination of Excel files, sales team WhatsApp messages, and verbal agreements with distributors that no one has documented properly.

The result is predictable: schemes applied inconsistently, credit notes issued without verification, rebates claimed by distributors that the brand has no record of authorizing, and a trade marketing budget that cannot be connected to any measurable volume outcome.

This post covers how Odoo structures trade promotion management for FMCG companies from scheme design through application to post promotion analysis and what it takes to move from ad hoc scheme management to a controlled, measurable trade marketing function.

Types of FMCG Trade Promotions and How Odoo Handles Each

1. Volume Discounts (Quantity Based Off Invoice)

The most common trade promotion structure: buy a certain quantity of a product or category, receive a percentage discount off the invoice price. Odoo's pricelist engine handles this natively through quantity-break pricing rules:

Quantity Ordered (cases)Discount on Standard PriceEffective Price (example)
1–110%PKR 1,200 / case
12–235%PKR 1,140 / case
24–478%PKR 1,104 / case
48+12%PKR 1,056 / case

When a sales order is created, Odoo checks the quantity and applies the correct price automatically. There is no manual calculation, no chance of a salesperson applying the wrong tier, and no dispute with the distributor about which price should have been applied the system applies the same rules every time.

2. Free Goods Schemes (Buy X & Get Y)

Free goods schemes are a common FMCG tool buy 12 cases of product A, receive 1 case free; or buy a mixed assortment above a value threshold, receive a complimentary item. These are configured in Odoo as promotional programs:

Trigger condition: minimum quantity, minimum value, specific product combination, or customer group

Reward: free product quantity (same SKU or a different promotional SKU), fixed discount, or percentage discount

Validity period: scheme start and end dates enforced automatically

Customer eligibility: all customers, specific pricelists, or named distributors

When the trigger condition is met on a sales order, Odoo adds the free goods line automatically. The salesperson cannot forget to apply the scheme. The distributor receives what was agreed without needing to chase for a credit note after the fact.

Critically, the cost of the free goods is tracked separately. After the scheme period, the trade marketing team can calculate: how much free stock was given out (at cost), and what volume was generated by the scheme enabling a return on promotion calculation.

3. Distributor Rebates (End of Period Settlements)

Rebate schemes pay distributors a retrospective incentive based on total purchases over a period typically monthly or quarterly. A distributor who achieves PKR 5 million in monthly purchases might receive a 2% rebate settled at period end. These are sometimes called total business discounts or growth incentives.

Odoo handles rebates through its rebate programs feature (available in Odoo 16+). Rebate rules are configured by:

Customer group or named distributor

Achievement threshold (minimum purchase amount or quantity)

Rebate rate (percentage of qualifying purchases)

Settlement method: credit note, product credit, or cash

Validity period: typically monthly, quarterly, or annual

At period end, Odoo calculates the rebate owed to each qualifying distributor, generates a draft credit note for review, and posts it after approval. The distributor's account is credited automatically. No manual Excel calculation of each distributor's total purchases against their rebate ladder.

The rebate dispute problem, solved: A distributor claims they are owed a 3% quarterly rebate and submits their own calculation. Without Odoo, the brand owner must manually verify this against sales invoices a process that often ends in a negotiated settlement because neither party trusts the other's figures. With Odoo, the system's calculation is based on posted invoices. If the distributor's figure differs, the discrepancy can be traced to a specific invoice. Disputes are resolved with data, not negotiation.

4. Cash Discounts for Early Payment

Credit terms for distributors in Pakistan commonly include a cash discount for early payment for example, net 30 terms with a 2% discount if paid within 7 days. Odoo handles this through payment term configurations:

Payment terms defined with early payment discount percentage and qualifying window

Applied automatically to invoices for distributors on those terms

If payment is received within the window, the discount is applied at reconciliation

If payment is late, the full invoice amount is settled

The resulting credit note for the discount is generated automatically at reconciliation no manual entry required.

5. Modern Trade Promotional Fees and In-Store Investment

Supplying hypermarkets and chain stores in Pakistan typically involves paid promotional slots listing fees, shelf highlight fees, display gondola fees, and promotional pricing agreements. These are costs to the brand, not revenue but they need to be tracked against the volume they generate.

In Odoo, these are recorded as vendor bills (the brand paying the retailer) with a dedicated expense account for trade investment. Sales during the promotion period are trackable against the same customer and period. The result: a cost per case sold calculation for modern trade promotional spend.

Scheme Design and Approval Workflow

In many FMCG companies, trade schemes are proposed by the sales team and approved verbally by a manager with no formal record until the invoice discrepancy is noticed in accounts. Odoo can be configured with a scheme approval workflow:

  1. Sales manager proposes a new pricelist or promotional program in Odoo with defined parameters
  2. Commercial or finance director reviews and approves the program is published to the system
  3. Sales team creates orders scheme is applied automatically to qualifying orders
  4. Scheme expires on the configured end date no extensions without a new approval cycle

This replaces the informal we gave them a good deal this month conversation with a documented, time bounded, cost quantified agreement.

Measuring Trade Promotion ROI

The most important capability most FMCG companies do not have is post promotion analysis: did the scheme actually drive incremental volume, and at what cost?

In Odoo, the data required for this analysis is captured automatically:

Promotional sales volume: Total invoiced quantity during the scheme period, by product and customer group

Discount cost: Total discount given (the difference between standard price and invoiced price)

Free goods cost: Quantity of free product issued, valued at production cost

Comparison period: Same SKU, same customer group, preceding period (before the scheme)

From this data, the trade marketing team can calculate:

Incremental volume vs. baseline period

Total trade investment (discounts + free goods cost)

Cost per incremental case

Whether the scheme pulled forward demand (a volume spike followed by a trough) or generated genuine growth

ROI measurement in practice: Your Ramadan trade scheme ran through April a 10% off-invoice discount on all biscuit SKUs and a buy 12 get 1 scheme on a specific product line. Odoo shows: total discount cost PKR 480,000; total free goods cost PKR 95,000; total promotional spend PKR 575,000. Biscuit volume in April was 18,400 cases vs March baseline of 12,100 an incremental 6,300 cases. Cost per incremental case: PKR 91. The trade marketing team compares this to the gross margin contribution of each incremental case to determine if the scheme was profitable.

Scheme Communication and Distributor Visibility

A common failure mode in trade promotion is the scheme that the sales team is aware of but distributors never received clearly. Distributors place orders at the old price, the scheme is applied inconsistently, and disputes arise at invoice reconciliation.

Odoo's customer portal allows distributors to log in and see their current pricelist and applicable promotions. When a distributor creates or reviews a quotation in the portal, they can see the price they will receive including any active scheme discount. This eliminates "I didn't know about the scheme" disputes and ensures distributors are buying with full pricing visibility.

Promotional Stock Allocation and Forecast Impact

A well designed trade scheme drives a volume spike which must be anticipated in production and inventory planning. If a 15% volume uplift is expected during a scheme period but the production plan was set to baseline, the result is stockouts during the peak demand period defeating the purpose of the scheme.

In Odoo, the manufacturing planner can model the expected volume uplift from a scheme and adjust the production schedule accordingly. The scheme dates, eligible products, and expected volume multiplier are inputs to a demand plan that feeds the master production schedule. This connects the commercial decision (running a scheme) to the operational plan (what to produce and when).

Preventing Scheme Abuse

Trade scheme abuse distributors placing large scheme-period orders and then returning or holding excess stock is a persistent problem in FMCG. Odoo provides several controls:

Credit limit enforcement: Large scheme orders that exceed a distributor's credit limit are blocked or flagged for approval preventing a distributor from over-ordering on credit and returning the stock after the scheme

Return link to original delivery: Returns must reference the original invoice and delivery order a return of scheme period stock is visible as such in the distributor's account history

Scheme-period purchase history: The system records whether a distributor's scheme period purchasing significantly exceeded their historical baseline a signal of buy in bulk return later behaviour.

What Good Trade Promotion Management Looks Like

For FMCG companies that have moved from ad hoc to structured trade promotion management, the operational difference is significant:

Before ERPWith Odoo
Scheme approved verbally, applied inconsistentlyScheme configured in system, applied automatically on every qualifying order
Free goods issued at salesperson discretionFree goods generated by system rule documented and costed
Rebate calculations done in Excel, disputed by distributorsRebate calculated from posted invoices traceable to individual transactions
Trade spend tracked as a single overhead lineTrade spend attributed by scheme, product, and customer ROI calculable
Scheme end date enforced by reminding sales teamScheme end date enforced by system discounts not applied after expiry
Volume spike not anticipated in production planScheme volume uplift modelled into production forecast

For FMCG companies where trade promotion cost is 15–25% of gross revenue, moving from ad hoc to structured scheme management is one of the highest-return operational improvements available. The investment in an ERP that manages this properly pays back not just in operational efficiency, but in commercial control knowing exactly what you are spending on trade, what it is buying you, and where the leakage is.

Share this post

Our latest content

Check out what's new in our company !

Your Dynamic Snippet will be displayed here... This message is displayed because you did not provide both a filter and a template to use.
Tags
Archive