Missing message templates

I have a suggestion to enhance the current functionality of message templates.

The current (1.4) functionality is that if a localized message template is missing, the message is not sent.
This applies, for example, to all e-mail messages for orders.

A better functionality, in my mind, would be if default (English) message would be sent, along with a message to the store owner explaining that a non-localized message was sent and how to correct the problem.

Hi,

Mabee this can help you:

/****** SQL that selects/inserts the new/missing LocaleStringResource - compares Danish(7) to English(9)   ******/
use [databasename]
INSERT INTO [dbo].[Nop_MessageTemplateLocalized]
SELECT t2.[MessageTemplateID]
      ,9
      ,[Subject]
      ,[Body]
      ,[BCCEmailAddresses]
      ,[IsActive]
FROM [dbo].[Nop_MessageTemplateLocalized] t2
  WHERE t2.LanguageID=7 AND t2.[MessageTemplateID] NOT IN
(SELECT t1.[MessageTemplateID]
  FROM [dbo].[Nop_MessageTemplateLocalized] t1
  WHERE t1.LanguageID = 9)

also I use this:


/****** SQL that selects/inserts the new/missing LocaleStringResource - compares Danish(7) to English(9)   ******/
use slikfabrikken_V1_50_94780
INSERT INTO [dbo].[Nop_LocaleStringResource]
SELECT 9,t2.ResourceName,'' + t2.ResourceValue
--SELECT 9,t2.ResourceName,'TODO: ' + t2.ResourceValue
  FROM [dbo].[Nop_LocaleStringResource] t2
WHERE t2.LanguageID=7 AND t2.[ResourceName] NOT IN
(SELECT t1.[ResourceName]
  FROM [dbo].[Nop_LocaleStringResource] t1
  WHERE t1.LanguageID = 9)


Best regards

http://www.slikfabrikken.dk