Odoo model ·
product.template
Product Template
Everything the Oddll AI Brain can read and reason about on your product.template records — safely, and only what the signed-in user is allowed to see.
Works with Odoo 16, 17, 18, 19
Library / Product Template
Part of:
Invoicing
Avatax
Intrastat Reports
Events Booths Sales
Events Product
Expenses
Field Service - Sale
Field Service Reports - Sale
Argentinean Electronic Invoicing
Avatax Brazil
Brazilian Accounting EDI for POS
Electronic invoicing for Colombia with Carvajal
Mandate invoicing for Colombia
Czech Republic - Accounting Reports 2025
Ecuadorian Accounting EDI
Egypt E-Invoicing
Greece - myDATA
Hungary - E-invoicing
Indonesia E-faktur (Coretax)
Indian - Accounting
Kenya eTIMS EDI Integration
Kenya - Point of Sale
EDI for Mexico
EDI for Mexico (Advanced Features)
Mexico - Electronic Delivery Guide
Malaysia - E-invoicing
EDI for Peru
Peruvian - Electronic Delivery Note
Peru - Stock Reports
Poland - Accounting
Türkiye - Accounting
Members
Manufacturing
Master Production Schedule
Product Lifecycle Management (PLM)
Point of Sale
POS Self Order
Point of Sale - UrbanPiper
Products & Pricelists
Product Email Template
Products Expiration Date
UNSPSC product codes
Purchase
Purchase Stock
Quality
Repairs
Sales
Amazon Connector
Sales Expense
Gelato
Sale Planning
Sale Matrix
Sales - Project
Sale Project Forecast
Sale Purchase
Rental
Rental Stock Management
Subscriptions
Sales Timesheet
Inventory
WMS Accounting
Delivery - Stock
WMS Landed Costs
eCommerce
Sell Courses
Product Availability
Questions about Product Template
- How many Product Template records are there?
- Show the most recent Product Template records
- How many Product Template records are marked Active?
- How many Product Template records are marked Allow Out Of Stock Order?
- How many Product Template records are marked Allow Worksheets?
- How many Product Template records are marked Available In Pos?
- Break down Product Template records by Category
- Which Category has the most Product Template records?
- Break down Product Template records by Unit
- Which Unit has the most Product Template records?
- What is the total Base Unit Price on Product Template this month?
- Which Product Template records have the highest Base Unit Price?
- How many Product Template records are marked Can Be Expensed?
- How many Product Template records are marked Can Image 1024 Be Zoomed?
- Break down Product Template records by Company
- Which Company has the most Product Template records?
- What is the total Compare List Price on Product Template this month?
- Which Product Template records have the highest Compare List Price?
- Break down Product Template records by Currency
- Which Currency has the most Product Template records?
- How many Product Template records are in each Cost Method?
- Break down Product Template records by Country
- Which Country has the most Product Template records?
- How many Product Template records are marked Create Repair?
- Break down Product Template records by Template
- Which Template has the most Product Template records?
- How many Product Template records are in each Expense Policy?
- How many Product Template records are marked Gelato Missing Images?
- How many Product Template records are marked Has Available Route?
- How many Product Template records are marked Has Configurable Attributes?
- Break down Product Template records by Code
- Which Code has the most Product Template records?
- How many Product Template records are in each Intrastat Supplementary Unit?
- What is the total Intrastat Supplementary Unit Amount on Product Template this month?
- Which Product Template records have the highest Intrastat Supplementary Unit Amount?
- How many Product Template records are in each Invoice Policy?
- How many Product Template records are marked Is Alcoholic On Urbanpiper?
- How many Product Template records are marked Is Favorite?
- How many Product Template records are marked Is Kits?
- How many Product Template records are marked Is Product Variant?
- How many Product Template records are marked Is Recommended On Urbanpiper?
- How many Product Template records are marked Is Storable?
- Break down Product Template records by City
- Which City has the most Product Template records?
- How many Product Template records are marked L10n Br Labor?
- How many Product Template records are in each L10n Br Source Origin?
- How many Product Template records are in each L10n Br Sped Type?
- How many Product Template records are in each L10n Br Transport Cost Type?
- How many Product Template records are in each L10n Br Use Type?
- How many Product Template records are marked L10n Co Dian Mandate Contract?
- What is the total L10n Co Edi Ref Nominal Tax on Product Template this month?
- Which Product Template records have the highest L10n Co Edi Ref Nominal Tax?
- How many Product Template records are in each L10n Cz Supplies Code?
- How many Product Template records are in each L10n Cz Transaction Code?
- Break down Product Template records by Tax
- Which Tax has the most Product Template records?
- How many Product Template records are in each L10n Hu Product Code Type?
- How many Product Template records are marked L10n Ke Is Insurance Applicable?
- How many Product Template records are in each L10n Ke Product Type Code?
- How many Product Template records are in each L10n Mx Edi Hazard Package Type?
- How many Product Template records are in each L10n Mx Edi Hazardous Material?
- Break down Product Template records by Material
- Which Material has the most Product Template records?
- How many Product Template records are in each L10n Mx Edi Material Type?
- Break down Product Template records by Fraction
- Which Fraction has the most Product Template records?
- Break down Product Template records by Uom
- Which Uom has the most Product Template records?
- How many Product Template records are in each L10n My Edi Classification Code?
- How many Product Template records are in each L10n Pe Edi Tariff Fraction?
- How many Product Template records are in each L10n Pe Type Of Existence?
- How many Product Template records are in each L10n Pe Withhold Code?
- How many Product Template records are in each L10n Pl Vat Gtu?
- Break down Product Template records by Account
- Which Account has the most Product Template records?
- How many Product Template records are marked Landed Cost Ok?
- What is the total List Price on Product Template this month?
- Which Product Template records have the highest List Price?
- Break down Product Template records by Location
- Which Location has the most Product Template records?
- How many Product Template records are marked Lot Valuated?
- How many Product Template records are marked Membership?
- How many Product Template records were created this month?
- Break down Product Template records by month
- How many Product Template records are marked Planning Enabled?
- Break down Product Template records by Role
- Which Role has the most Product Template records?
- How many Product Template records are in each Product Add Mode?
- Break down Product Template records by Product
- Which Product has the most Product Template records?
- Break down Product Template records by Project
- Which Project has the most Product Template records?
- How many Product Template records are in each Purchase Line Warn?
- How many Product Template records are in each Purchase Method?
- How many Product Template records are marked Purchase Ok?
- How many Product Template records are marked Recurring Invoice?
- How many Product Template records are marked Rent Ok?
- Break down Product Template records by Users
- Which Users has the most Product Template records?
- How many Product Template records are in each Sale Line Warn?
- How many Product Template records are marked Sale Ok?
- How many Product Template records are marked Self Order Available?
- How many Product Template records are in each Service Policy?
- How many Product Template records are marked Service To Purchase?
- How many Product Template records are in each Service Tracking?
- How many Product Template records are in each Service Type?
- How many Product Template records are marked Show Availability?
- How many Product Template records are marked Show Forecasted Qty Status Button?
- How many Product Template records are marked Show On Hand Qty Status Button?
- How many Product Template records are in each Split Method Landed Cost?
- What is the total Standard Price on Product Template this month?
- Which Product Template records have the highest Standard Price?
- How many Product Template records are marked To Weight?
- How many Product Template records are in each Tracking?
- How many Product Template records are in each Type?
- How many Product Template records are in each Urbanpiper Meal Type?
- How many Product Template records are marked Use Expiration Date?
- How many Product Template records are in each Valuation?
- How many Product Template records are marked Visible Expense Policy?
- Break down Product Template records by Warehouse
- Which Warehouse has the most Product Template records?
- Break down Product Template records by Ribbon
- Which Ribbon has the most Product Template records?
Fields on this model
| Field | Type | Relates to |
|---|---|---|
accessory_product_ids |
many2many |
product.product
|
account_tag_ids |
many2many |
account.account.tag
|
active |
boolean | — |
alert_time |
integer | — |
allow_out_of_stock_order |
boolean | — |
allow_worksheets |
boolean | — |
alternative_product_ids |
many2many |
product.template
|
attribute_line_ids |
one2many |
product.template.attribute.line
|
available_in_pos |
boolean | — |
available_threshold |
float | — |
avatax_category_id |
many2one |
product.avatax.category
|
barcode |
char | — |
base_unit_count |
float | — |
base_unit_id |
many2one |
website.base.unit
|
base_unit_name |
char | — |
base_unit_price |
monetary | — |
bom_count |
integer | — |
bom_ids |
one2many |
mrp.bom
|
bom_line_ids |
one2many |
mrp.bom.line
|
can_be_expensed |
boolean | — |
can_image_1024_be_zoomed |
boolean | — |
categ_id |
many2one |
product.category
|
color |
integer | — |
combo_ids |
many2many |
product.combo
|
company_id |
many2one |
res.company
|
compare_list_price |
monetary | — |
cost_currency_id |
many2one |
res.currency
|
cost_method |
selection | — |
country_of_origin |
many2one |
res.country
|
create_repair |
boolean | — |
currency_id |
many2one |
res.currency
|
default_code |
char | — |
description |
html | — |
description_ecommerce |
html | — |
description_picking |
text | — |
description_pickingin |
text | — |
description_pickingout |
text | — |
description_purchase |
text | — |
description_sale |
text | — |
display_price |
char | — |
display_subscription_pricing |
char | — |
eco_count |
integer | — |
eco_ids |
one2many |
mrp.eco
|
email_template_id |
many2one |
mail.template
|
expense_policy |
selection | — |
expense_policy_tooltip |
char | — |
expiration_time |
integer | — |
extra_daily |
float | — |
extra_hourly |
float | — |
fiscal_country_codes |
char | — |
gelato_image_ids |
one2many |
product.document
|
gelato_missing_images |
boolean | — |
gelato_product_uid |
char | — |
gelato_template_ref |
char | — |
has_available_route_ids |
boolean | — |
has_configurable_attributes |
boolean | — |
hs_code |
char | — |
incoming_qty |
float | — |
intrastat_code_domain |
char | — |
intrastat_code_id |
many2one |
account.intrastat.code
|
intrastat_origin_country_id |
many2one |
res.country
|
intrastat_supplementary_unit |
selection | — |
intrastat_supplementary_unit_amount |
float | — |
invoice_policy |
selection | — |
is_alcoholic_on_urbanpiper |
boolean | — |
is_favorite |
boolean | — |
is_kits |
boolean | — |
is_product_variant |
boolean | — |
is_recommended_on_urbanpiper |
boolean | — |
is_storable |
boolean | — |
l10n_ar_ncm_code |
char | — |
l10n_br_cest_code |
char | — |
l10n_br_company_city_id |
many2one |
res.city
|
l10n_br_labor |
boolean | — |
l10n_br_ncm_code_id |
many2one |
l10n_br.ncm.code
|
l10n_br_pos_warning |
text | — |
l10n_br_property_service_code_origin_id |
many2one |
l10n_br.service.code
|
l10n_br_service_code_ids |
many2many |
l10n_br.service.code
|
l10n_br_source_origin |
selection | — |
l10n_br_sped_type |
selection | — |
l10n_br_transport_cost_type |
selection | — |
l10n_br_use_type |
selection | — |
l10n_co_dian_mandate_contract |
boolean | — |
l10n_co_edi_brand |
char | — |
l10n_co_edi_customs_code |
char | — |
l10n_co_edi_ref_nominal_tax |
float | — |
l10n_cz_supplies_code |
selection | — |
l10n_cz_transaction_code |
selection | — |
l10n_ec_auxiliary_code |
char | — |
l10n_ec_withhold_tax_id |
many2one |
account.tax
|
l10n_eg_eta_code |
char | — |
l10n_gr_edi_preferred_classification_ids |
one2many |
l10n_gr_edi.preferred_classification
|
l10n_hu_product_code |
char | — |
l10n_hu_product_code_type |
selection | — |
l10n_id_product_code |
many2one |
l10n_id_efaktur_coretax.product.code
|
l10n_in_hsn_code |
char | — |
l10n_in_hsn_warning |
text | — |
l10n_ke_is_insurance_applicable |
boolean | — |
l10n_ke_item_code |
char | — |
l10n_ke_origin_country_id |
many2one |
res.country
|
l10n_ke_packaging_quantity |
float | — |
l10n_ke_packaging_unit_id |
many2one |
l10n_ke_edi_oscu.code
|
l10n_ke_product_type_code |
selection | — |
l10n_ke_validation_message |
char | — |
l10n_mx_edi_hazard_package_type |
selection | — |
l10n_mx_edi_hazardous_material |
selection | — |
l10n_mx_edi_hazardous_material_code_id |
many2one |
l10n_mx_edi.hazardous.material
|
l10n_mx_edi_material_description |
char | — |
l10n_mx_edi_material_type |
selection | — |
l10n_mx_edi_predial_account |
char | — |
l10n_mx_edi_tariff_fraction_id |
many2one |
l10n_mx_edi.tariff.fraction
|
l10n_mx_edi_umt_aduana_id |
many2one |
uom.uom
|
l10n_my_edi_classification_code |
selection | — |
l10n_pe_edi_tariff_fraction |
selection | — |
l10n_pe_type_of_existence |
selection | — |
l10n_pe_withhold_code |
selection | — |
l10n_pe_withhold_percentage |
float | — |
l10n_pl_vat_gtu |
selection | — |
l10n_tr_default_sales_return_account_id |
many2one |
account.account
|
landed_cost_ok |
boolean | — |
list_price |
float | — |
location_id |
many2one |
stock.location
|
lot_valuated |
boolean | — |
membership |
boolean | — |
membership_date_from |
date | — |
membership_date_to |
date | — |
mrp_product_qty |
float | — |
name |
char | — |
nbr_moves_in |
integer | — |
nbr_moves_out |
integer | — |
nbr_reordering_rules |
integer | — |
offer_count |
integer | — |
optional_product_ids |
many2many |
product.template
|
out_of_stock_message |
html | — |
outgoing_qty |
float | — |
packaging_ids |
one2many |
product.packaging
|
planning_enabled |
boolean | — |
planning_role_id |
many2one |
planning.role
|
pos_categ_ids |
many2many |
pos.category
|
preparation_time |
float | — |
pricelist_item_count |
integer | — |
product_add_mode |
selection | — |
product_document_count |
integer | — |
product_document_ids |
one2many |
product.document
|
product_pricing_ids |
one2many |
product.pricing
|
product_properties |
properties | — |
product_subscription_pricing_ids |
one2many |
sale.subscription.pricing
|
product_tag_ids |
many2many |
product.tag
|
product_template_image_ids |
one2many |
product.image
|
product_tooltip |
char | — |
product_variant_count |
integer | — |
product_variant_id |
many2one |
product.product
|
product_variant_ids |
one2many |
product.product
|
project_id |
many2one | — |
project_template_id |
many2one |
project.project
|
property_account_creditor_price_difference |
many2one |
account.account
|
property_account_expense_id |
many2one |
account.account
|
property_account_income_id |
many2one |
account.account
|
property_stock_inventory |
many2one |
stock.location
|
property_stock_production |
many2one |
stock.location
|
public_categ_ids |
many2many |
product.public.category
|
public_description |
html | — |
purchase_line_warn |
selection | — |
purchase_line_warn_msg |
text | — |
purchase_method |
selection | — |
purchase_ok |
boolean | — |
purchased_product_qty |
float | — |
qty_available |
float | — |
qty_in_rent |
float | — |
quality_control_point_qty |
integer | — |
quality_fail_qty |
integer | — |
quality_pass_qty |
integer | — |
recurring_invoice |
boolean | — |
removal_time |
integer | — |
rent_ok |
boolean | — |
reordering_max_qty |
float | — |
reordering_min_qty |
float | — |
responsible_id |
many2one |
res.users
|
route_from_categ_ids |
many2many | — |
route_ids |
many2many | — |
sale_delay |
integer | — |
sale_line_warn |
selection | — |
sale_line_warn_msg |
text | — |
sale_ok |
boolean | — |
sales_count |
float | — |
schedule_count |
integer | — |
self_order_available |
boolean | — |
seller_ids |
one2many |
product.supplierinfo
|
sequence |
integer | — |
service_policy |
selection | — |
service_to_purchase |
boolean | — |
service_tracking |
selection | — |
service_type |
selection | — |
service_upsell_threshold |
float | — |
service_upsell_threshold_ratio |
char | — |
show_availability |
boolean | — |
show_forecasted_qty_status_button |
boolean | — |
show_on_hand_qty_status_button |
boolean | — |
split_method_landed_cost |
selection | — |
standard_price |
float | — |
supplier_taxes_id |
many2many |
account.tax
|
tax_string |
char | — |
taxes_id |
many2many |
account.tax
|
to_weight |
boolean | — |
tracking |
selection | — |
type |
selection | — |
unspsc_code_id |
many2one |
product.unspsc.code
|
uom_category_id |
many2one |
uom.category
|
uom_id |
many2one |
uom.uom
|
uom_name |
char | — |
uom_po_id |
many2one |
uom.uom
|
urban_piper_status_ids |
one2many |
product.urban.piper.status
|
urbanpiper_meal_type |
selection | — |
urbanpiper_pos_config_ids |
many2many |
pos.config
|
use_expiration_date |
boolean | — |
use_time |
integer | — |
used_in_bom_count |
integer | — |
valid_intrastat_code_ids |
many2many |
account.intrastat.code
|
valid_product_template_attribute_line_ids |
many2many |
product.template.attribute.line
|
valuation |
selection | — |
variant_seller_ids |
one2many |
product.supplierinfo
|
version |
integer | — |
virtual_available |
float | — |
visible_expense_policy |
boolean | — |
volume |
float | — |
volume_uom_name |
char | — |
warehouse_id |
many2one |
stock.warehouse
|
website_description |
html | — |
website_ribbon_id |
many2one |
product.ribbon
|
website_sequence |
integer | — |
website_size_x |
integer | — |
website_size_y |
integer | — |
weight |
float | — |
weight_uom_name |
char | — |
worksheet_template_id |
many2one |
worksheet.template
|
Related models
Product Product
Account Account Tag
Product Template Attribute Line
Product Avatax Category
Website Base Unit
Mrp Bom
Mrp Bom Line
Product Category
Product Combo
Res Company
Res Currency
Res Country
Ask it in your own Odoo
The answer comes from your database — private, permission-checked, and audited. Oddll AI Brain never stores your business data.
Get Odoo + AI tips