In Celigo ,we can give the direct values to mapping field other than saved search values is known as hard code . Firstly , click the settings icon of the mapping field. Then click the Hard-Coded option in the Field mapping Type. Enter the value in the textbox of Enter default value. Then save it… Continue reading How to hard-code values in Celigo
Category: Celigo
Shopify Netsuite IA Error – Failed to create Customer Deposit for Shopify Order
Error: Failed to create Customer Deposit for Shopify Order XXXXXX due to the Invalid reference key of Order XXXXXX for Customer XXXXXX. Reason: If you map the payment method on the sales order, NetSuite restricts to a create customer deposit. Solution: Remove the payment method mappings on the Shopify order to NetSuite order (cash sale or… Continue reading Shopify Netsuite IA Error – Failed to create Customer Deposit for Shopify Order
Resolve date format related errors
When mapping date fields in the flow, there is chances of errors due to difference in date format of source and destination systems. To avoid such errors you need to set the export date format to sync the date values. From your Integration App, navigate to the Flow which has the date error Flows > [Flow… Continue reading Resolve date format related errors
How to Resolve the resource path error in Return flow of NetSuite -Pitney Bowes Integration
While doing the NetSuite – Pitney Bowes integration, there should create Return authorization in NetSuite using the details from Pitney-Bowes(Return Flow). During the process , a resource path error may occur like in the below shown image. So, to resolve it should give the timestamp values in right format in the relative URL field and… Continue reading How to Resolve the resource path error in Return flow of NetSuite -Pitney Bowes Integration
Error while adding new eBay account
Error: When trying to add a new store in the eBay-NetSuite Integration App, an error occurs at the NetSuite configuration process. The error Celigo bundle is not installed in NetSuite but the bundle is already installed and even updated. The issue occurred only for NetSuite Sandbox connection. Solution: Re- authorize the existing NetSuite Connection and… Continue reading Error while adding new eBay account
Passing the data in HTTP response of XML format to the NetSuite– Celigo
After the import step go to the response mapping and create a mapping for the _json field to response field as the following The HTTP response looks like the following Then in the field mapping add the path to this value in HTTP response and map it with the field in which we need to… Continue reading Passing the data in HTTP response of XML format to the NetSuite– Celigo
Import Not paid Shopify orders to Netsuite using IA
There are two options to do this We have two options for bringing pending payment orders from Shopify to Netsuite. 1 ) First, we have to go to celigo settings > Order There give the Shopify order id. The Shopify order id will be the id in the order URL. Then save it. Also you… Continue reading Import Not paid Shopify orders to Netsuite using IA
PROPOSAL FOR SHOPIFY TO NETSUITE INTEGRATION USING CELIGO
The requirement can be achieved by configuring the Shopify – NetSuite Integration App in integrator.io. The Integration App provides automated data flows. When data in the source system is updated or new data is added, the corresponding records in the target system are also modified or updated. The Integration flows available in Shopify – NetSuite… Continue reading PROPOSAL FOR SHOPIFY TO NETSUITE INTEGRATION USING CELIGO
Convert XML data of HTTP response to JSON format in Celigo
In celigo , From Pitney Bows provide the data in XML format .We need to convert this data to JSON format to store NetSuite. If HTTP Response like : <response><products> We store “response/products ” in the ‘Path to records in HTTP response body’ of Non Standard API response patterns tab. Select XML in the ‘Override… Continue reading Convert XML data of HTTP response to JSON format in Celigo
Import Amazon Order without Tax
When Importing the Orders from Amazon Seller Central using Celigo flows, the Item Price inclusive of tax is imported. The flow mapping by default is mapping the Item price inclusive of item tax. If there is requirement to exclude the tax the mapping for Item price can be modified as {{#if $.OrderItem[].ItemPrice.Amount}}{{ subtract $.OrderItem[].ItemPrice.Amount $.OrderItem[*].ItemTax.Amount}}… Continue reading Import Amazon Order without Tax