update <@PREFIX@>hikashop_product
set  
product_name = '<@SDESCRIPTION@>', 
product_description =  '<@SEXTRADESC@>', 
product_quantity = '<@FQTYONHAND@>', 
product_code = '<@SSTOCKCODE@>',
product_published = '<@STOCKSTATUS@>', 
product_tax_id ='<@PROCESS@>@select imp_extid from IMP_LINK where WTaxid = <@WOUTPUTTAXID@> and imp_sourceid =<@SOURCEID@> ##',
product_weight = '<@FNETTOWEIGTH@>',  
product_modified = unix_timestamp() 
  
where   product_id = <@KEY@> 
@@GO@@
delete from <@PREFIX@>hikashop_product_category where product_id = <@KEY@>
@@GO@@
delete from <@PREFIX@>hikashop_price where price_product_id = <@KEY@>
@@GO@@
delete from <@PREFIX@>hikashop_file where file_ref_id= <@KEY@> and file_type = 'product' and <@UPLIMAGES@> = 1 
@@GO@@