update <@PREFIX@>vm_product set 
VENDOR_ID='1',
PRODUCT_PARENT_ID='0',
PRODUCT_SKU='<@SSTOCKCODE@>',
PRODUCT_S_DESC='<@SPROD_S_DESC@>',
PRODUCT_DESC='<@LONGDESC@>',
PRODUCT_WEIGHT=<@FGROSSWEIGHT@>,
PRODUCT_WEIGHT_UOM='kg',
PRODUCT_IN_STOCK='<@FQTYONHAND@>',
PRODUCT_AVAILABILITY='24h.gif',
PRODUCT_SPECIAL='N',
CDATE= UNIX_TIMESTAMP(cast(Now() as char(20))),
PRODUCT_NAME='<@SEXTRADESCR@>',
PRODUCT_TAX_ID='<@PROCESS@>@select imp_extid from IMP_LINK where WTaxid = <@WOUTPUTTAXID@> and imp_sourceid =<@SOURCEID@> ##',
PRODUCT_UNIT=''
where PRODUCT_ID = <@KEY@>
@@GO@@
delete from  <@PREFIX@>jf_content where reference_id = <@KEY@> and reference_table='vm_product' and reference_field = 'product_name' 
and LANGUAGE_ID not in ( 
<@PROCESS@>*SELECT substring(a.imp_EXTID from 6 for 10) a from IMP_LINK a
join IMP_SOURCE_LANGS b on b.WLANGID = a.WGROUPID and b.IMP_SOURCEID = <@SOURCEID@>
where a.imp_sourceid = <@SOURCEID@> and WGroupid is not null and IMP_EXTID like 'LANG:%' ## 
)
@@GO@@
delete from  <@PREFIX@>jf_content where reference_id = <@KEY@> and reference_table='vm_product' and reference_field = 'product_s_desc' 
and LANGUAGE_ID not in ( 
<@PROCESS@>*SELECT substring(a.imp_EXTID from 6 for 10) a from IMP_LINK a
join IMP_SOURCE_LANGS b on b.WLANGID = a.WGROUPID and b.IMP_SOURCEID = <@SOURCEID@>
where a.imp_sourceid = <@SOURCEID@> and WGroupid is not null and IMP_EXTID like 'LANG:%' ## 
)
@@GO@@
delete from  <@PREFIX@>jf_content where reference_id = <@KEY@> and reference_table='vm_product' and reference_field = 'product_desc' 
and LANGUAGE_ID not in ( 
<@PROCESS@>*SELECT substring(a.imp_EXTID from 6 for 10) a from IMP_LINK a
join IMP_SOURCE_LANGS b on b.WLANGID = a.WGROUPID and b.IMP_SOURCEID = <@SOURCEID@>
where a.imp_sourceid = <@SOURCEID@> and WGroupid is not null and IMP_EXTID like 'LANG:%' ## 
)
@@GO@@
delete from <@PREFIX@>vm_product_category_xref where product_id = <@KEY@>
@@GO@@
delete from <@PREFIX@>vm_product_relations where product_id = <@KEY@>
@@GO@@