Requirement The requirement is to export the csv file from their SFTP server to NetSuite using the Celigo. Following are the integration to be implemented. Import Demographic files to NetSuite Import Appointment files to NetSuite Import of referral files is not included in this scope. Our Soultion Approach 1. Prerequisites NetSuite account (Sandbox and Production)… Continue reading PROPOSAL FOR INTEGRATION OF CSV FILES FROM SFTP SERVER TO NETSUITE USING CELIGO
Category: Celigo
How to set up an FTP connection in integrator.io
A File Transfer Protocol (FTP) is a standard communication protocol used for the transfer of computer files from a server to an application on a computer. You can grab existing JSON, XML, CSV, and other files to upload them into a second application (Amazon Seller Central, Acumatica, etc.), or add files to the server from… Continue reading How to set up an FTP connection in integrator.io
Specifying Path to Records in Celigo
Celigo has a feature to add the path to records called Path to records in the HTTP response body under the Non-standard API response header in the export step. This optional field allows integrator.io to locate the resource (or set of resources) returned from an API call. If the HTTP response from an API contains… Continue reading Specifying Path to Records in Celigo
GraphQL Query in Celigo Request body
In the Rest API Integration, If the application uses GraphiQl Query to call the API like the one attached below. Add it in the request body of Celigo like the following Also in the Relative URL add “/graphql.json” (For Example : https://<shop>.myshopify.com/admin/api/<YYYY>-<MM>/graphql.json)
Process the Settlement Flow Error in Celigo
Issue When we run the Celigo Settlement flow, there occurs an error which shows a settlement_order_not_found with message “NetSuite transaction could not be found. Settlement details: Settlement Id# 15460107661, Amazon AFN Order# 114-8511691-4140214.” Solution In this case, we need to copy the Amazon AFN Order# from the error list and need to import that id… Continue reading Process the Settlement Flow Error in Celigo
Matrix Items not set up correctly on BC Issue checking
//Info: COR-482 There are certain issues faced while setup an integration with 2 platforms.In this case, Some Matrix items in NetSuite are not sync correctly towards BigCommerce through Celigo.So, Its better if we have a correct way to Identify the issue from the very beginning, right? 1. Initially, Check the Given Item in NS side.… Continue reading Matrix Items not set up correctly on BC Issue checking
Release notes for NetSuite Bundle v1.20.0.0, February 2022 – SuiteScript
What’s new Request and Response data for errored imports and exports A new logging framework, RequestResponse, captures your requests and error responses to NetSuite when processing an export or import request. The framework logs objects and SuiteScript API function calls and saves them in case of an error. You can now see NetSuite import and… Continue reading Release notes for NetSuite Bundle v1.20.0.0, February 2022 – SuiteScript
Amazon Seller Central APIs Supported in Celigo
Amazon Seller Central is the web interface used by brands and merchants to market and sells their products directly to Amazon’s customers. When you configure an export, import, or another type of flow step using the Amazon Seller Central connector, the following API operations are supported: Selling Partner API (SP-API) API Operation Export Import Orders Get… Continue reading Amazon Seller Central APIs Supported in Celigo
Delete the Settlement record and its related records
Delete the Settlement record and its related records for Rohego US.
Amazon – NetSuite integration app R1 release notes, January 2022
The following are the new features added in the 2022 release: Sync Amazon Local Selling orders (new add-on) Amazon’s Local Selling feature allows merchants to list the products in Amazon as available for Local Selling and provides an option for the customers to pick up the orders in-store (offline) based on their convenience. Once the merchant gets… Continue reading Amazon – NetSuite integration app R1 release notes, January 2022