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
Category: Celigo
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
Create flow in Celigo
Select the tile to create the flow Click on create flow Provide a name for the flow Click on source to add export and add the required fields , then click Next 5. Add name, export type, resource, API endpoints and Save the export 6. Click on destination and add connection and click Next 7.… Continue reading Create flow in Celigo
Transitioning from SuiteScript 1.0 to SuiteScript 2. x
While using celigo we get a message to install SuiteApp in the Netsuite account, Without installing Celigo integrator.io on Suitescript 2.0 we can’t run new flows with the new Netsuite Connection, and also with the Old Netsuite Connection. Oracle NetSuite encourages you to transition from using SuiteScript 1.0 to using SuiteScript 2. x. If you… Continue reading Transitioning from SuiteScript 1.0 to SuiteScript 2. x
Fix the error
To solve this error we need to install SuiteApp in Netsuite Sign in to NetSuite. From the Customization menu, select SuiteCloud development > SuiteApp marketplace. In the SuiteApp marketplace, search for Celigo integrator.io. Click the Celigo integrator.io on SuiteScript 2.0 tile. Once on the Celigo integrator.io on SuiteScript 2.0 page, click Install. OR can install this using the link provided in celigo platform Once… Continue reading Fix the error
Sync Customer Groups from Magento to NetSuite
Description: Imports the Magento Customer Groups list into NetSuite and the imported information is internally used to set the customer group on customer records. Additional Details: The Customer Group information is stored in the custom record Magento2 Customer Group List After running the above dataflow, you should see all the stores along with its Magento ID in Magento2… Continue reading Sync Customer Groups from Magento to NetSuite
Relative and Absolute URL
The structure of the URL is the web address of your site and its subpages. You have two basic choices when it comes to the selection of URLs: absolute URL and relative URL. An absolute URL contains the entire address from the protocol (HTTPS) to the domain name (www.example.com) Basically, it’s the full URL of the… Continue reading Relative and Absolute URL
Date/Time format in Celigo
date/time formats help you to select or enter the appropriate format. Date/Time format Example YYYY-MM-DDTHH:mm:ssZ 2018-04-01T15:20:15-07:00 YYYY-MM-DDTHH:mm:ss 2018-04-01T15:20:15 YYYY-MM-DDTHH:mm:ss[Z] 2018-04-01T15:20:15Z YYYY-MM-DDTHH:mm:ss.SSSZZ 2018-04-01T15:20:15.000-0700 YYYY-MM-DDTHH:mm:ss.SSSSZ 2018-04-01T15:20:15.000-07:00 YYYY-MM-DD HH:mm:ss 2018-04-01 15:20:15
error: “NetSuite transaction not found”
Solution: After you run the Amazon Settlement Report to NetSuite Custom Settlement Records flow successfully, the integration app automatically triggers the NetSuite Settlement Transaction to NetSuite Payment Add flow. If you receive errors related to “NetSuite transaction not found” after the settlement flow is run, check if there are any FBA orders with Pending state… Continue reading error: “NetSuite transaction not found”