Proposal summary

The proposal covers the SCA Canada Post shipping integration into NetSuite

Requirement

A proposal/SOW for Canada Post shipping integration into NetSuite. The integration to pull rates to the sales order as well as the SuiteCommerce website for customers to see during the checkout process.

We can split the requirements into the following

1. Fetch the shipping cost from Canada Post to SCA checkout page
2. When Order is fulfilled in NetSuite allow the user to calculate shipping cost based on the dimensions and customer address
3. After an item fulfillment is created, generate the tracking information from canada post and write to NetSuite and generate labels from canadapost and save links to item fulfillment
4. When a sales order is cancelled cancel the same from canada post  

Our Solution

Phase 1

Fetch the shipping cost from Canada Post to SCA checkout page

• Once a customer reaches the checkout, on the shipping address section/update the Canada post API triggers and shipping cost calculates(the reason for calculation done here is during shipping method selection, the API post action will consume more time which slows our checkout process).
• After selecting the shipping method, based on the selected method the shipping cost is updated.
• Once the checkout process is completed, the sales order is created in Netsuite with the calculated shipping cost.
• We cannot set the shipping cost directly into Sales Order. So we will be creating a custom field named “Shipping Cost”. On sales order creation the custom field will be updated. Using a workflow/Suitescript, the shipping cost will be updated in the standard field.
• From Netsuite, the sales order is processed. On item fulfillment shipment API calls, the tracking ID and shipping labels are created.

Prerequisite

• The Netsuite account details are needed with the SCDeployer role.
• The item and customer record with all the fields needed for Canada post-integration.
• Authentication details used for Canada post-integration. Both sandbox and production access.

Assumptions

• We assume the sandbox set up is done and a domain is available in the sandbox to develop the functionality.
• The required fields used for Canada post-integration should be available in the item record and customer record.
• We will be working in the sandbox environment. After confirmation/testing, the changes will be moved to the live domain.

Risk Factors

• The website uses Suitecommerce Standard version of Netsuite which only supports extensions and not custom modules. So the functionality could only be achieved if there is an available extensibility API to extend the shipping method functionality. Or else the task could not be achieved on the website.
• SC is less customizable than SCA and updating the theme will be overridden by Netsuite’s automatic updates.
• Updating netsuite’s theme is risky due to Netsuite’s automatic update. So all the theme changes will be achieved using extensions which will be more time consuming than updating the theme.

Budget and Time

Time Required –  80-100 hours

Note: The proposal time was updated without checking the Netsuite account/code,  Canada post-integration APIs. The time may vary depending on account setup and API availability.

The post API checking cannot be done without having Customer-number, Contract-id, API key..

Phase 2

When Order is fulfilled in NetSuite allow the user to calculate shipping cost based on the dimensions and customer address

This can be done by NetSuite suitescripts. On the fulfillment page, users can press the calculated “canada post charge” and get the amount populated in the shipping cost field.

Budget and Time

Time Required –  24 hours

Assumptions

• We will be working in the sandbox environment. After confirmation/testing, the changes will be moved to the live.

After an item fulfillment is created, generate the tracking information from canada post and write to NetSuite and generate labels from canadapost and save links to item fulfillment

APIs will be called in the background to create fulfillment information in canada post and reads back the tracking information and adds to the item fulfillment. The link obtained for the labels from canada post will be saved to a custom field

Budget and Time

Time Required –  30 hours

Assumptions

• We will be working in the sandbox environment. After confirmation/testing, the changes will be moved to the live.

When a sales order is cancelled cancel the same from canada post  

If the order is cancelled in NetSuite, we will trigger the API to canada post to cancel the shipment,

Budget and Time

Time Required –  20 hours

Assumptions

• We will be working in the sandbox environment. After confirmation/testing, the changes will be moved to the live domain.