Proposal summary
The proposal covers how we can integrate Netsuite with Starshippit. It is a one way integration with Starshipit from Netsuite
Requirement
Nickolls and Perks Ltd have an intermediate Warehouse management system called Starshipit for dispatching the products. With the existing processes in the businesses, they would like to overcome their limitations by integration.
Integration of Starshipit with Netsuite
The client is required to update the orders in Starshipit by the integration between Starshipit and Netsuite. The order should be up to date as deletion and editing of orders in the Netsuite sales orders should be reflected in the starshipit. In the existing system, the orders in the Starshipit corresponding to the edited orders in Netsuite are deleted and re-imported by the team to keep it updated.
Our Solution
From Netsuite to Starshipit
The integration will be one way from Netsuite to Starshipit. This will be a real time integration.
Order Data Sync
A script will be implemented in the sales order record and after every update in the Sales order record in the Netsuite, data will be reflected in the Starshippit in real time.
Note that the update will only take place only if the item fulfillment record with Shipped status is not created.
With this integration, the following fields will be updated in the Starshipit:
| Netsuite Field | Starshipit | Description |
| Shipping Carrier | carrier_service_code | Carrier service code for delivery |
| Shipping Method | shipping_method | Delivery method name (max length: 100) |
| Shipping Instructions | shipping_description | Delivery method description (max length: 100) |
| False( by default) | signature_required | Determine whether signature is needed on delivery |
| GBP | currency | Currency code for the order value |
Following fields in the item subtab can be Integrated from sales order record to Starshipit:
| Netsuite Field | Attribute | Description |
| Item Name | description | Product name or description |
| Item Name/number | sku | Product code or SKU (max length: 50) |
| Quantity | quantity | The number of product ordered |
| Weight field in the item record | weight | Unit weight of the product in kilograms (kg) |
| Rate | value | Unit price of the product |
| delete | An indicator used to determine whether this order item should be deleted when updating the order |
Following fields need to be stored in the Sales order record already or we will be retrieving these details by using the GET API
| order_id (read-only) | The unique numeric identifier for the order |
| order_date | The date when the order was created in UTC |
| order_number | The identifier of the order pulled from source e-Commerce platform (max length: 50) |
| reference(by default) | “Online Order” |
Customer Data Sync
Only the Shipping address and contact details can be updated from Netsuite.For updating the customer data, there is some limitation to update the customer details in the real time as the Starshipit API does not provide an API for customer data updation separately. But the shipping address can be updated in the sales order and that can be updated in the Starshipit API along with data sent for an order update in the Starshipit.
Following fields can be updated from Netsuite sales order record to Starshipit:
| Netsuite Field | Starshipit Attribute | Description |
| Firstname and Lastname | name | Contact name of the receiver (max length: 100) |
| Phone | phone (optional) | Contact phone number of the receiver (max length: 100) |
| email (optional) | string | Contact email address of the sender (max length: 100) |
| building (optional) | Building name of the delivery address (max length: 100) | |
| Companyname | company (optional) | Name of company that the parcel is being delivered to (max length: 100) |
| Address 1 | street | Street number and name of the delivery address (max length: 100) |
| Address 2 | suburb | Suburb of the delivery address (max length: 100) |
| City | city (optional) | City of the delivery address (max length: 100) |
| State | state (optional) | Regional, provincial or county name of the delivery address (max length: 100) |
| Zip | post_code (optional) | Postal or zip code of the delivery address (max length: 10) |
| Country | country | The country name of delivery address (min length: 2, max length: 100) |
| Delivery Instructions | delivery_instructions (optional) | Delivery instructions for courier (max length: 100) |
Assumptions
- Orders in the Starshipit are integrated with Netsuite and the Starshipit order number is saved in the sales order as document number
- Creation of orders from Netsuite to Starshipit is out of scope of this integration
- The orders are integrated from Starshipit to Netsuite and we will be using Document number in Netsuite as unique identifier to identify the orders
Time
Estimated Effort : 24 hrs
| Description | Time Required |
| Analysis | 3h |
| UserEvent script for syncing Sales Order from Netsuite to Starshipit | 16h |
| Documentation | 1h |
| Testing | 2h |
| Deployment | 2h |
| Total | 24h |