product_id
int unsigned
(10)
product_title
string
(255)
product_price_base
decimal unsigned
(8,2)
Default value: 0.00
product_icon
string
(255)
product_gallery
string
(4294967295)
product_content
string
(4294967295)
product_order_form
string
(4294967295)
product_created_datetime
datetime
product_modified_datetime
datetime
product_deleted_datetime
datetime
product_is_offline
0 or 1
product_is_unorderable
0 or 1
product_is_orderable_for_someone_else
0 or 1
product_disables_guest_checkout
0 or 1
product_barcode
string
(31)
product_sales_description
string
(255)
product_order_options
string
(16777215)
product_is_shipping_required
0 or 1
Default value: 1
product_shipping_width_mm
int unsigned
(10)
product_shipping_height_mm
int unsigned
(10)
product_shipping_depth_mm
int unsigned
(10)
product_shipping_weight_g
int unsigned
(10)
product_inventory_level
int unsigned
(10)
product_inventory_is_public
0 or 1
product_inventory_is_unorderable_sold_out
0 or 1
product_brand_id
int unsigned
(10)
product_group_visibility
string
(16777215)
product_group_visibility_hidden_in_lists
0 or 1
product_max_quantity
int unsigned
(10)
product_min_quantity
int unsigned
(10)
product_uri_suffix
string
(255)
product_uri_suffix_is_overridden
0 or 1
product_search_keywords
string
(255)
product_search_keywords_is_overridden
0 or 1
product_search_title
string
(255)
product_search_title_is_overridden
0 or 1
product_search_description
string
(255)
product_search_description_is_overridden
0 or 1