SendOrderNotification
Send an order notification email to the customer.
Stored Procedure Specific Information
Execute
Sends an order notification email to the customer using a specified email template. Use the Email input to override the recipient address, and ForceEmailUpdate to also update the billing email address on the order.
EXEC SendOrderNotification OrderId='723', TemplateId='customer_completed_order';
EXEC SendOrderNotification OrderId='723', TemplateId='customer_invoice', Email='[email protected]', ForceEmailUpdate='true';
Input
| Name | Type | Required | Description |
| OrderId | String | True | The ID of the order. |
| TemplateId | String | True | The identifier of the email template to send (e.g. customer_completed_order). |
| String | False | The email address to send the notification to. Defaults to the billing email address. | |
| ForceEmailUpdate | Boolean | False | When true, the billing email address of the order is updated to the one provided before sending. Default is false. |
Result Set Columns
| Name | Type | Description |
| Success | String | This value shows a boolean indication of whether the operation was successful or not. |
| Message | String | A message confirming that the email was sent. |