Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

Odoo pricelist items - apply on product subselection

Subscribe

Get notified when there's activity on this post

This question has been flagged
communitysalepricelistodoo12
1 Reply
8640 Views
Avatar
Dmitry

I'm trying to develop an addon that will allow selecting products subsection for which pricelist rule will apply (currently the rules apply only to "global", "product category", "product", "product variant"). I would like to allow setting custom rules, that will allow applying discount rules to product combinations (e.g. 1 unit of product A + 1 unit of product B - 10% discount off their prices etc.)

Does anybody know how this can be achieved?

0
Avatar
Discard
Avatar
Mohamed Elbagoury
Best Answer

No need to develop this module you can do it as the following: 

Odoo has a powerful pricelist feature to support a pricing strategy tailored to your business. A pricelist is a list of prices or price rules that Odoo searches to determine the suggested price. You can set several critarias to use a specific price: periods, min. sold quantity (meet a minimum order quantity and get a price break), etc.

As pricelists only suggest prices, they can be overridden by vendors completing sales orders. Choose your pricing strategy from Sales ‣ Settings.

Note

  • A single sale price per product : doesn’t let you adapt prices, it use default product price ;
  • Different prices per customer segment : you will set several prices per products ;
  • Advanced pricing based on formula : will let you apply discounts, margins and roundings.

Several prices per product

To apply several prices per product, select Different prices per customer segment in Sales ‣ Settings. Then open the Sales tab in the product detail form. You can settle following strategies.

Prices per customer segment

Create pricelists for your customer segments: e.g. registered, premium, etc.

The default pricelist applied to any new customer is Public Pricelist. To segment your customers, open the customer detail form and change the Sale Pricelist in the Sales & Purchases tab.

Temporary prices

Apply deals for bank holidays, etc. Enter start and end dates dates.

Tip

Make sure you have default prices set in the pricelist outside of the deals period. Otherwise you might have issues once the period over.

Prices per minimum quantity

Note

The prices order does not matter. The system is smart and applies first prices that match the order date and/or the minimal quantities.

Discounts, margins, roundings

Advanced pricing based on formula allows to set price change rules. Changes can be relative to the product list/catalog price, the product cost price, or to another pricelist. Changes are calculated via discounts or surcharges and can be forced to fit within floor (minumum margin) and ceilings (maximum margins). Prices can be rounded to the nearest cent/dollar or multiple of either (nearest 5 cents, nearest 10 dollars).

Once installed go to Sales ‣ Configuration ‣ Pricelists (or Website Admin ‣ Catalog ‣ Pricelists if you use e-Commerce).

Each pricelist item can be associated to either all products, to a product internal category (set of products) or to a specific product. Like in second option, you can set dates and minimum quantities.

Note

  • Once again the system is smart. If a rule is set for a particular item and another one for its category, Odoo will take the rule of the item.
  • Make sure at least one pricelist item covers all your products.

There are 3 modes of computation: fix price, discount & formula.

Here are different price settings made possible thanks to formulas.

Discounts with roundings

e.g. 20% discounts with prices rounded up to 9.99.

Costs with markups (retail)

e.g. sale price = 2*cost (100% markup) with $5 of minimal margin.

Prices per country

Pricelists can be set by countries group. Any new customer recorded in Odoo gets a default pricelist, i.e. the first one in the list matching the country. In case no country is set for the customer, Odoo takes the first pricelist without any country group.

The default pricelist can be replaced when creating a sales order.

Tip

You can change the pricelists sequence by drag & drop in list view.

Compute and show discount % to customers

In case of discount, you can show the public price and the computed discount % on printed sales orders and in your eCommerce catalog. To do so:

  • Check Allow discounts on sales order lines in Sales ‣ Configuration ‣ Settings ‣ Quotations & Sales ‣ Discounts.
  • Apply the option in the pricelist setup form.
 
5
Avatar
Discard
Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up
Related Posts Replies Views Activity
how to allow only manager to edit the form which is in approved state. odoo12 Solved
community odoo12
Avatar
Avatar
1
Sep 21
4690
Error in odoo12 community Solved
community odoo12
Avatar
Avatar
1
Mar 19
9343
How to have a primary price list that applies to everyone that hasn't any other price list added?
ecommerce pricelist odoo12
Avatar
0
Nov 20
2735
Is there any possibility to manage salary deferment in Odoo Payroll?
community payroll odoo12
Avatar
0
May 20
3090
How to display two views (tree, form) on the same page [Odoo v12 CE]?
community views odoo12
Avatar
Avatar
Avatar
5
Feb 20
8091
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now