delete from <@PREFIX@>jshopping_products_prices
where product_id = <@KEY@> 
@@GO@@
delete from <@PREFIX@>jshopping_products_to_categories
where product_id =  <@KEY@> 
@@GO@@
delete from <@PREFIX@>jshopping_products_images
where product_id =  <@KEY@> 
@@GO@@ 
update <@PREFIX@>jshopping_products set
different_prices = '0',
product_is_add_price = '0',
currency_id = '1',
osf_id = '<@WSTOCKID@>',
product_quantity = <@FQTYONHAND@>,
product_ean = '<@SSTOCKCODE@>',
product_buy_price = <@FUNITCOST@>,
date_modify = now(),
product_weight = <@FNETTOWEIGHT@> , 
product_publish = <@STOCKSTATUS@>, 
product_tax_id = <@PROCESS@>@select imp_extid from IMP_LINK where WTaxid = <@WOUTPUTTAXID@> and imp_sourceid =<@SOURCEID@> ##,
product_manufacturer_id = coalesce((select  manufacturer_id from <@PREFIX@>jshopping_manufacturers where `name_nl-NL` = '<@SMANUFACTURER@>'),0)
where product_id = <@KEY@> 






