-- 2013-04-24
DELETE FROM `apw_Settings` WHERE NAME LIKE 'transactionStatusChangedUserEmail%';
-- 2013-04-26
UPDATE `apw_Settings`
SET `value` = 'Order #{orderId} has been submitted
\r\n\r\n\r\n \r\n \r\n \r\n Billing Information\r\n\r\n \r\n \r\n \r\n | Full Name: | \r\n {billingFirstName} {billingLastName} | \r\n \r\n \r\n | Address: | \r\n {billingAddress} | \r\n \r\n \r\n | City/State/Zip: | \r\n {billingCityStateZip} | \r\n \r\n \r\n \r\n | \r\n | \r\n \r\n Payment Information\r\n\r\n \r\n \r\n \r\n | Payment Method: | \r\n {paymentTypeTitle} | \r\n \r\n| Paid: | {paid} |
|---|
\r\n \r\n | {paymentInformation} | \r\n \r\n \r\n \r\n | \r\n
\r\n \r\n
\r\n
\r\n
\r\n{cartItems}
\r\n
\r\n{viewDetailsLink}',
`description` = 'Constants: {orderId} {billingFirstName} {billingLastName} {billingAddress} {billingCityStateZip} {paymentTypeTitle} {paid} {status} {subtotal} {tax} {total} {cartItems} {link} {paymentInformation} {viewDetailsLink}'
WHERE `name` = 'eCommerceOrderSubmitUserEmailBody'
LIMIT 1;
UPDATE `apw_Settings`
SET `value` = 'Order #{orderId} has been submitted
\r\n \r\n\r\n\r\n \r\n \r\n \r\n Billing Information\r\n\r\n \r\n \r\n \r\n | Full Name: | \r\n {billingFirstName} {billingLastName} | \r\n \r\n \r\n | Address: | \r\n {billingAddress} | \r\n \r\n \r\n | City/State/Zip: | \r\n {billingCityStateZip} | \r\n \r\n \r\n \r\n | \r\n | \r\n \r\n Payment Information\r\n\r\n \r\n \r\n \r\n | Payment Method: | \r\n {paymentTypeTitle} | \r\n \r\n \r\n \r\n | \r\n
\r\n \r\n
\r\n
\r\n
\r\n{cartItems}\r\nClick here to view details.
\r\n',
`description` = 'Constants: {orderId} {billingFirstName} {billingLastName} {billingAddress} {billingCityStateZip} {paymentTypeTitle} {paid} {status} {subtotal} {tax} {total} {cartItems} {adminAdditionalNote} {link}'
WHERE `name` = 'eCommerceOrderSubmitAdminEmailBody'
LIMIT 1;