Data Manipulation in NetSuite and NetSuite Connector
In NetSuite, you can create workflows and scripts to add automation on your data. For example, you can create a workflow that automatically creates a cash sale when a sales order is in Pending Fulfillment state. Another example is you can create a script that calculates an item’s profitability and automatically populates the profitability on the sales order line item.
NetSuite Connector also has certain capabilities to transform data through calculations and post to NetSuite. However, if an automation or calculation is dependent on data in NetSuite, you should implement a workflow or script in NetSuite. For example, assume that you have a custom record in NetSuite and want to populate information from that record on the sales orders. In such case, you should set up a script in NetSuite because the custom record data is in NetSuite.
Use NetSuite Connector when the automation or calculation is dependent only on the data imported from the storefront. In such case, NetSuite Connector may be able to manipulate the data prior to the sale order posting to NetSuite. You can adjust the order or fulfillment mappings or change the connector settings in the NetSuite Connector. For example, assume that you want to automatically populate the Department field on the sales order based on the type of order in the storefront. To achieve this automation, set up a logic mapping for the Department field in NetSuite Connector so that the correct value posts to NetSuite.