A product in Magento Catalog can be enabled or disabled using “NetSuite Item to Magento Product” Add/Update flow. To enable a product in Magento, set the mapping field of Celigo as shown. Then on running the flow and checking the product in Magento we can see that the product is enabled. To disable the product… Continue reading Enable/Disable a product in Magento using Celigo Integration.
Category: Celigo
Suitescript Hook to fetch data from an Item saved search
In the saved search the columns include stock descriptions and Quantity available. By using the Suitescript Hook we can fetch these two data from the Item saved search. The sample code for this is: define([“N/search”], function (NSearch) { var preSendFunction = function (options) { // Load the saved search var searchObj = NSearch.load({ id: ‘Provide… Continue reading Suitescript Hook to fetch data from an Item saved search
To get multiple data through XML
In the Celigo HTTP request body, we can provide data in XML format To get multiple data( eg: items ) through that XML code, we need to include a loop in the code, for this, we can use {{each data}}…{{/each}} Example code to use this: {{#each data}} <message> <messageID>{{add @index 1}}</messageID> <operationType>Update</operationType> <inventory> <SKU>{{SKU}}<SKU> </inventory>… Continue reading To get multiple data through XML
Reference fields outside the “Path to many” in import settings
You can append _PARENT before any fields that you need to reference outside the Path to many that you set in your import. Note that ALL fields referenced anywhere in the import (mappings, import configuration, scripts, etc.) will be affected when One to many is set to Yes (advanced). For example, let’s say your import data looks like this: { “exampleField”: “value”,… Continue reading Reference fields outside the “Path to many” in import settings
Error in NetSuite Item to Magento Product Add/Update flow
An error message is displayed while running the NetSuite item to Magento Product Add/Update flow as shown. {“message”:”Error occurred during \”custom_attributes\” processing.Attribute \”category_ids\” has invalid value.The \”string\”value’s type is invalid.The \”int[]\” type was expected.Verify and try again.”} This can be resolved by adding the category id in the result tab of the saved search. Map… Continue reading Error in NetSuite Item to Magento Product Add/Update flow
Change the data type of the data in Celigo
We can change the data type of data in the mapping side of the Celigo. First, Click the setting of the mapping data field then assign the data type to data (Desired data type)
SuiteScript hook
A flow in integrator.io is mainly composed of sources and destinations. One type of source, an export, fetches data from the source applications, then breaks it into smaller pages before passing it into the next step in the flow, such as an import. Imports process the pages coming in, then send the data into the target… Continue reading SuiteScript hook
MySQL DB and Kafka DB
MySQL DB – can store passbook data, user wallet transactions, and the wallet balance of users using tables and relationships. Passbook Data: You can create a table called “passbook” to store passbook-related information. Each row in this table represents an entry in the passbook for a specific transaction or event. User Wallet Transactions: To track… Continue reading MySQL DB and Kafka DB
error: “Failed to Export Item. Please select at least one website for this item.”
This error is raised in the Export preview of NetSuite Item to Magento Product Add/Update flow. Solution: Add custom label for website properly in the result tab of the corresponding saved search as it is case sensitive.
Debug Connection
Click on the Connections option at the bottom Then under the Actions Select Debug connection