Where are odoo sales products saved ? 26.01.25

in the table product_template

Comment: Product
Column	Type	Comment
id	integer Auto Increment [nextval('product_template_id_seq')]	
sequence	integer NULL	Sequence
categ_id	integer	Product Category
uom_id	integer	Unit of Measure
uom_po_id	integer	Purchase Unit
company_id	integer NULL	Company
color	integer NULL	Color Index
create_uid	integer NULL	Created by
write_uid	integer NULL	Last Updated by
type	character varying	Product Type
service_tracking	character varying	Create on Order
default_code	character varying NULL	Internal Reference
name	jsonb	Name
description	jsonb NULL	Description
description_purchase	jsonb NULL	Purchase Description
description_sale	jsonb NULL	Sales Description
product_properties	jsonb NULL	Properties
list_price	numeric NULL	Sales Price
volume	numeric NULL	Volume
weight	numeric NULL	Weight
sale_ok	boolean NULL	Sales
purchase_ok	boolean NULL	Purchase
active	boolean NULL	Active
can_image_1024_be_zoomed	boolean NULL	Can Image 1024 be zoomed
has_configurable_attributes	boolean NULL	Is a configurable product
is_favorite	boolean NULL	Favorite
create_date	timestamp NULL	Created on
write_date	timestamp NULL	Last Updated on
property_account_income_id	jsonb NULL	Income Account
property_account_expense_id	jsonb NULL	Expense Account
service_type	character varying NULL	Track Service
sale_line_warn	character varying	Sales Order Line
expense_policy	character varying NULL	Re-Invoice Costs
invoice_policy	character varying NULL	Invoicing Policy
sale_line_warn_msg	text NULL	Message for Sales Order Line
sale_delay	integer NULL	Customer Lead Time
tracking	character varying	Tracking
responsible_id	jsonb NULL	Responsible
property_stock_production	jsonb NULL	Production Location
property_stock_inventory	jsonb NULL	Inventory Location
description_picking	jsonb NULL	Description on Picking
description_pickingout	jsonb NULL	Description on Delivery Orders
description_pickingin	jsonb NULL	Description on Receptions
is_storable	boolean NULL	Track Inventory
lot_valuated	boolean NULL	Valuation by Lot/Serial number
country_of_origin	integer NULL	Origin of Goods
hs_code	character varying NULL	HS Code
website_id	integer NULL	Website
website_size_x	integer NULL	Size X
website_size_y	integer NULL	Size Y
website_ribbon_id	integer NULL	Ribbon
website_sequence	integer NULL	Website Sequence
base_unit_id	integer NULL	Custom Unit of Measure
website_meta_og_img	character varying NULL	Website opengraph image
website_meta_title	jsonb NULL	Website meta title
website_meta_description	jsonb NULL	Website meta description
website_meta_keywords	jsonb NULL	Website meta keywords
seo_name	jsonb NULL	Seo name
website_description	jsonb NULL	Description for the website
description_ecommerce	jsonb NULL	eCommerce Description
compare_list_price	numeric NULL	Compare to Price
is_published	boolean NULL	Is Published
rating_last_value	double precision NULL	Rating Last Value
base_unit_count	double precision	Base Unit Count
out_of_stock_message	jsonb NULL	Out-of-Stock Message
allow_out_of_stock_order	boolean NULL	Continue selling when out-of-stock
show_availability	boolean NULL	Show availability Qty
available_threshold	double precision NULL	Show Threshold

https://freewebsnippets.com/blog/what-is-sales-in-odoo-sales-module-in-odoo.html

Anonymous

Where are odoo sales products saved ? 26.01.25

Information Epoch 1751597360