Proposal Summary
This proposal summarizes the functionality for automatically setting a default shipping carrier in NetSuite sales order from the corresponding Shopify sales order while performing the order import via Celigo.
Requirement
The customers should be able to choose a shipping carrier in Shopify and then have that selection be set as the default carrier in NetSuite for that Sales order.
For example, the customer has a choice between FedEx and UPS shipping. This choice is then set as the default shipping carrier in NetSuite for that sales order.
Deliverables
- As the requirement is to include the shipping carrier in the order import process from Shopify to NetSuite, which is implemented with Celigo, we would need to update the Celigo order flow to map the shipping carrier field between Shopify and NetSuite.
- For this, a custom field for the customers to select ‘Shipping Carrier’ or ‘Shipping Method’ needs to be created in Shopify, and this should be created by the Client.
- Since value cannot be set directly to the Shipping Carrier field in NetSuite sales order using Celigo, we will create a custom list field in NetSuite that resembles the standard ‘Shipping Carrier’ field and will map the shipping carrier from Shopify to this custom field using Celigo.
- A suite script will set this value in custom shipping carrier to standard shipping carrier field.
- We will disable the custom field that we will create in NetSuite for shipping carrier as this field need not be manipulated by a user manually.
Assumptions
- We assume that we should only consider the shipping carrier UPS and FedEx in our current scope. If a value other than these 2 is entered in Shopify, we will not be able to set this in NetSuite order during order import.
- If a customer left the shipping carrier field empty in Shopify order, then we will also make the NetSuite shipping carrier empty.
- The shipping carrier will only be updated in the orders imported from Shopify after this functionality is implemented in production, both in Celigo and NetSuite.
- We will disable the custom field that we will create in NetSuite for shipping carrier as this field should not be modified by a user manually.