update products set 
products_quantity= <@FQTYONHAND@>,
products_model = '<@SSTOCKCODE@>',
products_image = '<@IMAGE@><@EXT@>',  
products_price = <@FSELLINGPRICE1@>, 
products_last_modified = now(), 
products_weight = <@FNETTOWEIGHT@> , 
products_status = <@STOCKSTATUS@>, 
products_tax_class_id = <@PROCESS@>@select imp_extid from IMP_LINK where WTaxid = <@WOUTPUTTAXID@> and imp_sourceid =<@SOURCEID@> ##,
manufacturers_id = 0, 
products_ordered = 0
where products_id = <@KEY@>
@@GO@@
delete from products_description where products_id = <@KEY@>
@@GO@@
delete from products_to_categories where products_id = <@KEY@>
@@GO@@
delete from products_accessoires where products_id =  <@KEY@>
@@GO@@
delete from products_xsell where products_id =  <@KEY@>
@@GO@@
update products
 set 
products_image = '',
products_subimage1 = '',
products_subimage2 = '',
products_subimage3 = '',
products_subimage4 = '',
products_subimage5 = '',
products_subimage6 = ''
where products_id = <@KEY@> and <@UPLIMAGES@> = 1
@@GO@@
delete from products_attributes where products_id =  <@KEY@>
@@GO@@
delete from products_attributes_groups 
where products_attributes_id not in  (
select a.products_attributes_id from products_attributes a where a.products_id = <@KEY@>)
and products_id = <@KEY@>
@@GO@@
delete from products_stock where products_id =  <@KEY@>
@@GO@@
delete from specials where products_id =  <@KEY@> 
@@GO@@





