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' ) ;