UPDATE `qs_Settings` SET `label` = 'From Email Address' WHERE `qs_Settings`.`name` = 'siteFrom';
UPDATE `qs_SettingsCategory` SET `name` = 'General Settings' WHERE `qs_SettingsCategory`.`id` =1;
-- Email Templates
UPDATE `qs_Settings` SET `label` = CONCAT(`label`, ' If you leave this field empty - the From Email Address will be the same as the one in General Settings.')
WHERE `name` IN (
'contactFormEmailFrom',
'newsletterFormEmailFrom',
'newsletterFormUserEmailFrom',
'giftCardEmailFrom',
'blogCommentEmailFrom'
) ;
-- Account Email Templates
UPDATE `qs_Settings` SET `label` = CONCAT(`label`, ' If you leave this field empty - the From Email Address will be the same as the one in General Settings.')
WHERE `name` IN (
'forgotPasswordEmailFrom',
'userRegistrationEmailFrom',
'userRegistrationAdminEmailFrom'
) ;
-- Order Templates
UPDATE `qs_Settings` SET `label` = CONCAT(`label`, ' If you leave this field empty - the From Email Address will be the same as the one in General Settings.')
WHERE `name` IN (
'eCommerceOrderOrderStatusNewUserEmailFrom',
'eCommerceOrderOrderStatusPackedUserEmailFrom',
'eCommerceOrderOrderStatusSentUserEmailFrom',
'eCommerceOrderOrderStatusClosedUserEmailFrom',
'eCommerceOrderPaidStatusYesUserEmailFrom',
'eCommerceOrderPaidStatusNoUserEmailFrom',
'eCommerceOrderSubmitUserEmailFrom',
'eCommerceOrderSubmitAdminEmailFrom',
'eCommerceOrderChangedUserEmailFrom'
) ;