// insert in to Ecommerce database for stock type
insert into <@PREFIX@>vm_product (
VENDOR_ID,
PRODUCT_PARENT_ID,
PRODUCT_SKU,
PRODUCT_S_DESC,
PRODUCT_DESC,
PRODUCT_PUBLISH,
PRODUCT_WEIGHT, 
PRODUCT_WEIGHT_UOM,
PRODUCT_LENGTH,
PRODUCT_WIDTH,
PRODUCT_HEIGHT,
PRODUCT_LWH_UOM,
PRODUCT_URL,
PRODUCT_IN_STOCK,
PRODUCT_AVAILABLE_DATE,
PRODUCT_AVAILABILITY,
PRODUCT_SPECIAL,
PRODUCT_DISCOUNT_ID,
SHIP_CODE_ID,
CDATE,
MDATE,
PRODUCT_NAME,
ATTRIBUTE,
CUSTOM_ATTRIBUTE,
PRODUCT_TAX_ID,
PRODUCT_UNIT,
PRODUCT_PACKAGING)

values(
'1',
'0',
'<@SSTOCKCODE@>',
'<@SPROD_S_DESC@>',
'<@LONGDESC@>',  
'<@STOCKSTATUS@>',
'<@FGROSSWEIGHT@>',
'kg',
0.00,
0.00,
0.00,
'',
'',
'<@FQTYONHAND@>',
UNIX_TIMESTAMP(cast(Now() as char(20))),
'24h.gif',
'N',
'0',
''
, UNIX_TIMESTAMP(cast(Now() as char(20))),
UNIX_TIMESTAMP(cast(Now() as char(20))),
'<@SEXTRADESC@>',
'',
'',
'<@PROCESS@>@select imp_extid from IMP_LINK where WTaxid = <@WOUTPUTTAXID@> and imp_sourceid =<@SOURCEID@> ##',
'',
'65536')
 
