INSERT INTO <@PREFIX@>jshopping_products (
product_id, 
product_quantity, 
product_ean, 
 

product_date_added, 
date_modify, 
product_weight, 
product_publish, 
product_tax_id, 
product_manufacturer_id 

)

values(
null,
<@FQTYONHAND@>,
'<@SSTOCKCODE@>', 
 
now(), 
now(), 
<@FNETTOWEIGHT@>,
<@STOCKSTATUS@>, 
<@PROCESS@>@select imp_extid from IMP_LINK where WTaxid = <@WOUTPUTTAXID@> and imp_sourceid =<@SOURCEID@> ##,
coalesce(
(select  manufacturer_id from <@PREFIX@>jshopping_manufacturers where `name_nl-NL` = '<@SMANUFACTURER@>'),0)

)
 