// insert in to Ecommerce database for stock type
insert into <@PREFIX@>hikashop_product(
product_parent_id, 
product_name, 
product_description, 
product_quantity, 
product_code,
product_published, 
product_hit, 
product_created, 
product_sale_start, 
product_sale_end, 
product_delay_id, 
product_tax_id, 
product_type, 
product_vendor_id, 
product_manufacturer_id, 
product_url, 
product_weight, 
product_keywords, 
product_weight_unit, 
product_modified, 
product_meta_description, 
product_dimension_unit, 
product_width, 
product_length,
product_height, 
product_max_per_order, 
product_access, 
product_group_after_purchase, 
product_min_per_order, 
product_contact, 
product_last_seen_date, 
product_sales, 
product_waitlist,
product_layout, 
product_average_score, 
product_total_vote, 
product_page_title, 
product_alias,
product_price_percentage, 
product_msrp, 
product_canonical, 
product_display_quantity_field,
product_warehouse_id,
product_quantity_layout)

values(
0, 
'<@SDESCRIPTION@>',
'<@SEXTRADESC@>' 
 , 
'<@FQTYONHAND@>', 
'<@SSTOCKCODE@>',
'<@STOCKSTATUS@>', 
0, 
unix_timestamp() , 
0, 
0, 
0, 
'<@PROCESS@>@select imp_extid from IMP_LINK where WTaxid = <@WOUTPUTTAXID@> and imp_sourceid =<@SOURCEID@> ##',
'main', 
0, 
0,
''
, 
'<@FNETTOWEIGTH@>', 
''
,'kg', 
unix_timestamp() ,
'' ,
 'm', 
0.000, 
0.000, 
0.000, 
0, 
'all', 
'' , 
0, 
0, 
0, 
0, 
0, 
''
,
 0,
 0, 
'', 
'<@SSTOCKCODE@>', 
0.0000000, 
0.0000000, 
'', 
0, 
0,'' ) 