Data Flow: Shopify refund to NetSuite refund (add) flow Error Code:billing_transaction_not_found Error Message: “Failed to refund order #*********, No invoice/cash sale found in NetSuite.” Reason: This error occurs when the flow could not filter and identify the cancelled orders and generate a customer refund. Resolution: Adding the import filters for the fields “transaction.length”, “cancel_reason” and “cancelled_at” should resolve… Continue reading Error: “Failed to refund order #*********, No invoice/cash sale found in NetSuite”
Category: Celigo
Error :”Failed to save record because Please choose an item to add”
Data Flow: Shopify refund to NetSuite refund (add) flow Error Code:user_error Error Message: “Failed to save record because Please choose an item to add.” Reason: This error occurs when the flow can’t find an SKU from the data to process. Resolution: Adding Items: eTail Order Linet ID field in the field mappings should correct the problem. Log… Continue reading Error :”Failed to save record because Please choose an item to add”
Export types in Celigo
When exporting data from NetSuite, integrator.io provides four options for the Export type All – Export all data returned in the search each time the export is run Delta – Export all data with a date/time value for the selected field that is greater than the last time the data flow was run Once – Export any data that… Continue reading Export types in Celigo
How to fetch the formatted output of html code from a custom field in item record to Magento
steps 1.Add the html code in the custom field in item record 2.Add formula(Text) field in the result tab of saved search 3.The saved search result will be displayed as shown. 4. Map this field in celigo mapping and when running the flow and verifying the result in Magento we can see that the formatted… Continue reading How to fetch the formatted output of html code from a custom field in item record to Magento
Field mapping type indicators
Letters next to mapped values indicate the field mapping type. none – Standard: Product is a standard mapping value. L – Lookup: Country is a lookup mapping value. M – Multi-field: Transaction_date is a multi-field mapping value. H – Hard-coded: City is a hard-coded mapping value
Display the visibility field in Magento as default if this is empty in NetSuite
Displaying the visibility field of Magento as Catalog, Search by default if no visibility is given in NetSuite. steps: For this some arrangements are done in the lookup mapping as shown. Here the check box for ‘use custom default value’ is checked. Since the purpose is to set “Catalog, Search” as the default value, enter… Continue reading Display the visibility field in Magento as default if this is empty in NetSuite
Relevance of integrator.io sandbox license
If you are building a custom integration, then you can create an integrator.io connection to the NetSuite sandbox environment without purchasing an integrator.io sandbox license. You can specify the Environment setting of the NetSuite connection. In this use case, NetSuite is taken as an example, but this applies to any other application. Integration app environment licensing requirements:… Continue reading Relevance of integrator.io sandbox license
Set Visibility field in Magento based on item type in NetSuite
The visibility field of Magento can be arranged on the basis of the type of item in NetSuite. This can be done by creating a custom visibility field in NetSuite and performing lookup mapping in the NetSuite Magento integration flow. In Netsuite item record, a List/Record type custom field named “visibility” is created as shown… Continue reading Set Visibility field in Magento based on item type in NetSuite
Switch connection within an integration app from a sandbox to a production instance
The integration apps on the Celigo integrator.io platform are built with fairly heavy components or dependencies on each application and thus switching endpoints or accounts wouldn’t be permitted. Attempting to make changes might impact the overall stability of your integration app and is NOT recommended. If a connection is dependent on a user within the… Continue reading Switch connection within an integration app from a sandbox to a production instance
Hard-coded field mapping
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