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.
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
|
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