Jira Code : TFLL-132
Proposal Summary
Toolfetch would like to implement the integration between NetSuite and Cerasis for live shipping rate calculation through GlobalTranz connect.
Requirement
The primary objective of this integration is to provide NetSuite users with access to real-time shipping rates from Cerasis through the GlobalTranz Connect. This will enable businesses to make informed decisions about their shipping options, reduce shipping costs, and improve overall supply chain efficiency. The integration will also help streamline shipping processes by automating the rate calculation and booking process, reducing the risk of human error, and increasing efficiency.
Deliverables
About Cerasis and GlobalTranz
Cerasis is a top North American third-party logistics company offering logistics solutions with a strong focus on LTL freight management. In addition to expertise and focus on LTL freight management, Cerasis offers truckload freight broker services, parcel management, and end to end LTL eCommerce freight shipping solutions.
GlobalTranz provides shippers of all sizes with fast and reliable transportation services across all major modes of freight. Reliable capacity, expert support, and technology-driven agility are some of the ways our customers benefit from partnering with GlobalTranz. Cerasis is GlobalTranz’s 11th acquisition since January 2017 and represents the continued delivery of industry-leading organic growth augmented by strategic combinations.
Current Shipping Rate Calculation with UPS in Toolfetch Website
We have an existing script for Shipping rate calculation in NetSuite which will fetch the item details from the checkout page and retrieves the freight rate information from the UPS online tools API.
We are planning migrate to GlobalTranz for getting the live rate in the Website instead of the UPS.
GlobalTranz Connect Integration
We are opting the Connect Integration to compute the real time rate on the website.
Prerequisite
To interface with the web services, users are required to know their Shipper ID, Username, and Password. In addition, each shipper will be assigned an Access Key that is required when communicating with any GlobalTranz web service. We need a shipping table named “GlobalTranz” in NetSuite which should define a shipping table that contains the Shipping range and the corresponding value.
Shipping Rate Calculation
The integration between NetSuite and Cerasis will enable users to access live shipping rates from Cerasis through the GlobalTranz Connect. This will allow businesses to compare rates and select the most cost-effective shipping option based on their specific needs.
The integration will also automate the rate calculation and booking process, eliminating the need for manual data entry and reducing the risk of errors. We will implement a solution which will calculate the shipping rate for all items based on the custom fields in the item record.
Free Ship Items
When the “Free Shipping” is checked in an item, then there will not have any Shipping charges for that item.
Non-Freight Items
In this case, we need to have a shipping item named “GlobalTranz” in NetSuite, which should define a shipping table under the subtab “Shipping Rate” that contains the shipping range and the corresponding shipping rate.
Here, the range value is calculated by adding the total cart weight (Item weight (Field Id : weight) * Item quantity (Quantity selected by the user on the website)) of all the items added to the checkout page.
Freight Items
The freight items are identified using the checkbox named “Ship Freight” in the item record. NetSuite will pass the values of the following fields to Cerasis for live ship rate calculation of the freight items.
1. Item Weight
2. Ship Freight
3. Freight Class
4. Shipping Height
5. Shipping Length
6. Shipping Width
7. Special Shipping Group
Authentication
All webservice calls will require the following headers. These headers are used as authentication to the web services.
RateShipment allows users to rate any shipment. The user sends certain shipping information, and the system will return a list of carriers sorted by price with the least-cost carrier at the top of the list.
API POST: /Rating/rest/rate
Assumptions
• We will consider only inventory items for the shipping rate calculation.
• We are not considering handling charges in this integration.
• We are integrating NetSuite and Cerasis based on a single subsidiary, and cross-subsidiary calculations are out of scope.
• There will be only one shipping item, “GlobalTranz” and we are assuming that it contains the shipping rate for all the ranges for non-freight items.
• We will not consider multiple weighing units and assume that it will be “lb” for all items.
• Multiple units of measure are not considered in this integration.
• When the total cart weight is greater than 150 lb, we will consider it 150 lb.
• Items will contain all the necessary fields for calculating the ship rate in NetSuite.
• We will only consider the two countries “United States” and “Canada” for ship rate calculation on the website.
• The Ship from address is calculated from the item’s vendor zip code (Field Id : custentity_vendor_freight_zip ). As most of the items do not have vendor zip calculated, we will hard code the ship from zip code to 10523.
• As Cerasis will come back with multiple rates to choose from, we will always pick the first-rate in our script.
• We will add a parameter in the deployment record for storing the percentage value of the freight rate and assuming that it will be same in all the cases.
• All considerations in the proposal will be considered in the integration scope and any updates will be considered as extra effort.