Advanced Variant Prices v.12

The tool to configure variant prices based on attributes coefficients and surpluses

98€

The tool does not require extra dependencies beside standard Odoo apps.
Current version: 12.0.1.0.24

Enterprise
Community
Odoo.sh
In many industries product variant price strictly depends on its attribute values. Such dependency might be both cumulative (adds / subtracts some sum) and multiplicative (adds / subtracts certain percentage). This is an Odoo tool which let you quickly configure pricing in that way.

Advanced formula to calculate variant price

The tool introduces pricing formula which you influence through as a number of template attributes fields:
  • Add an extra price for any attribute value of this product template. For instance, plus 5 Euro if color of iPad is red
  • Assign a multiplier to a template attribute value: 10% extra if size of Ipad is 12.9'
  • Define independent product variant extra price. E.g. iPad 12.9' 64GB needs an extra 100 Euros in addition to attributes coefficients
  • Define values' sequence to apply coefficients priorities: firstly screen size impact, then memory, finally color.

Pricing Formula

The pricing formula is [ [(PRODUCT TEMPLATE PRICELIST PRICE + ATTRIBUTE 1 EXTRA PRICE) * (100+ATTRIBUTE 1 MULTIPLIER)/100 + ATTRIBUTE 2 EXTRA PRICE] * [100+ATTRIBUTE 2 MULTIPLIER]/100 + ATTRIBUTE 3 EXTRA PRICE ] * .... + OWN VARIANT SURPLUS

Price calculation example

  1. Your product is "Ice Cream", which sale price is $5
  2. It has 2 attributes - "Flavour" and "Mode"
  3. The flavour may be "Chocolate", "Vanilla" or "Strawberry". While the first 2 do not influence costs, the latter make you put fresh fruits. That's why you decide to make a price extra of $1
  4. You have 2 ice cream modes: "Standard" and "Premium". The latter means you are using premium milk, which costs 20% more than ordinary one. Hence, you assign 20% multiplier to this attribute
  5. Since flavour doesn't influence mode at all, you decide to order attributes as "Mode, Flavour"
  6. Then, the price of "Ice Crem, Premium, Strawberry" will be calculated as [($5 + 20%) + $1] = $7
  7. Be cautious: if you decided to order attributes in the opposite way the price of "Ice Crem, Premium, Strawberry" will be [($5 + $1) * (1+20%)] =$7,2
  8. Add a special extra for the product "Ice Cream, Premium, Strawberry" on its form - $2. Thus, the price would be $9

Screenshots

Configure price calculations on a template form

Product template base price and attributes configuration

Assign coefficients and surpluses per attribute values

Direct attribute value impact on pricing

Variant might have an own extra price beside calculations

Product variant own surplus and final advanced price

Each product variant has a unique calculated price

Results of advanced calculations

Different attributes coefficients for different product templates

An attribute value might influence price of various products in a different way. For example, red color of iPad might add 10% to the price, while the same color of a fridge would not have an impact at all. This is why the tool let you assign different coefficients and surpluses for the same attributes of different templates. Just push the button 'Configure variants' on a required product template.
The final price is calculated successively attribute by attribute: the order is important! Drag and drop lines to change sequence.

Compatibility with Odoo 12 product configurator

The tool would calculate variant price disregarding whether it actually exists. In particular, attributes with options 'never create variants' and 'create variants only when the product is added to a sales order' would influence sale price.

Screenshots

Variant price in Odoo 12 product configurator

Odoo product configurator: attributes pricing

Even 'to create' and 'never created' attributes might influence pricing

Variant optional attributes

Real-time pricing in any sale

The price is updated in real-time and is immediately visible on any product variant view. The advanced calculation would be applied in quotations, on E-shop pages, or in your point of sale.

Advanced pricing as a base for Odoo pricelists

Calculated variant price might be also amended by pricelists formulas (the option 'prices computed from formulas'). In such a way, a final product price might be further amended by a special discount or converted to another currency.

Special case: independent variant prices

Sometimes, variant prices don't have a strict correlation with template prices. In such a case there is a need to assign an own product price disregarding attributes and template core settings. The tool let you reach that goal. To configure independent price:

  • Define a template price as zero
  • Do not assign coefficients for attributes, but you may define surpluses (e.g. a product has 2 attribute values, one of which has 5 Euro extra)
  • Make an own variant surplus as a final variant price (e.g. 100 Euro)
  • The tool would calculate a final variant price as: 0 + 5 + 0 + 100 = 105 Euro. It is fully independent from a template price.

Super support team

This module is awesome, had a few minor things to fix and the dev team fixed it and update their modules within 2hours. Super service!

Alex Kronneberg in the Odoo Apps Store

Quick response, helpful team. Just what I needed.

I'm very happy for finding this module. And also the support team is very prompt. Super satisfied with customer support. Will definitely check out for more modules from this reputable company. Cheers!

Ayanga in the Odoo Apps Store

Bug reporting

In case you have faced any bugs or inconsistent behavior, do not hesitate to contact us. We guarantee to provide fixes within 60 days after the purchase, while even after this period we are strongly interested to improve our tools.

No phone number or credit card is required to contact us: only a short email sign up which does not take more than 30 seconds.

Please include in your request as many details as possible: screenshots, Odoo server logs, a full description of how to reproduce your problem, and so on. Usually, it takes a few business days to prepare a working plan for an issue (if a bug is confirmed) or provide you with guidelines on what should be done (otherwise).

Public features requests and module ideas (free development)

We are strongly motivated to improve our tools and would be grateful for any sort of feedback. In case your requirements are of public use and might be efficiently implemented, the team would include those in our to-do list.

Such a to-do list is processed on a regular basis and does not assume extra fees. Although we cannot promise deadlines and final design, it might be a good way to get desired features without investments and risks.

No phone number or credit card is required to contact us: only a short email sign up which does not take more than 30 seconds.

You may also like the tools
Cloud Storage Solutions

The technical core to synchronize your cloud storage solution with Odoo

379€
KnowSystem: Knowledge Base System

The tool to build deep and structured knowledge base for internal and external use. Knowledge System. KMS

298€ 253€
Universal Appointments and Time Reservations

The tool for time-based service management from booking appointment to sale and reviews

398€
OneDrive / SharePoint Odoo Integration

The tool to automatically synchronize Odoo attachments with OneDrive files in both ways

468€
Google Drive Odoo Integration

The tool to automatically synchronize Odoo attachments with Google Drive files in both ways

468€
Product Management Interface

The tool to search, select and mass update product templates

148€
Stocks by Locations

The tool to make inventory data essential and comfortable for elaboration

38€ 32€
Stock Demand Trends and Forecast

The tool to calculate stock demand trends and make prediction for future demand statistically. Stock Forecast

98€
Vendor Product Management

The tool to administrate vendor data about products, prices and available stocks

98€