For data which may not be available in NetSuite natively, for example product commodity data, or in the instance that you want to use data from custom fields instead of native NetSuite fields, you can map your custom fields to Shiptheory shipment properties using the Custom Field Overrides section in the advanced settings of your NetSuite integration in Shiptheory.
Using the Custom Field Overrides Setting
There are 3 fields to fill in when using the custom overrides fields:
- NetSuite Object: This is the entity within NetSuite which the custom field exists on. The options are
- Sales Order
- Item Fulfillment
- Custom Field ID: The ID of the custom field which you want to pull data from.
- Shipment Property: Use this field to select which property of a Shiptheory shipment you would like to apply the data to.
Once you have filled in the 3 fields you can press the green plus button to add another line and repeat the process to add another custom field override. Once you've added all the overrides you need hit 'Save' to make sure your changes aren't discarded.
Example (Commodity Code)
Navigate to Customization > Lists, Records and Fields > Transaction Body fields > New.
Give your field a name and an ID. Netsuite prepends all IDs you enter with the field type, for example custitem or custbody so we have decided to prepend our exampe ID with an underscore for readability. Ensure that you have applied the custom field to 'Inventory Item'.
Copy the ID of the custom field you just created and navigate to your advanced NetSuite settings in Shiptheory.
Go to the Custom Field Overrides setting in Shiptheory. Select 'item' from the NetSuite Object field, then enter your custom field ID (custitem_hs_code) into the Custom Field ID field and then finally, select which Shipment property you want the data to apply to:
To add data to your custom field in NetSuite find a inventory item you want to use it on and click 'Edit', then scroll down until you see custom fields. You can then populate the field with relevant data.