跳至内容
  1. All products
  2. Python Formula for Dynamic Prices in Subscriptions
  3. All products
价格表: FWA-FR_Public Pricelist EUR 价格表
价格表: FWA-FR_Public Pricelist EUR 价格表
Python Formula for Dynamic Prices in Subscriptions

Python Formula for Dynamic Prices in Subscriptions

Compute order line prices dynamically using Python formulas defined in pricelists
85.91 € 85.91 € （不含税）
US$ 100.00 （不含税）

  • Versions
加入购物车
条款及条件细则
30 天退款保证
送货：2 至 3 个工作天
联系我们
Versions: V19

ODOO'S FUNCTION

By default, Odoo supports subscription pricing through pricelists with fixed prices, percentage discounts, or basic formula-based rules. However, it does not support custom pricing logic or automatic price updates based on external data sources.

CLUEDOO'S FUNCTION

CLuedoo extends Odoo's subscription pricing by allowing Python formulas to be defined directly in pricelists. This enables automatic price recomputation at the end of each billing period - ensuring subscription prices always reflect the latest formula without any manual intervention.

CONFIGURATION

1.

Go to Subscriptions > Products > Pricelists, open or create a pricelist > Under the Recurring Prices tab, add a line  to open Recurring Pricing and select Python Formula as the Price Type, then write your formula in the script box.














Example: result = 320 means the unit price will be $320 for every billing period.

2. 

Go to Subscriptions > Configuration > Recurring Plan > Open or create a new one > Enable Auto Update Price (Formula) checkbox. If checked, the system will automatically recalculate the price based on the python formula at the end 

USAGE

1.

Create a new Subscriptions Order using the recurring plan and pricelist you just configured > The formula is automatically inherited by each Order Line

At this point, the unit price still shows the original value. The formula is ready but not yet applied.

Before using Calculate Price button
2.

Hit the Calculate Price button at the top of the Sales Order > The system instantly recomputes the unit price for all lines based on their formula.


After using Calculate Price button

3. 

Change the Python Formula


For example, I change  the formula from result = 320 to result = 444

4.

The system runs a daily scheduled action - "Subscription: Auto Update Price on Anniversary" - that automatically triggers Calculate Price for all subscriptions whose current billing period ends today.

You can also trigger it manually anytime via Run Manually button.


5.

Back to the Subscription Order, once the price has been recalculated, a notification appears in the subscription's chatter:

The Order Line is updated accordingly with the new unit price.

Note: 

  • You can edit the formula directly on the Sales Order Line - the system will use the line's formula when calculating, not the pricelist's.
  • Prices are not updated automatically - you need to click Calculate Price each time you want to recompute.