Proposal Summary
This proposal covers the scope of sending the sales order status from NetSuite to Website.
Requirement
Blueleaf needs to transmit the sales order status from NetSuite to the website, adhering to the following mapping.
| Pending | Sales Order Pending Approval |
| Processing | Sales Order Pending Fulfilment |
| Despatched | Sales Order Pending Billing; Sales Order Partially Fulfilled / Pending Billing |
| Finished | Sales Order Billed |
| Cancelled | Sales Order Cancelled |
Sales orders that are under consideration must originate from the website, and they can be identified by the Site Order ID, which will always begin with the integer 5. In NetSuite, the orders will be created with either the status of “Pending Approval” or “Pending Fulfilment.”
The following API URL and Bearer Token can be used for sending the Sales order status details.
API URL: https://api.blueleafconnect.com/blueleaf/sandbox/order_status
Bearer token: rdoOdjnTPOkShpSJOix0fMQv8diOHdH2
The sales order status data will be sent at a frequency of every 30 minutes.
Prerequisites
- Provide an API URL to know the current order status of the website. If the order status is same as on the website, then we need to send the status from NetSuite.
Deliverables
- We can develop a scheduled script to execute in every 30 mins to send the sales order status from NetSuite to Website.
- For sending the sales order status we can use the following criteria,
Orders which are created in 3 hours
OR
The orders which have a status change in 3 hours
- We will consider the orders which are created from the website, and they can be identified by the Site Order ID, which will always begin with the integer 5.
- We will send the following data regarding the status changes from NetSuite to the website in every execution.
[
{
"order_id": 5316670,
"status": "Pending",
"lines": [
{
"web_order_line_id": 31887070,
"item": "FA921384",
"qty_requested": 1,
"qtyfulfilled": 0
}
]
}
] Order_id will be the Site Order ID.
Status will be the updated order status in NetSuite.
Web_order_line_id will be integration line id stored in line level field Integration Line ID.
item will be the item name.
qty_requested will be the requested quantity in sales order.
Qty_fulfilled will be quantity fulfilled.
Assumptions and Limitations
- We will consider the orders which are created from the website.
- We will not consider the sales order status Sales Order Closed to map the status with the website
- We only consider only the above-mentioned status with specified mappings.
- We will map the order status to website which are created after the script deployment.