Please enable JavaScript to view this site.

Navigation: Schema: product > Tables

product

Product Variant

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

 

 

additional_product_tag_ids

string

 

 

all_product_tag_ids

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

 

avg_cost

decimal

Average Cost

 

barcode

string

Barcode

International Article Number used for product identification.

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_image_variant_1024_be_zoomed

boolean

Can Variant Image 1024 be zoomed

 

can_publish

boolean

Can Publish

 

categ_id_label

string

 

 

categ_id

string

 

 

code

string

Reference

 

color

int32

Color Index

 

combination_indices

string

Combination Indices

 

company_currency_id_label

string

 

Technical field to correctly show the currently selected company's currency that corresponds to the totaled value of the product's valuation layers

company_currency_id

string

 

Technical field to correctly show the currently selected company's currency that corresponds to the totaled value of the product's valuation layers

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

Publish On eBay

 

ebay_variant_url

string

eBay Variant URL

 

eco_count

int32

# ECOs

 

eco_ids

string

 

 

event_ticket_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

 

free_qty

decimal

Free To Use Quantity

Forecast quantity (computed as Quantity On Hand - reserved quantity)In a context with a single Stock Location, this includes goods stored in this location, or any of its children.In a context with a single Warehouse, this includes goods stored in the Stock Location of this Warehouse, or any of its children.Otherwise, this includes goods stored in any Stock Location with 'internal' type.

fsm_partner_price_currency_id_label

string

 

 

fsm_partner_price_currency_id

string

 

 

fsm_partner_price

decimal

Partner Price

 

fsm_quantity

decimal

Material Quantity

 

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

 

image_variant_1024

byte[]

Variant Image 1024

 

image_variant_128

byte[]

Variant Image 128

 

image_variant_1920

byte[]

Variant Image

 

image_variant_256

byte[]

Variant Image 256

 

image_variant_512

byte[]

Variant Image 512

 

incoming_qty

decimal

Incoming

Quantity of planned incoming products.In a context with a single Stock Location, this includes goods arriving to this Location, or any of its children.In a context with a single Warehouse, this includes goods arriving to the Stock Location of this Warehouse, or any of its children.Otherwise, this includes goods arriving to any Stock Location with 'internal' type.

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

 

 

lst_price

decimal

Sales Price

The sale price is managed from the product template. Click on the 'Configure Variants' button to set the extra attribute prices.

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

orderpoint_ids

string

 

 

out_of_stock_message

string

Out-of-Stock Message

 

outgoing_qty

decimal

Outgoing

Quantity of planned outgoing products.In a context with a single Stock Location, this includes goods leaving this Location, or any of its children.In a context with a single Warehouse, this includes goods leaving the Stock Location of this Warehouse, or any of its children.Otherwise, this includes goods leaving any Stock Location with 'internal' type.

packaging_ids

string

 

Gives the different ways to package the same product.

partner_ref

string

Customer Ref

 

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.

price_extra

decimal

Variant Price Extra

This is the sum of the extra price of all attributes

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_attribute_value_ids

string

 

 

product_template_image_ids

string

 

 

product_template_variant_value_ids

string

 

 

product_tmpl_id_label

string

 

 

product_tmpl_id

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

 

 

product_variant_image_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

 

purchase_order_line_ids

string

 

 

purchased_product_qty

decimal

Purchased

 

putaway_rule_ids

string

 

 

qty_available

decimal

Quantity On Hand

Current quantity of products.In a context with a single Stock Location, this includes goods stored at this Location, or any of its children.In a context with a single Warehouse, this includes goods stored in the Stock Location of this Warehouse, or any of its children.stored in the Stock Location of the Warehouse of this Shop, or any of its children.Otherwise, this includes goods stored in any Stock Location with 'internal' type.

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

 

quantity_decreasable

boolean

Quantity Decreasable

 

quantity_svl

decimal

Quantity Svl

 

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

serial_missing

boolean

Serial Missing

 

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.

stock_move_ids

string

 

 

stock_notification_partner_ids

string

 

 

stock_quant_ids

string

 

 

stock_valuation_layer_ids

string

 

 

storage_category_capacity_ids

string

 

 

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.

total_value

decimal

Total Value

 

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

# BoM Where Used

 

valid_ean

boolean

Barcode is valid EAN

 

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.

value_svl

decimal

Value Svl

 

variant_bom_ids

string

 

 

variant_seller_ids

string

 

 

version

int32

Version

The current version of the product.

virtual_available

decimal

Forecasted Quantity

Forecast quantity (computed as Quantity On Hand - Outgoing + Incoming)In a context with a single Stock Location, this includes goods stored in this location, or any of its children.In a context with a single Warehouse, this includes goods stored in the Stock Location of this Warehouse, or any of its children.Otherwise, this includes goods stored in any Stock Location with 'internal' type.

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

Write Date

 

write_uid_label

string

 

 

write_uid

string

 

 

 

01-03-2023 15:29 Version 22.1.135-BETA+3826

X

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

  • Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
  • Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
  • Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
  • Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
  • Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
  • Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
  • Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
  • Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.

  
Disclaimer