Click on the Create option on the Home page and select the Integration option from that. Then give a name for the Tile and Save this. Thus we have created a new standalone Tile with a name we required.
Category: Celigo
Get error notifications via email(you only)
To set up up your email subscriptions on the Notifications tab: Navigate to the integration that contains the flows or connections for which you want to configure email notification. Click the Notifications tab. Under Notify me on flow error, select All flows or specific flow(s). When you are finished selecting flows, click Done. Under Notify me when connection goes offline, select the… Continue reading Get error notifications via email(you only)
Handle white space
Whitespace placed before any symbol inside the handlebars will cause an error. Correct: {{expression}}{{dateFormat}} Incorrect: {{ expression}}{{ dateFormat}} // note the leading whitespace Error: {{expression {{field}} // second set of opening braces seen as new expression
Retrieve WooCommerce consumer key and consumer secret
Sign in to your WooCommerce account. Navigate to WooCommerce > Settings > API > Keys/Apps Click Add key. Add a description and select the WordPress user for which you want to generate the key. Choose the level of access for this REST API key. Access levels include Read access, Write access, or Read/Write access. Click Generate API key and WooCommerce will generate REST API keys for the selected user. Now that keys have… Continue reading Retrieve WooCommerce consumer key and consumer secret
Set up a manual token-based auth connection to NetSuite
NetSuite StepsA. Enable your NetSuite account with Token-Based Auth (TBA) Log into NetSuite as an Administrator. Go to Setup > Company > Enable Features. Click SuiteCloud subtab. Scroll down to Manage Authentication section. Check the TOKEN-BASED AUTHENTICATION checkbox. Save your changes. B. Create custom NetSuite Role Log into NetSuite as an Administrator. Go to Setup > Users/Roles > Manage Roles. Click Customize beside the Celigo integrator.io Full… Continue reading Set up a manual token-based auth connection to NetSuite
Error ‘Element value exceeds the fixed length of 30’
Error Message Element value “[STRING]” exceeds the fixed length of 30. Use the truncate property if you wish to allow this element value to be truncated. Solution To set the truncate property for CSV files, modify the FTP import configuration. Select Truncate last row delimiter and save the configuration.
Billing sync (NetSuite-Magento)
The Billing flow “NetSuite Billing to Magento Invoice Add” data flow exports Invoices from NetSuite to Magento. The data flow exports fully/partially billed orders in NetSuite as invoices in Magento. STEPS 1.Generate cash sale from Item Fulfillment in NetSuite. 2.Restrict the saved search criteria with ‘eTail Order Billing exported’ 3. Perform mapping in the flow… Continue reading Billing sync (NetSuite-Magento)
Restrict more than one package line in the Item fulfilment record using Celigo
Hardcode the value “true” in the Packages: Replace All Lines in the Celigo.
How to update the Related Products in Magento using NetSuite-Magento Integration
To update the related products field in Magento using a custom flow ‘NetSuite Related Item to Magento Linked Product’, need to add a new import step in the flow. STEPS 1.Create a new import 2.In the new import step, add the API Name, Operation, SKU as it is for updation. 3.Then the mapping is performed… Continue reading How to update the Related Products in Magento using NetSuite-Magento Integration
How to fetch multiple Item Records in a custom flow for syncing related items.
To fetch multiple item records in a custom flow which is created to sync related items of an item record in NetSuite as Linked Product in Magento, we can use handlebar expression in the import steps as shown below. In this way we can fetch multiple item records in the flow.