template |
Product
Catalog: Odoo
Schema: product
The data in this table is partitioned per value of the column.
This is a read-only table. The Odoo API may not support changing the data or the Invantive SQL driver for Odoo does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Odoo API.
Table Columns
The columns of the table template are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
accessory_product_ids |
string |
|
☐ |
Accessories show up when the customer reviews the cart before payment (cross-sell strategy). |
account_tag_ids |
string |
|
☐ |
Tags to be set on the base and tax journal items created for this product. |
active |
boolean |
Active |
☐ |
If unchecked, it will allow you to hide the product without removing it. |
activity_calendar_event_id_label |
string |
|
☐ |
|
activity_calendar_event_id |
string |
|
☐ |
|
activity_date_deadline |
datetime |
Next Activity Deadline |
☐ |
|
activity_exception_decoration |
string |
Activity Exception Decoration |
☐ |
Type of the exception activity on record. |
activity_exception_icon |
string |
Icon |
☐ |
Icon to indicate an exception activity. |
activity_ids |
string |
|
☐ |
|
activity_state |
string |
Activity State |
☐ |
Status based on activitiesOverdue: Due date is already passedToday: Activity date is todayPlanned: Future activities. |
activity_summary |
string |
Next Activity Summary |
☐ |
|
activity_type_icon |
string |
Activity Type Icon |
☐ |
Font awesome icon e.g. fa-tasks |
activity_type_id_label |
string |
|
☐ |
|
activity_type_id |
string |
|
☐ |
|
activity_user_id_label |
string |
|
☐ |
|
activity_user_id |
string |
|
☐ |
|
allow_out_of_stock_order |
boolean |
Continue selling when out-of-stock |
☐ |
|
allow_worksheets |
boolean |
Worksheets |
☐ |
|
alternative_product_ids |
string |
|
☐ |
Suggest alternatives to your customer (upsell strategy). Those products show up on the product page. |
attribute_line_ids |
string |
|
☐ |
|
available_in_pos |
boolean |
Available in POS |
☐ |
Check if you want this product to appear in the Point of Sale. |
available_threshold |
decimal |
Show Threshold |
☐ |
|
barcode |
string |
Barcode |
☐ |
|
base_unit_count |
decimal |
Base Unit Count |
☑ |
Display base unit price on your eCommerce pages. Set to 0 to hide it for this product. |
base_unit_id_label |
string |
|
☐ |
Define a custom unit to display in the price per unit of measure field. |
base_unit_id |
string |
|
☐ |
Define a custom unit to display in the price per unit of measure field. |
base_unit_name |
string |
Base Unit Name |
☐ |
Displays the custom unit for the products if defined or the selected unit of measure otherwise. |
base_unit_price |
decimal |
Price Per Unit |
☐ |
|
bom_count |
int32 |
# Bill of Material |
☐ |
|
bom_ids |
string |
|
☐ |
|
bom_line_ids |
string |
|
☐ |
|
can_be_expensed |
boolean |
Can be Expensed |
☐ |
Specify whether the product can be selected in an expense. |
can_image_1024_be_zoomed |
boolean |
Can Image 1024 be zoomed |
☐ |
|
can_publish |
boolean |
Can Publish |
☐ |
|
categ_id_label |
string |
|
☐ |
|
categ_id |
string |
|
☐ |
|
color |
int32 |
Color Index |
☐ |
|
company_id_label |
string |
|
☐ |
|
company_id |
string |
|
☐ |
|
compare_list_price |
decimal |
Compare to Price |
☐ |
The amount will be displayed strikethroughed on the eCommerce product page |
cost_currency_id_label |
string |
|
☐ |
|
cost_currency_id |
string |
|
☐ |
|
cost_method |
string |
Costing Method |
☐ |
Standard Price: The products are valued at their standard cost defined on the product.Average Cost (AVCO): The products are valued at weighted average cost.First In First Out (FIFO): The products are valued supposing those that enter the company first will also leave it first. |
country_of_origin_label |
string |
|
☐ |
Rules of origin determine where goods originate, i.e. not where they have been shipped from, but where they have been produced or manufactured.As such, the ‘origin’ is the 'economic nationality' of goods traded in commerce. |
country_of_origin |
string |
|
☐ |
Rules of origin determine where goods originate, i.e. not where they have been shipped from, but where they have been produced or manufactured.As such, the ‘origin’ is the 'economic nationality' of goods traded in commerce. |
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
currency_id_label |
string |
|
☐ |
|
currency_id |
string |
|
☐ |
|
days_to_prepare_mo |
decimal |
Days to prepare Manufacturing Order |
☐ |
Create and confirm Manufacturing Orders these many days in advance, to have enough time to replenish components or manufacture semi-finished products.Note that this does not affect the MO scheduled date, which still respects the just-in-time mechanism. |
default_code |
string |
Internal Reference |
☐ |
|
description_picking |
string |
Description on Picking |
☐ |
|
description_pickingin |
string |
Description on Receptions |
☐ |
|
description_pickingout |
string |
Description on Delivery Orders |
☐ |
|
description_purchase |
string |
Purchase Description |
☐ |
|
description_sale |
string |
Sales Description |
☐ |
A description of the Product that you want to communicate to your customers. This description will be copied to every Sales Order, Delivery Order and Customer Invoice/Credit Note |
description |
string |
Description |
☐ |
|
detailed_type |
string |
Product Type |
☑ |
A storable product is a product for which you manage stock. The Inventory app has to be installed.A consumable product is a product for which stock is not managed.A service is a non-material product you provide. |
display_name |
string |
Display Name |
☐ |
|
display_price |
string |
Leasing price |
☐ |
First leasing pricing of the product |
documents_allowed_company_id_label |
string |
|
☐ |
|
documents_allowed_company_id |
string |
|
☐ |
|
ebay_best_offer |
boolean |
Allow Best Offer |
☐ |
|
ebay_buy_it_now_price |
decimal |
Buy It Now Price |
☐ |
|
ebay_category_2_id_label |
string |
|
☐ |
The use of a secondary category is not allowed on every eBay sites. Fees can be claimed by eBay for this feature |
ebay_category_2_id |
string |
|
☐ |
The use of a secondary category is not allowed on every eBay sites. Fees can be claimed by eBay for this feature |
ebay_category_id_label |
string |
|
☐ |
|
ebay_category_id |
string |
|
☐ |
|
ebay_description |
string |
eBay Description |
☐ |
|
ebay_fixed_price |
decimal |
eBay Fixed Price |
☐ |
|
ebay_id |
string |
eBay ID |
☐ |
|
ebay_item_condition_id_label |
string |
|
☐ |
|
ebay_item_condition_id |
string |
|
☐ |
|
ebay_last_sync |
datetime |
Last update |
☐ |
|
ebay_listing_duration |
string |
Duration |
☐ |
|
ebay_listing_status |
string |
eBay Status |
☐ |
|
ebay_listing_type |
string |
Listing Type |
☐ |
|
ebay_price |
decimal |
Starting Price for Auction |
☐ |
|
ebay_private_listing |
boolean |
Private Listing |
☐ |
|
ebay_quantity_sold |
int32 |
Quantity Sold |
☐ |
|
ebay_quantity |
int32 |
Quantity On eBay |
☐ |
|
ebay_seller_payment_policy_id_label |
string |
|
☐ |
|
ebay_seller_payment_policy_id |
string |
|
☐ |
|
ebay_seller_return_policy_id_label |
string |
|
☐ |
|
ebay_seller_return_policy_id |
string |
|
☐ |
|
ebay_seller_shipping_policy_id_label |
string |
|
☐ |
|
ebay_seller_shipping_policy_id |
string |
|
☐ |
|
ebay_start_date |
datetime |
Start Date |
☐ |
|
ebay_store_category_2_id_label |
string |
|
☐ |
|
ebay_store_category_2_id |
string |
|
☐ |
|
ebay_store_category_id_label |
string |
|
☐ |
|
ebay_store_category_id |
string |
|
☐ |
|
ebay_subtitle |
string |
Subtitle |
☐ |
The subtitle is restricted to 55 characters. Fees can be claimed by eBay for this feature |
ebay_sync_stock |
boolean |
Use Stock Quantity |
☐ |
|
ebay_template_id_label |
string |
|
☐ |
|
ebay_template_id |
string |
|
☐ |
|
ebay_title |
string |
Title |
☐ |
The title is restricted to 80 characters |
ebay_url |
string |
eBay url |
☐ |
|
ebay_use |
boolean |
Use eBay |
☐ |
|
eco_count |
int32 |
# ECOs |
☐ |
|
eco_ids |
string |
|
☐ |
|
expense_policy_tooltip |
string |
Expense Policy Tooltip |
☐ |
|
expense_policy |
string |
Re-Invoice Expenses |
☐ |
Expenses and vendor bills can be re-invoiced to a customer.With this option, a validated expense can be re-invoice to a customer at its cost or sales price. |
extra_daily |
decimal |
Extra Day |
☐ |
Fine by day overdue |
extra_hourly |
decimal |
Extra Hour |
☐ |
Fine by hour overdue |
fiscal_country_codes |
string |
Fiscal Country Codes |
☐ |
|
has_available_route_ids |
boolean |
Routes can be selected on this product |
☐ |
|
has_configurable_attributes |
boolean |
Is a configurable product |
☐ |
|
has_message |
boolean |
Has Message |
☐ |
|
hs_code |
string |
HS Code |
☐ |
Standardized code for international shipping and goods declaration. At the moment, only used for the FedEx shipping provider. |
id |
int32 |
ID |
☐ |
|
image_1024 |
byte[] |
Image 1024 |
☐ |
|
image_128 |
byte[] |
Image 128 |
☐ |
|
image_1920 |
byte[] |
Image |
☐ |
|
image_256 |
byte[] |
Image 256 |
☐ |
|
image_512 |
byte[] |
Image 512 |
☐ |
|
incoming_qty |
decimal |
Incoming |
☐ |
|
invoice_policy |
string |
Invoicing Policy |
☐ |
Ordered Quantity: Invoice quantities ordered by the customer.Delivered Quantity: Invoice quantities delivered to the customer. |
is_kits |
boolean |
Is Kits |
☐ |
|
is_product_variant |
boolean |
Is a product variant |
☐ |
|
is_published |
boolean |
Is Published |
☐ |
|
is_seo_optimized |
boolean |
SEO optimized |
☐ |
|
is_temporal |
boolean |
Is Temporal |
☐ |
|
list_price |
decimal |
Sales Price |
☐ |
Price at which the product is sold to customers. |
location_id_label |
string |
|
☐ |
|
location_id |
string |
|
☐ |
|
message_attachment_count |
int32 |
Attachment Count |
☐ |
|
message_follower_ids |
string |
|
☐ |
|
message_has_error_counter |
int32 |
Number of errors |
☐ |
Number of messages with delivery error |
message_has_error |
boolean |
Message Delivery error |
☐ |
If checked, some messages have a delivery error. |
message_has_sms_error |
boolean |
SMS Delivery error |
☐ |
If checked, some messages have a delivery error. |
message_ids |
string |
|
☐ |
|
message_is_follower |
boolean |
Is Follower |
☐ |
|
message_main_attachment_id_label |
string |
|
☐ |
|
message_main_attachment_id |
string |
|
☐ |
|
message_needaction_counter |
int32 |
Number of Actions |
☐ |
Number of messages which requires an action |
message_needaction |
boolean |
Action Needed |
☐ |
If checked, new messages require your attention. |
message_partner_ids |
string |
|
☐ |
|
mrp_product_qty |
decimal |
Manufactured |
☐ |
|
my_activity_date_deadline |
datetime |
My Activity Deadline |
☐ |
|
name |
string |
Name |
☑ |
|
nbr_moves_in |
int32 |
Nbr Moves In |
☐ |
Number of incoming stock moves in the past 12 months |
nbr_moves_out |
int32 |
Nbr Moves Out |
☐ |
Number of outgoing stock moves in the past 12 months |
nbr_reordering_rules |
int32 |
Reordering Rules |
☐ |
|
offer_count |
int32 |
Offer Count |
☐ |
|
optional_product_ids |
string |
|
☐ |
Optional Products are suggested whenever the customer hits *Add to Cart* (cross-sell strategy, e.g. for computers: warranty, software, etc.). |
out_of_stock_message |
string |
Out-of-Stock Message |
☐ |
|
outgoing_qty |
decimal |
Outgoing |
☐ |
|
packaging_ids |
string |
|
☐ |
Gives the different ways to package the same product. |
planning_enabled |
boolean |
Plan Services |
☐ |
If enabled, a shift will automatically be generated for the selected role when confirming the Sales Order. Only employees with this role will automatically be assigned shifts for Sales Orders containing this service. |
planning_role_id_label |
string |
|
☐ |
|
planning_role_id |
string |
|
☐ |
|
pos_categ_id_label |
string |
|
☐ |
Category used in the Point of Sale. |
pos_categ_id |
string |
|
☐ |
Category used in the Point of Sale. |
preparation_time |
decimal |
Security Time |
☐ |
Temporarily make this product unavailable before pickup. |
pricelist_item_count |
int32 |
Number of price rules |
☐ |
|
priority |
string |
Favorite |
☐ |
|
produce_delay |
decimal |
Manufacturing Lead Time |
☐ |
Average lead time in days to manufacture this product. In the case of multi-level BOM, the manufacturing lead times of the components will be added. In case the product is subcontracted, this can be used to determine the date at which components should be sent to the subcontractor. |
product_pricing_ids |
string |
|
☐ |
|
product_tag_ids |
string |
|
☐ |
|
product_template_image_ids |
string |
|
☐ |
|
product_tooltip |
string |
Product Tooltip |
☐ |
|
product_variant_count |
int32 |
# Product Variants |
☐ |
|
product_variant_id_label |
string |
|
☐ |
|
product_variant_id |
string |
|
☐ |
|
product_variant_ids |
string |
|
☐ |
|
project_id_label |
string |
|
☐ |
|
project_id |
string |
|
☐ |
|
project_template_id_label |
string |
|
☐ |
|
project_template_id |
string |
|
☐ |
|
property_account_creditor_price_difference_label |
string |
|
☐ |
This account is used in automated inventory valuation to record the price difference between a purchase order and its related vendor bill when validating this vendor bill. |
property_account_creditor_price_difference |
string |
|
☐ |
This account is used in automated inventory valuation to record the price difference between a purchase order and its related vendor bill when validating this vendor bill. |
property_account_expense_id_label |
string |
|
☐ |
Keep this field empty to use the default value from the product category. If anglo-saxon accounting with automated valuation method is configured, the expense account on the product category will be used. |
property_account_expense_id |
string |
|
☐ |
Keep this field empty to use the default value from the product category. If anglo-saxon accounting with automated valuation method is configured, the expense account on the product category will be used. |
property_account_income_id_label |
string |
|
☐ |
Keep this field empty to use the default value from the product category. |
property_account_income_id |
string |
|
☐ |
Keep this field empty to use the default value from the product category. |
property_stock_inventory_label |
string |
|
☐ |
This stock location will be used, instead of the default one, as the source location for stock moves generated when you do an inventory. |
property_stock_inventory |
string |
|
☐ |
This stock location will be used, instead of the default one, as the source location for stock moves generated when you do an inventory. |
property_stock_production_label |
string |
|
☐ |
This stock location will be used, instead of the default one, as the source location for stock moves generated by manufacturing orders. |
property_stock_production |
string |
|
☐ |
This stock location will be used, instead of the default one, as the source location for stock moves generated by manufacturing orders. |
public_categ_ids |
string |
|
☐ |
The product will be available in each mentioned eCommerce category. Go to Shop > Edit Click on the page and enable 'Categories' to view all eCommerce categories. |
purchase_line_warn_msg |
string |
Message for Purchase Order Line |
☐ |
|
purchase_line_warn |
string |
Purchase Order Line Warning |
☑ |
Selecting the "Warning" option will notify user with the message, Selecting "Blocking Message" will throw an exception with the message and block the flow. The Message has to be written in the next field. |
purchase_method |
string |
Control Policy |
☐ |
On ordered quantities: Control bills based on ordered quantities.On received quantities: Control bills based on received quantities. |
purchase_ok |
boolean |
Can be Purchased |
☐ |
|
purchased_product_qty |
decimal |
Purchased |
☐ |
|
qty_available |
decimal |
Quantity On Hand |
☐ |
|
qty_in_rent |
decimal |
Quantity currently in rent |
☐ |
|
quality_control_point_qty |
int32 |
Quality Control Point Qty |
☐ |
|
quality_fail_qty |
int32 |
Quality Fail Qty |
☐ |
|
quality_pass_qty |
int32 |
Quality Pass Qty |
☐ |
|
rating_avg_text |
string |
Rating Avg Text |
☐ |
|
rating_avg |
decimal |
Average Rating |
☐ |
|
rating_count |
int32 |
Rating count |
☐ |
|
rating_ids |
string |
|
☐ |
|
rating_last_feedback |
string |
Rating Last Feedback |
☐ |
|
rating_last_image |
byte[] |
Rating Last Image |
☐ |
|
rating_last_text |
string |
Rating Text |
☐ |
|
rating_last_value |
decimal |
Rating Last Value |
☐ |
|
rating_percentage_satisfaction |
decimal |
Rating Satisfaction |
☐ |
|
recurring_invoice |
boolean |
Subscription Product |
☐ |
If set, confirming a sale order with this product will create a subscription |
rent_ok |
boolean |
Can be Rented |
☐ |
Allow renting of this product. |
reordering_max_qty |
decimal |
Reordering Max Qty |
☐ |
|
reordering_min_qty |
decimal |
Reordering Min Qty |
☐ |
|
responsible_id_label |
string |
|
☐ |
This user will be responsible of the next activities related to logistic operations for this product. |
responsible_id |
string |
|
☐ |
This user will be responsible of the next activities related to logistic operations for this product. |
route_from_categ_ids |
string |
|
☐ |
|
route_ids |
string |
|
☐ |
Depending on the modules installed, this will allow you to define the route of the product: whether it will be bought, manufactured, replenished on order, etc. |
sale_delay |
decimal |
Customer Lead Time |
☐ |
Delivery lead time, in days. It's the number of days, promised to the customer, between the confirmation of the sales order and the delivery. |
sale_line_warn_msg |
string |
Message for Sales Order Line |
☐ |
|
sale_line_warn |
string |
Sales Order Line |
☑ |
Selecting the "Warning" option will notify user with the message, Selecting "Blocking Message" will throw an exception with the message and block the flow. The Message has to be written in the next field. |
sale_ok |
boolean |
Can be Sold |
☐ |
|
sales_count |
decimal |
Sold |
☐ |
|
seller_ids |
string |
|
☐ |
|
seo_name |
string |
Seo name |
☐ |
|
sequence |
int32 |
Sequence |
☐ |
Gives the sequence order when displaying a product list |
service_policy |
string |
Service Invoicing Policy |
☐ |
|
service_to_purchase |
boolean |
Subcontract Service |
☐ |
If ticked, each time you sell this product through a SO, a RfQ is automatically created to buy the product. Tip: don't forget to set a vendor on the product. |
service_tracking |
string |
Create on Order |
☐ |
On Sales order confirmation, this product can generate a project and/or task. From those, you can track the service you are selling.'In sale order's project': Will use the sale order's configured project if defined or fallback to creating a new project based on the selected template. |
service_type |
string |
Track Service |
☐ |
Manually set quantities on order: Invoice based on the manually entered quantity, without creating an analytic account.Timesheets on contract: Invoice based on the tracked hours on the related timesheet.Create a task and track hours: Create a task on the sales order validation and track the work hours. |
service_upsell_threshold_ratio |
string |
Service Upsell Threshold Ratio |
☐ |
|
service_upsell_threshold |
decimal |
Threshold |
☐ |
Percentage of time delivered compared to the prepaid amount that must be reached for the upselling opportunity activity to be triggered. |
show_availability |
boolean |
Show availability Qty |
☐ |
|
show_forecasted_qty_status_button |
boolean |
Show Forecasted Qty Status Button |
☐ |
|
show_on_hand_qty_status_button |
boolean |
Show On Hand Qty Status Button |
☐ |
|
standard_price |
decimal |
Cost |
☐ |
Value of the product (automatically computed in AVCO).Used to value the product when the purchase cost is not known (e.g. inventory adjustment).Used to compute margins on sale orders. |
supplier_taxes_id |
string |
|
☐ |
Default taxes used when buying the product. |
tax_string |
string |
Tax String |
☐ |
|
taxes_id |
string |
|
☐ |
Default taxes used when selling the product. |
template_folder_id_label |
string |
|
☐ |
On sales order confirmation, a workspace will be automatically generated for the project based on this template. |
template_folder_id |
string |
|
☐ |
On sales order confirmation, a workspace will be automatically generated for the project based on this template. |
to_weight |
boolean |
To Weigh With Scale |
☐ |
Check if the product should be weighted using the hardware scale integration. |
tracking |
string |
Tracking |
☑ |
Ensure the traceability of a storable product in your warehouse. |
type |
string |
Type |
☐ |
|
uom_id_label |
string |
|
☐ |
Default unit of measure used for all stock operations. |
uom_id |
string |
|
☐ |
Default unit of measure used for all stock operations. |
uom_name |
string |
Unit of Measure Name |
☐ |
|
uom_po_id_label |
string |
|
☐ |
Default unit of measure used for purchase orders. It must be in the same category as the default unit of measure. |
uom_po_id |
string |
|
☐ |
Default unit of measure used for purchase orders. It must be in the same category as the default unit of measure. |
used_in_bom_count |
int32 |
# of BoM Where is Used |
☐ |
|
valid_product_template_attribute_line_ids |
string |
|
☐ |
|
valuation |
string |
Inventory Valuation |
☐ |
Manual: The accounting entries to value the inventory are not posted automatically.Automated: An accounting entry is automatically created to value the inventory when a product enters or leaves the company. |
variant_seller_ids |
string |
|
☐ |
|
version |
int32 |
Version |
☐ |
The current version of the product. |
virtual_available |
decimal |
Forecasted Quantity |
☐ |
|
visible_expense_policy |
boolean |
Re-Invoice Policy visible |
☐ |
|
visible_qty_configurator |
boolean |
Quantity visible in configurator |
☐ |
|
volume_uom_name |
string |
Volume unit of measure label |
☐ |
|
volume |
decimal |
Volume |
☐ |
|
warehouse_id_label |
string |
|
☐ |
|
warehouse_id |
string |
|
☐ |
|
website_description |
string |
Description for the website |
☐ |
|
website_id_label |
string |
|
☐ |
Restrict publishing to this website. |
website_id |
string |
|
☐ |
Restrict publishing to this website. |
website_message_ids |
string |
|
☐ |
Website communication history |
website_meta_description |
string |
Website meta description |
☐ |
|
website_meta_keywords |
string |
Website meta keywords |
☐ |
|
website_meta_og_img |
string |
Website opengraph image |
☐ |
|
website_meta_title |
string |
Website meta title |
☐ |
|
website_published |
boolean |
Visible on current website |
☐ |
|
website_ribbon_id_label |
string |
|
☐ |
|
website_ribbon_id |
string |
|
☐ |
|
website_sequence |
int32 |
Website Sequence |
☐ |
Determine the display order in the Website E-commerce |
website_size_x |
int32 |
Size X |
☐ |
|
website_size_y |
int32 |
Size Y |
☐ |
|
website_url |
string |
Website URL |
☐ |
The full URL to access the document through the website. |
weight_uom_name |
string |
Weight unit of measure label |
☐ |
|
weight |
decimal |
Weight |
☐ |
|
worksheet_template_id_label |
string |
|
☐ |
|
worksheet_template_id |
string |
|
☐ |
|
write_date |
datetime |
Last Updated on |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
01-03-2023 15:29 Version 22.1.135-BETA+3826