Since you cannot add a new message template via the administration area (there is no 'new' button). Do you need to add a new template into the Database itself or is there another way to add a new message template?
Did somebody already done this. If so, can you give some information what steps you have taken.
We're using the following SQL script to add new message templates:
IF NOT EXISTS ( SELECT 1 FROM [dbo].[Nop_MessageTemplate] WHERE [Name] = N'YourTemplateName') BEGIN INSERT [dbo].[Nop_MessageTemplate] ([Name]) VALUES (N'YourTemplateName')
DECLARE @MessageTemplateID INT SELECT @MessageTemplateID = mt.MessageTemplateID FROM Nop_MessageTemplate mt WHERE mt.Name = N'YourTemplateName'
IF (@MessageTemplateID > 0) BEGIN INSERT [dbo].[Nop_MessageTemplateLocalized] ([MessageTemplateID], [LanguageID], [BCCEmailAddresses], [Subject], [Body]) VALUES (@MessageTemplateID, 7, N'', N'your email title', N'your email body') END END GO
- an automated confirmation to the customer’s email should read as follows Dear Valued Customer,
Thank you for your inquiry. At Yourstore.com, we strive to provide you with the best customer service by assisting each individual in great detail. As such, please note that we will respond to your inquiry between 24-48 hours. Best regards,
The Yourstore.com Team
Add a “SHOP NOW” box and link it to our site
do you think would that be helpful? sorry, i'm new to here. looking forward for a positive response.
Setup an auto responder on your mail server if you host your own site, server etc or use third party auto responder software to the email address's you want.
I would also like to add custom templates to our installation of nop, but the database has changed since the above solution was provided. Could you all show us how this is done in more current revisions?
This post is very old and that's why I am using it anyway as the topic is the same. But not sure if in new versions of Nop we're able to add new message templates. I had a look at the system templates but the Message templates is not there. Am using Nop 3.70 and am hoping to avoid having to resolve this in coding. I see no "Add" button in the admin area, which could be very useful.
From the existing templates list, some are missing that might be critical to store owners, at least they are to me and I would like to know how to resolve this:
- Refunded order: a message template for Vendor notification - Order cancellation: Vendor notification message template (that's critical to ensure that the vendor knows the order did not go through, and for accounting purposes) - Vendor account: Vendor notification to confirm activation of account
1. Click edit on any existing message template click copy template then edit the template as you need
2. Run SQL Script to create new message template
IF NOT EXISTS ( SELECT 1 FROM [dbo].[MessageTemplate] WHERE [Name]=N'Nop.Plugin.MyPlugin.OrderPlaced.CustomerNotification') BEGIN INSERT [dbo].[MessageTemplate] ([Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId],[LimitedToStores]) VALUES (N'Nop.Plugin.MyPlugin.OrderPlaced.CustomerNotification', NULL, N'Order receipt from %Store.Name%.', N'<p> Hi! This message from% Store.Name% </ p> ', 'true', null,0, 0,1,0) END GO
Note: Nop.Plugin.MyPlugin.OrderPlaced.CustomerNotification is just message template name you can add any name you like