Tag: Celigo Mapping

NetSuite multiple select field types allow you to include multiple values in a single field.  In a scheduled flow that uses a saved search, integrator.io exports the multiple select field as a string with each value separated by a comma. In a real-time flow (one initiated by a webhook listener), integrator.io exports a multiple select… Continue reading Export or import NetSuite multiple select fields

Scenario The error occurs in the Sales order Import step which includes mapping of price level and unit price for the item lines. The issue is caused by the destination field Items : Price Level (Name) in the mapping. Solution Change the destination field of price level to “Items : Price Level (InternalId)” and map… Continue reading Fix error : Invalid price reference key

Consider a scenario where you exported records from NetSuite via a saved search flow, but the date fields were exported in the European format D/M/YYYY rather than your preferred format, DD-MMM-YYYY. You might have wondered if the issue was because the Celigo export had used the date format in the company preferences setting, which had… Continue reading Set NetSuite date format on saved searches

Data Flow: Shopify Customer to NetSuite Customer Add/Update Error Code: user_error Error Message: ‘Failed while creating customer, message:Please enter value(s) for: Subsidiary’ Reason: No mappings were found for Subsidiary under the Customer Mappings section. Resolution: Ensure that the Subsidiary record is mapped appropriately. Go to integrator.io and navigate to the Shopify Integration App Tile. Click the “Settings” icon to… Continue reading Error Message: ‘Failed while creating customer, message:Please enter value(s) for: Subsidiary’

Print Nlapi Debug Logs is used to capture $R logs in NetSuite SuiteScripts if they do not show up in IO debugger. Select the destination field Print Nlapi Debug Logs and give it a value of “true” to enable logging. When this mapping is set and hard-coded to “true” on any NetSuite import, the debug logs for the NetSuite connection must… Continue reading Print Nlapi Debug Logs mapping in NetSuite

To find existing sublist line in mapping, the Use as a key field to find existing lines setting can be used. The Use as a key field to find existing lines setting is not a mapping field, but it’s available in the sublist mapping settings. If set, the setting finds the existing sublist line with “<DestinationRecordField (NetSuite)>” as… Continue reading Find existing sublist line in Mapping

Error Message Element value “[STRING]” exceeds the fixed length of 30. Use the truncate property if you wish to allow this element value to be truncated. Solution To set the truncate property for CSV files, modify the FTP import configuration. Select Truncate last row delimiter and save the configuration.

Use this setting if you prefer to have the same value written to the imported data field for every record, regardless of the exported value. Use empty string as hard-coded value: Populates an empty string (”) into the field Use null as hard-coded value: Populates a null data type into the field Use custom value:… Continue reading Hard-coded field mapping

To set Address : Addressee using multi-field in celigo mapping , Under setting , select field mapping type as multi-field use the expression: