ShipStation Order session offers 4 flows which take care of Fulfillments between NetSuite and ShipStation.

Data Flow 1:  ShipStation Fulfillment to NetSuite Fulfillment Add

After orders are exported into ShipStation, you (client) will create labels then the ShipStation-NetSuite Integration app will import those item fulfillment details into NetSuite and create an item fulfillment record with the tracking details.

Setting integrator.io side of things –

Steps to configure flow:  –

1. Login into integrator.io
2. Click on ShipStation–NetSuite Integration App
3. Click on “Advanced Settings” and next in “Fulfillments” configure the following fields-
   
4. Click on the “Advanced Settings” and next in “Shipping tab” configure the following fields-
   • Select the location as per your business – This location will be used while creating an Item Fulfillment record.
   • Add the store Id.
   • Select Shipments.
   • Add 0.1 default weight.
   • Select the status Shipped.
     
5. Click on “Mappings”  — These are all mandatory fields and will come default in mappings no need to add anything.
   
6. If you want to see the ShipStation shipping method on Item Fulfillment record in NetSuite then you need to add a static lookup for shipping method mappings (please see the below screenshot). Please refer to the below document to retrieve the list of shipping codes.

https://docs.google.com/spreadsheets/d/1vS0e1x0MZ2dDtHeyxIMLqjSTgZ5bJqnp8NYoi3s_-40/edit#gid=246198210

Data Flow 2:  ShipStation Fulfillment to NetSuite Fulfillment Add (Retry)

• Create a copy of the saved search: novamodule ShipStation Order Pending Fulfillments Template and name it –novamodule ShipStation Order Pending Fulfillments Template_PROD.
• No need to configure this flow, just turn on and schedule the flow when you are going live with the Integration. This flow picks up any orders that were missed by the regular fulfillment flow and it is recommended to run to this flow once daily.
• The fields mentioned in the snapshot are mandatory and in the absence of any field exported file would error out in Integratr.io.
  
  

Data Flow 3:  ShipStation Fulfillment to NetSuite Fulfillment Add[PICK, PACK AND SHIP]

• After Item Fulfillments exported into ShipStation, you(client) will create labels then ShipStation-NetSuite Integration app will update the item fulfillment record to Shipped Status along with the tracking details from ShipStation.

Setting integrator.io side of things –

Steps to configure flow:  –

1. Login into integrator.io
2. Click on ShipStation–NetSuite connector
3. Click on “Advanced Settings” and next in “Fulfillments” configure following fields-
   
4. Click on “Advanced Settings” and next in “Shipping tab” configure the following fields-
   • Select the location as per your business.
   • Add the store Id.
   • Select Shipments.
   • Add 0.1 default weight.
   • Select the status Shipped.
     
5. Click on “Mappings” — These are all mandatory fields and will come default in mappings no need to add anything.
   
6. If you want to see the ShipStation shipping method on Item Fulfillment record in NetSuite then you need to add a static lookup for shipping method mappings (please see the below screenshot). Please refer to the below document to retrieve the list of shipping codes.

https://docs.google.com/spreadsheets/d/1vS0e1x0MZ2dDtHeyxIMLqjSTgZ5bJqnp8NYoi3s_-40/edit#gid=246198210

Data Flow 4:  ShipStation Fulfillment to NetSuite Fulfillment Add (Retry) [PICK, PACK AND SHIP]

Part A:  Setting the NetSuite side of things –

Steps to configure saved search –

• Create a copy of the saved search: novamodule ShipStation Order Pending Fulfillments Template [PPS] and name it –novamodule ShipStation Order Pending Fulfillments Template [PPS]_PROD.
• No need to configure this flow, just turn on and schedule the flow when you are going live with the Integration.  This flow picks up any orders that were missed by the regular fulfillment flow and it is recommended to run to this flow once daily.
• The fields mentioned in the snapshot are mandatory and in the absence of any field exported file would error out in Integration.
  

USE CASES:

1. How to import discounts to ShipStation?

Add the below fields to the saved search criteria depending on whether the discount is a line-level or header level.

Line Level Discount

1. Add anyDiscountItems (please use same label name) and set it to TRUE.
2. Add adjustment (please use same label name) and set it to FALSE.

Header Level Discount

1. Add mainleveldiscount (please use same label name) and set it to TRUE.
2. Add adjustment (please use same label name) and set it to FALSE

Change the UNIT PRICE formula to CASE WHEN {appliedtotransaction.rate} is NOT NULL THEN {appliedtotransaction.rate} ELSE   NVL({appliedtotransaction.amount}, 0)/{quantity} END.

Note:Change the field type for UNIT PRICE in the field mappings to PLEASE SELECT.

• To Include kit child items:By Default, ShipStation Integration will automatically export Parent with Component items.
• To Exclude kit child items:Add the below criteria in the NetSuite saved search.

Next Steps

Configure Product Flow