There are three types of accounts within the Celigo Platform: Account Owner Highest permission level available Only one allowed per account Often the creator of the account Abilities include: Creating and editing flows and flow components Inviting users Configuring user permissions Transferring account ownership Admin Second highest permission level available Same abilities as account owner… Continue reading Types of Accounts in Celigo
Category: Celigo
Field Mapping Types in Celigo
There are four types of field mapping available in the Celigo Platform. Standard mapping, which is a direct one-to-one match, is the default type. The other three options are hard-coded, lookup, and handlebars expression. We can switch to the field mapping type that we need by selecting the gear icon at the end of a… Continue reading Field Mapping Types in Celigo
preMap Hook in Celigo
The pre map hook is invoked on a page of records before the records are mapped from source to destination structures. This hook can be used to validate, update, or ignore records before mapping rules are run. Changes made to records in this hook are localized and will not get passed along to subsequent steps… Continue reading preMap Hook in Celigo
Error in dateFormat handlebar expression when input is empty
Scenario: The below given handlebar expression is used for date format conversion. {{dateFormat “YYYY-MM-DD” custbody_field1 “DD-MM-YYYY”}} An error is encountered when the field1 is empty in NetSuite. Failed to generate field value from template: {{dateFormat “YYYY-MM-DD” custbody_field1 “DD-MM-YYYY”}}. Details: handlebars Helper {{dateFormat}} expects date argument when you have i/p date format. Solution: Modify the expression… Continue reading Error in dateFormat handlebar expression when input is empty
Get Inventory item id from Shopify used in the Celigo flow NetSuite inventory to Shopify inventory.
Inventory item is a combination of a variant and a location. If you want to find quicky an inventory_item_id without using API, you can check that url (variant edit url + .json) /admin/products/[ID_PRODUCT]/variants/[ID_VARIANT].json the result can be: { variant: { id: XXXX, product_id: XXXX, title: “Small”, price: “50.00”, sku: “”, position: 1,… Continue reading Get Inventory item id from Shopify used in the Celigo flow NetSuite inventory to Shopify inventory.
Check integrator.io status
You can easily check system status at any time on the status.celigo.com website. If there are no reported service disruptions, yet you are experiencing problems with multiple flows processing as usual, please determine which of the following applies. All problematic flows use connections to the same application If all flows that are not processing as… Continue reading Check integrator.io status
Handle whitespace in Handlebars
Beware of whitespace lurking at the beginning of an expression. 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
NetSuite CSV import not triggering realtime export
Problem: When performing a CSV import into NetSuite my real time export is not running even if the Execution Context of the export is set to CSV Import. Solution: The CSV import preference of “RUN SERVER SUITESCRIPT AND TRIGGER WORKFLOWS” is not checked within NetSuite. Without this box checked the user event script that triggers… Continue reading NetSuite CSV import not triggering realtime export
Error: SSS_REQUEST_LIMIT_EXCEEDED
This is the full checklist to diagnose and address these errors due to the NetSuite Governance. Here are the most common steps to diagnose and fix this type of error: Contact NetSuite to determine how many concurrent requests are allowed for your NetSuite account. From the Home page, navigate to Resources → Connections. Open every individual NetSuite… Continue reading Error: SSS_REQUEST_LIMIT_EXCEEDED
Error: “Not Found” on Celigo (NetSuite – Shopify) Inventory Management
When you try to create an order, create fulfillment, or add inventory, if any of the required fields/data is missing, the following error message is displayed on the integration app dashboard, “Unable to sync the inventory for the item <NetSuite internal ID>. One of the required fields is missing. The error might be displayed because of… Continue reading Error: “Not Found” on Celigo (NetSuite – Shopify) Inventory Management