Hello [first name] [Last name],
\nYour store registration was successful.
\nYou can log in to your customer account any time to see the status of your orders.
\nTo access your account, go to [url]
\nLog in with your email [license email] and the password you selected when you created your account.
\nBe sure to save this information for future reference.
\nIf you have any questions, please feel free to contact
\nus using the store\'s \"Contact Us\" link
\nRegards,
\nStore Admin
\n\n\n","
Email Used when user Register with us. Sends this mail to welcome them
\n","1","1","2017-11-10 00:00:00","2018-06-05 15:04:02"); INSERT INTO email_templates VALUES("2","1","forget_password","Forgot Password","Reset Password Request","\n\n\n\n\nHi [first name] [last name]
\nWe received your request to reset your password.
\nTo reset your password, click the following link:
\n[reset link]
\n\n
Your login email is: [license email]
\n\n
Regards,
\nStore Admin
\n\n","If user forgets their password and request for new one ","3","1","2017-11-10 00:00:00","2018-06-05 15:00:49"); INSERT INTO email_templates VALUES("3","1","reset_password","Reset Password Successfully","Password Reset Successfully","\n\n\n\n\nHi [first name] [last name]
\nYou have successfully reset your password.
\n\n
Your login email is: [license email]
\n\n
Regards,
\nStore Admin
\n\n","Confirms their password reset request is successful.","2","1","2017-11-10 00:00:00","2018-06-05 14:59:24"); INSERT INTO email_templates VALUES("4","1","contact_us","Contact Us","RE: New Contact Request from Customer","\n\n\n\n\nHello [first name] [Last name]
\nYou received the following message from a customer:
\n[message]
\nDate: [date and time]
\nPlease reply to: [licence email]
\nRegards,
\nStore admin
[store admin first name] [store admin last name]
This email is used when user wants to contact with the admin and posts their query.
\n","4","1","2017-11-13 00:00:00","2020-06-18 00:15:08"); INSERT INTO email_templates VALUES("5","1","subscription","Subscription","Your new subscription","\n\n\n\n\nHello Subscriber,
\nThank you for subscribing using the email address [license email]
\non [date and time]
\nWe will update you regularly with our offers and discounts.
\n\n
Regards,
\nStore Admin
\n\n","Confirmation that user is successfully subscribed
\n","5","1","2017-11-13 00:00:00","2020-06-12 04:56:57"); INSERT INTO email_templates VALUES("6","1","guest_register","Guest Registration","Congratulations You are registered","\n\n\n\n\nHello [first name] [Last name]
\nThank you for registering.
\nTo gain access , click this link: [url]
\n\n
Then sign in using these credentials:
\nEmail: [license email]
\nPassword: [password]
\nBe sure to save these details securely to facilitate logging in the future.
\nThe system is simple to access and operate. If you have any trouble or any questions, please feel free to contact us via Contact Us form on the store\'s website
\nOnce again, thank you for choosing us!
\nStore Admin
Hello [first name] [Last name]
\nHere are the details of your order:
\n[product details]
\n[address] , [city], [state] [zipcode]
\n[country]
\nTotal: [amount]
\nOrdered on [date and time]
\n\n
Thank You for shopping with us.
\nShop Admin
\n\n\n","Details of the orders including its shipping details order details and payment details","7","1","2017-11-16 00:00:00","2020-06-16 05:35:36"); INSERT INTO email_templates VALUES("8","1","status_of_product","Status Of Product","Your Product Status","\n\n\n\n\n
Hello [first name] [Last name]
\nRE: Your order [product name]
\nQuantity - [product quantity]
\nAmount Paid: [product price]
\nOrder Status: [status]
\n\n
Thank You for shopping with us.
\nStore Admin
Hello [first name] [Last name]
\nYour scheduled payment was successful. Here are the details
\nProduct Name: [product name]
\nPrice: [recurring_price]
\nProduct Quantity: [product quantity]
\nTotal Amount Paid : [total]
\nPayment method: [mode]
\n\n
You can log in to your account using
login email [license email]
\n
Regards,
\nStore Admin
\n\n","This is to notify the user about their scheduled recurring payments is successful","9","1","2017-12-21 00:00:00","2018-06-05 14:27:43"); INSERT INTO email_templates VALUES("10","1","recurring_payment_failure","Recurring Payment Failure","Your Scheduled Payment Failed. Please Update Your Card.","\n\n\n\n\nHello [first name] [Last name]
\nYour scheduled payment failed for the most recent order:
\n[product name] x [product quantity]
\nAmount due = [total]
\nusing [mode]
\nPlease click on the link below to update your payment information.
\n[url]
\nYour username = [license email]
\n\n
Regards,
\nStore Admin
\n\n\n","This is to notify that the payment for their recurring order is failed.Kindly update their cards","10","1","2017-12-21 00:00:00","2020-06-12 03:19:28"); INSERT INTO email_templates VALUES("11","1","refund_successful","Refund Successful","Your Order was Successfully Refunded","\n\n\n\n\n
Hello [first name] [last name] ,
\nThe following order was successfully refunded:
\nProduct Name: [product name]
\nQuantity: [product quantity]
\nProduct Price : [product price]
\n\n
You can check your order status in your account associated with [license email] .
\n\n
Regards,
\nStore Admin
\n\n","This is to notify users refund request is successful and we have refunded for their order","8","1","2017-12-21 00:00:00","2020-06-12 03:22:20"); INSERT INTO email_templates VALUES("12","1","forget_password_admin","Admin Forget Password","Reset Store Admin Password","\n\n\n\n\nHi [first name] [last name]
\n\n
We received your request to reset your Admin password. If you did not
make this request, do nothing and your password will not be changed.
\n
Click here to reset password:
\n[reset link]
\n\n
Your login email is [license email]
\n\n","Admin password reset request ","3","1","2018-01-01 00:00:00","2018-06-05 14:07:15"); INSERT INTO email_templates VALUES("13","1","canceled_refund_request","Canceled Refund Request","Your refund request has been denied","\n\n\n\n\nHello [first name] [Last name]
\nYour refund request for [product quantity] [product name] for [product price] has been denied because your refund request is past the posted refund period.
\n\n
Store Admin
\n\n","cancelled refund request
\n","8","1","2018-01-11 00:00:00","2018-06-05 14:03:56"); INSERT INTO email_templates VALUES("14","1","sub_user_creation","Sub User Creation","Sub User Creation"," \n\n \n\n \n\n \n\n\nHello [first_name] ,
\nYou have successfully registered as a sub-user. Please note down your credentials.
\nEmail : [email]
\nPassword : [password]
\nLogin URL : [login_url]
\nThanks and Regards,
\n[admin_name]
\nAdmin
\n\n \n\n","
Sub User Creation
\n\n","11","1","2018-01-11 00:00:00","2020-06-12 03:28:11"); INSERT INTO email_templates VALUES("15","1","sale_summary","Sale Summary","Sale Order has been placed","\n\n\n\n\nHello
\nA new order has been placed by [first name] [Last name], [license email]
\n[product details]
\nAddress [address]
\nCity [city] , State [state]
\nCountry [country]
\n[zipcode]
\nTotal amount to be paid is $[amount]
\nOrdered on [date and time]
\n\n","Details of the sale orders placed including its shipping details, order details and payment details
\n","12","1","2020-03-27 00:00:00","2020-06-12 03:30:06"); INSERT INTO email_templates VALUES("16","1","email_gift_coupon","Email Gift Coupon","Gift Coupon","\n\n\n\n\nHi
\nHere is gift coupon for your enjoyment.
\nGift Coupon: [gift coupon name]
\nCoupon No.: [coupon no]
\nExpiry Date: [expiry date]
\n[gift coupon img]
\nThanks,
\n[customer first name] [customer last name]
\n\n\n","","13","1","2020-03-27 00:00:00","2020-06-12 03:32:47"); INSERT INTO email_template_type VALUES("1","[licence email],[first name],[last name],[url],[customer email],[customer password],[customer phone]","[license email],[first name],[Last name],[amount],[date and time], [password]","1","2017-11-10 00:00:00",""); INSERT INTO email_template_type VALUES("2","[license email],[first name],[last name],[date and time]","[license email],[first name],[last name],[date and time]","1","2017-11-10 00:00:00",""); INSERT INTO email_template_type VALUES("3","[license email],[first name],[last name],[reset link],[date and time]","[license email],[first name],[last name],[reset link],[date and time]","1","2017-11-10 00:00:00",""); INSERT INTO email_template_type VALUES("4","[licence email],[first name],[last name],[date and time],[message],[store admin first name],[store admin last name]","[license email],[first name],[Last name],[amount],[date and time], [password]","1","2017-11-13 00:00:00",""); INSERT INTO email_template_type VALUES("5","[license email],[date and time]","[license email],[date and time]","1","2017-11-13 00:00:00",""); INSERT INTO email_template_type VALUES("6","[licence email],[first name],[last name],[url],[password]","[license email],[first name],[Last name],[amount],[date and time], [password]","1","2017-11-15 00:00:00",""); INSERT INTO email_template_type VALUES("7","[licence email],[first name],[last name],[amount],[date and time],[city],[state],[country],[zipcode],[product details],[address]","[license email],[first name],[Last name],[amount],[date and time], [password]","1","2017-11-16 00:00:00",""); INSERT INTO email_template_type VALUES("8","[licence email],[first name],[last name],[date and time],[product name], [product price], [product quantity],[status]","[license email],[first name],[Last name],[date and time],[product name], [product price], [product quantity]","1","2017-11-21 00:00:00",""); INSERT INTO email_template_type VALUES("9","[licence email],[first name],[last name],[date and time],[product name], [recurring_price], [product quantity],[duration] ,[times],[total],[mode]","[license email],[first name],[Last name],[date and time],[product name], [product price], [product quantity]","1","2017-12-21 00:00:00",""); INSERT INTO email_template_type VALUES("10","[licence email],[first name],[last name],[date and time],[product name], [recurring_price], [product quantity],[duration] ,[times],[total],[mode],[url],[order_number]","[license email],[first name],[Last name],[date and time],[product name], [recurring_price], [product quantity],[duration] ,[times],[total],[mode],[order_number]","1","2017-12-21 00:00:00",""); INSERT INTO email_template_type VALUES("11","[email],[first name],[last name],[password],[login_url],[admin_name]","[email],[first name],[Last name],[password],[login_url],[admin_name]","1","2017-12-21 00:00:00","0000-00-00 00:00:00"); INSERT INTO email_template_type VALUES("12","[license email],[first name],[last name],[amount],[date and time],[city],[state],[country],[zipcode],[product details],[address]","[license email],[first name],[Last name],[amount],[date and time], [password]","1","2017-12-21 00:00:00","0000-00-00 00:00:00"); INSERT INTO email_template_type VALUES("13","[customer first name],[customer last name],[gift coupon name], [gift coupon img], [coupon no], [expiry date], [note]","[customer first name],[customer last name],[gift coupon name], [gift coupon img], [coupon no], [expiry date], [note]","1","2020-03-27 00:00:00","");