// insert in to Ecommerce database for stock type

INSERT INTO customers
(
customers_GENDER,
customers_username,
customers_firstname,
customers_lastname,
customers_email_address,
customers_telephone,
customers_fax,
customers_newsletter,
customers_view_category
)

values(
'<@GENDER@>',
'<@SACCOUNTCODE@>',
'<@NAME@>',
'<@LASTNAME@>', 
'<@SEMAIL@>', 
'<@STELEPHONE1@>',
'<@SFAX@>',
'0',0)
@@GO@@
replace into customers_info set 
CUSTOMERS_INFO_ID= LAST_INSERT_ID(),
CUSTOMERS_INFO_DATE_OF_LAST_LOGON=now(),
CUSTOMERS_INFO_NUMBER_OF_LOGONS='0',
CUSTOMERS_INFO_DATE_ACCOUNT_CREATED=now(),
CUSTOMERS_INFO_DATE_ACCOUNT_LAST_MODIFIED=now(),
CUSTOMERS_INFO_SOURCE_ID='0',
GLOBAL_PRODUCT_NOTIFICATIONS='0',
CUSTOMERS_INFO_IP_ADDRESS_DA_ACC_LAST_MOD='',
CUSTOMERS_INFO_IP_ADDRESS_DA_ACC_CRE=''
@@GO@@

