If you want to use the CloudExtend Excel to update the price of an item(s) on a NetSuite record, the Picklist will not display a “Custom” value in the drop down list due to a NetSuite WebServices limitation. To customize a price level do the following:
In the Item List: Price column, enter [[-1]] and enter in the Custom Rate in the Item List: Rate column. Click Update and then Insert/Update on the add-in toolbar. CloudExtend will then create or update that record with the Custom Price level.
Note: -1 is the NetSuite internal ID for Custom Price.