// insert in to Ecommerce database for stock type

INSERT INTO products (
products_id, 
products_quantity, 
products_model, 
products_image, 
products_price, 
products_date_added, 
products_last_modified, 
products_date_available, 
products_weight, 
products_status, 
products_tax_class_id, 
manufacturers_id, 
products_ordered
)

values(
null,
<@FQTYONHAND@>,
'<@SSTOCKCODE@>', 
'<@IMAGE@><@EXT@>',  
<@FSELLINGPRICE1@>,
now(), 
now(), 
now(), 
<@FNETTOWEIGHT@>,
<@STOCKSTATUS@>, 
<@PROCESS@>@select imp_extid from IMP_LINK where WTaxid = <@WOUTPUTTAXID@> and imp_sourceid =<@SOURCEID@> ##,
(select  manufacturers_id from manufacturers where manufacturers_name = '<@SMANUFACTURER@>'), 
0
)
 