What is the difference between using a Sales Order as a Reference record and Item Fulfillment as a Reference record to import orders into ShipStation?

• Sales Order–> The integrationuses sales order as a base record and creates an order in ShipStation. Once a label is generated in ShipStation for the order, ShipStation Integration will create an item fulfillment record for the corresponding sales order in NetSuite with the tracking details.
• Item Fulfillment–>The integrationwill wait until an item fulfillment record created in NetSuite for the sales order, then it will use the item fulfillment record as a base record and create an order in ShipStation. Once a label is generated in ShipStation for the order, ShipStation Integration will update the existing item fulfillment record in NetSuite and changed the item fulfillment status to Shipped along with the tracking details.

What are the Benefits of using Sales Order vs Item Fulfillment flow?

• If Sales order flow is used, ShipStation Integration will automatically create an Item Fulfillment record in NetSuite.
• If Item Fulfillment flow is used, you will have the flexibility to choose which item on the sales order to be fulfilled (when you have multiple items and do not want to fulfill all of them).

How to populate some specific information (memo, gift message, etc,..) to ShipStation?

• Add the fields in the saved search results tab which you want to populate in ShipStation from NetSuite. After adding the required field in the results tab,add the same custom label in Integartor.io flow mappings and map it to the required ShipStation field (custom field1, custom field2, internal notes, etc……).
  

How to export the orders into SS even though they have back ordered items?

• Remove the formula in NetSuite saved search which is used for preventing the line items which are backordered.
  

How to export the weights based on the unit of measurements?

• If the UOM is ‘lb’ then just add weight and weight units in the NetSuite saved search result tab. If the UOM is ‘kg’ then add the below formula in NetSuite saved search result tab.

FORMULA: “CASE WHEN {item.weightunit} = ‘kg’ THEN {item.weight}*35.274 ELSE {item.weight} END”

How to populate the preferred bin number on the order in ShipStation?

• Add the preferred bin number field in NetSuite saved search result tab then add that custom label in matrix options in Integrator.io.
  

How to add billTo Party information on the order in ShipStation?

• Add the relevant field in NetSuite saved search result tab based on what information we need to populate in the 3rd party billing information in ShipStation and Integrator.io mappings.
  

How to import images with the sales order into ShipStation?

• Add the image URL (it should be a public URL) on the item record then add that field in the NetSuite saved search result tab using below formula.

FORMULA: “CASE WHEN {item.storedisplaythumbnail} IS NOT NULL THEN {item.storedisplaythumbnail} END”

NOTE: {item.storedisplaythumbnail} – this is the field name on the item record.

How to set ShipStation Age based on the order created date?

• To use the NetSuite date created for the age in ShipStation, please follow the below steps.

Add the following column to the saved search and label it as dateCreated.

Formula (Text): TO_CHAR({datecreated},’YYYY-MM-DD HH24:MI:SS’)

Add the mapping in IO – dateCreated paymentDate

How to export harmonization code for international orders in ShipStation.

We cannot import the Harmonization and country code details from NetSuite to ShipStation using the order flow but we can set those values using the product flow (Items – Update Items from NetSuite to ShipStation). In order to update that information, the items should already be present in ShipStation and are connected (the items in both the systems can be connected using Item ID Mass Update – Update ShipStation Item ID from ShipStation to NetSuite.

Please add the fields containing that information in the NetSuite saved search results and map them in the product flow to the below fields in ShipStation.

Questions