Requirement
In the order confirmation email check whether we need to add online price crossed along with the special price for special items.
Also need to display the stock status of an item in the order confirmation email. We need to show if an item is out-of-stock or in-stock in confirmation email.
Our Solution
- We can achieve this requirement.
- We have to customize the email templates for both Webstore and NetSuite orders.
Webstore Orders:
- Currently the template we are using for Webstore orders is “Order Received 23/08/19 6:20:40 PM”. We need to customize this template to show the stock message and the online price.
- Currently the item table is in this format.
- We need to customize the table. A sample table is given below.
- Here along with the special price we will show the crossed online price if it is a sale item (Special item).
- In order to show the online price, first we need to create a column under the items subtab in sales order record.
- During the order creation we will set the online price under the items subtab using Workflow Action Script. We can add online price from this new custom field in the email.
- We will get the value from back ordered quantity field and if item is backordered, we will show “out of stock” message in each item line and otherwise” In stock” will be displayed.
NetSuite Orders:
Currently for NetSuite Orders, Email template is not created. So, if we want to show the same stock status message and online price in the NetSuite order emails, we have to the following.
- When we create Orders from NetSuite, then also we will set the online price corresponding to each item in the transaction line column (new custom field).
- We will create a new email template which will be similar to the website order email template. The online price will be show along with special price for sale items and it will be crossed as in website.
- If item is out of stock the “out of stock” message will be displayed in each item line and otherwise “In stock” will be displayed.
Assumptions
- A Transaction line field will be created in the Sales Order Record to set the online price from item record.
- For website orders “Order Received 23/08/19 6:20:40 PM” will be using.
- Only the UI of the Item details table will be edited in the email template. Other sections will be in the same format as it is.
- Currently for NetSuite Orders, Email template is not created. If we want to show the online price and stock status message, we have to create a separate email template. Please confirm on this
- “PC Sales Order” is the preferred transaction form used for the Sales order. Here, basic format is using. So that we cannot directly send the email during order creation. We will create a new email template and it will be sent using a Workflow.
- We will implement the functionality in production once it tested and verified in sandbox.