INSERT IGNORE INTO `multicart_email_templates` (`vtemplate_name`, `vtemplate_title`, `vemail_body`, `vreplaceable_variables`, `vtemplate_flag`) VALUES
( 'referral_registration', 'New User Registered With Referral To Affliate', 'Dear [affliate_name],\r\n\r\nA new user has been registered with your referral link\r\nwith [site_name].\r\n\r\nYou will get commission on his/her first purchase.\r\n\r\nUser Details are as  follows\r\n\r\nFirst Name :- [first_name]\r\n\r\nLast Name :- [last_name]\r\n\r\nWith warm regards,\r\n\r\n[site_name]  Team ', '[site_name], [account_details],[affliate_name],[first_name],[\'last_name\']', 'A'),
('referral_user_purchase', 'Referral User Purchased mail from admin to affliate', 'Dear [affiliate_name],\r\n\r\nReferral User purchased his first products,You will get commission on user first purchase.\r\n\r\nSite Owner will settle the payment once the item got delivered.\r\n\r\nPlease login in to your affiliate panel to view the commission details\r\n\r\n\r\n\r\nWith warm regards,\r\n\r\n[site_name]  Team ', '[affiliate_name],[site_name]', 'A'),
('affliate_settlement_mail', 'Affliate Settlement Mail From Admin to affiliate', 'Dear [affiliate_name],\r\n\r\nAdministrator has settle the referral commission.\r\n\r\nCommission amount is : [commission_amount]\r\n\r\nPlease login to view further details\r\n\r\n[login_link]\r\n\r\n\r\n\r\nWith warm regards,\r\n\r\n[site_name]  Team ', '[affiliate_name],[site_name],[commission_amount],[login_link]', 'A');
