product.pricelist.item: fields, relations and API
The product.pricelist.item model ("Pricelist Rule") is a persistent model declared by the Products & Pricelists module, then extended by 4 other modules. It exposes 35 fields, 29 of them declared directly on the model; 1 field from other models points to it. Below you will find every field with its technical name, type, label and relations, followed by an Odoo 20 JSON-2 API call.
Model identity
- Technical name
product.pricelist.item- Label
- Pricelist Rule
- Type
- Persistent (models.Model)
- SQL table
product_pricelist_item- Origin module
- Products & Pricelists (
product) - Extended by
- sale, point_of_sale, website_sale, website_event_sale
- Default order (_order)
applied_on, min_quantity desc, categ_id desc, id desc- Inherits from (mixins)
- pos.load.mixin
Model fields
29 own fields, 0 inherited from mixins and 6 automatic ORM fields. Click a name to get a direct link to that field.
35 of 35 fields shown
| Technical name | Label | Type | Details |
|---|---|---|---|
| allowed_uom_ids | Allowed Uom | many2many→ uom.uom | computed |
| applied_on | Apply On Pricelist Item applicable on selected option | selection | requiredcomputed, stored Values: |
| base | Based on Base price for computation. Sales Price: The base price will be the Sales Price. Cost Price: The base price will be the cost price. Other Pricelist: Computation of the base price based on another Pricelist. | selection | required Values: |
| base_pricelist_id | Other Pricelist | many2one | |
| categ_id | Category Specify a product category if this rule only applies to products belonging to this category or its children categories. Keep empty otherwise. | many2one | |
| company_id | Company | many2one | computed, stored |
| compute_price | Compute Price How the price is derived from the base price. Discount: a percentage taken off it. Surcharge: a percentage added on top of it. Fixed Price: a set amount, ignoring the base price entirely. Activate the discount settings to show the discount to the customer. | selection | required Values: |
| currency_id | Currency | many2one | computed, stored |
| date_end | End Date Ending datetime for the pricelist item validation The displayed value depends on the timezone set in your preferences. | datetime | |
| date_start | Start Date Starting datetime for the pricelist item validation The displayed value depends on the timezone set in your preferences. | datetime | |
| fixed_price | Fixed Price | float | |
| is_plain_discount | Plain Discount Whether the rule lowers the price by exactly its discount percentage. | boolean | computed |
| is_pricelist_required | Is Pricelist Required | boolean | computed |
| min_quantity | Min. Quantity For the rule to apply, bought/sold quantity must be greater than or equal to the minimum quantity specified in this field. Expressed in the default unit of measure of the product. | float | |
| name | Name Explicit rule name for this pricelist line. | char | computed |
| price | Price Explicit rule name for this pricelist line. | char | computed |
| price_discount | Price Discount | float | |
| price_markup | Surcharge | float | computed |
| price_max_margin | Max. Price Margin Specify the maximum amount of margin over the base price. | float | |
| price_min_margin | Min. Price Margin Specify the minimum amount of margin over the base price. | float | |
| price_round | Price Rounding Sets the price so that it is a multiple of this value. Rounding is applied after the discount and before the surcharge. To have prices that end in 9.99, round off to 10.00 and set an extra at -0.01 | float | |
| price_surcharge | Extra Fee Specify the fixed amount to add or subtract (if negative) to the amount calculated with the discount. | float | |
| pricelist_id | Pricelist | many2one | |
| product_id | Variant Specify a product if this rule only applies to one product. Keep empty otherwise. | many2one | |
| product_tmpl_id | Product Specify a template if this rule only applies to one product template. Keep empty otherwise. | many2one | |
| product_uom_name | Product Uom Name | char | related: |
| product_variant_count | Product Variant Count | integer | related: |
| rule_tip | Rule Tip | char | computed |
| uom_id | Packaging | many2one→ uom.uom | |
| create_date | Created on | datetime | read-onlyautomatic |
| create_uid | Created by | many2one | read-onlyautomatic |
| display_name | Display Name | char | read-onlycomputedautomatic |
| id | ID | integer | read-onlyautomatic |
| write_date | Last Updated on | datetime | read-onlyautomatic |
| write_uid | Last Updated by | many2one | read-onlyautomatic |
Relations
Models linked from this model
- product.category: categ_id
- product.pricelist: base_pricelist_id, pricelist_id
- product.product: product_id
- product.template: product_tmpl_id
- res.company: company_id
- res.currency: currency_id
- uom.uom: allowed_uom_ids, uom_id
Fields of other models pointing here
- sale.order.line: pricelist_item_id
Reading this model through the API
Odoo 20 JSON-2 API call reading the first five records with real fields of the model. Replace the instance, database and API key with your own.
curl -X POST "https://your-instance.odoo.com/json/2/product.pricelist.item/search_read" \
-H "Authorization: bearer $ODOO_API_KEY" \
-H "X-Odoo-Database: your-db" \
-H "Content-Type: application/json" \
-d '{"domain":[],"fields":["name","applied_on","base","compute_price","base_pricelist_id"],"limit":5}'import requests
BASE_URL = "https://your-instance.odoo.com/json/2"
headers = {"Authorization": f"bearer {API_KEY}", "X-Odoo-Database": "your-db"}
res = requests.post(
f"{BASE_URL}/product.pricelist.item/search_read",
headers=headers,
json={"domain": [], "fields": ["name","applied_on","base","compute_price","base_pricelist_id"], "limit": 5},
)
res.raise_for_status()
print(res.json())- External API access requires Odoo's Custom plan.
- XML-RPC and JSON-RPC will be removed in Odoo 22 (fall 2028): use JSON-2.
- The access rights and record rules of the key's user apply.
Cite this tool
Writing a tutorial, internal documentation or a forum answer? Copy this link to send your readers to the up-to-date reference.
<a href="https://aidoo.ai/en/outils/explorateur-modeles-odoo/product-pricelist-item">product.pricelist.item (Odoo 20.0)</a>Sources
Data verified on September 25, 2026 · Odoo 20.0 Community
Have an Odoo project, or want to put your ERP to work with AI? Let's talk
Implementation, custom module development, connecting Claude or ChatGPT to your data: tell us about your context and we will reply within 24 business hours.