Mongo DB

Mongo DB – platform that helps to store, retrieve, manage unstructured or semi structured data in JSON format called BSON (Binary JSON). Users: You can create a collection called “users” to store user-related information. Each user can be represented as a document within this collection. Transactions: For tracking transactions, you can create a separate collection… Continue reading Mongo DB

Published
Categorized as Celigo

Create a dynamic lookup in Celigo

Click the mapping button in the center of the import step. The Edit mapping window opens. Click the Settings button next to the field you are mapping. The Settings window opens. In the Field mapping type section, click Lookup. Select Dynamic search in the Options section. Enter the Relative URI. Select an HTTP method. Enter the Resource identifier path. Enter a unique value in the Name field so that you can identify… Continue reading Create a dynamic lookup in Celigo

Published
Categorized as Celigo

Create multiple item fulfilment in the NetSuite using Celigo

Create export for read the sales order details from the NetSuite and create lookup to get the shipment details from the shipbob(third party). In the response mapping of the lookup, assign the data to lineDetailsLookup In the Import side, click the one to many option yes and mention the response mapping in the path field… Continue reading Create multiple item fulfilment in the NetSuite using Celigo

Published
Categorized as Celigo

Sync Product Category from Magento to NetSuite

This sync can be done by using Magento Category to NetSuite Add/Update flow in Celigo. The product categories in Magento is as shown below. To sync this category into NetSuite, perform mapping in celigo as shown below. Then run the flow and verify the sync in NetSuite by navigating to Customization> Lists, Records, Fields> Record… Continue reading Sync Product Category from Magento to NetSuite

Debug scripts in integrator.io

To add JavaScript debugging statements to your integrator.io scripts, call a console object method, as follows: Method Description Level console.debug(string1, string 2, …) Fine-grained informational events that are most useful to debug an application. Debug console.info(string1, string 2, …) Equivalent methods for printing informational messages to the execution log. Info console.log(string1, string 2, …) console.warn(string1, string 2, …)… Continue reading Debug scripts in integrator.io

Published
Categorized as Celigo Tagged

Amazon S3 – NetSuite integration

Amazon S3 (Simple Storage Service) offers object storage of storing and retrieving data from anywhere on web. Each piece of data is called ‘object’ and stored in containers called ‘buckets’. To get connection with celigo ,the required fields are Name Access key ID Secret access key Ping bucket The prebuild flows are : Export attachments… Continue reading Amazon S3 – NetSuite integration

Published
Categorized as Celigo

Install the Magento2-NetSuite Integration in Celigo

STEPS Login to your integrator.io account. In the left pane, click Marketplace. On the Marketplace page, click Magento 2. Click Install. On the “My Integrations” page, you can now find the Magento 2 – NetSuite integration app. On the tile, click Continue setup. Configure your connections. (NetSuite, Magento) Install integrator bundle. Install Magento bundle. Install Magento Extension After completing all these… Continue reading Install the Magento2-NetSuite Integration in Celigo

HTTP request body to update the Inventory quantity of a single item on Amazon Seller Central

<?xml version=”1.0″ encoding=”utf-8″ ?> <AmazonEnvelope xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xsi:noNamespaceSchemaLocation=”amzn-envelope.xsd”> <Header> <DocumentVersion>1.01</DocumentVersion> <MerchantIdentifier>xxxxxxxxxxxxxx</MerchantIdentifier> <FulfillmentCenterID>xxxxxxxxx</FulfillmentCenterID> </Header> <MessageType>Inventory</MessageType> <Message> <MessageID>1</MessageID> <OperationType>Update</OperationType> <Inventory> <SKU>ASUSVNA1</SKU> <Quantity>8</Quantity> </Inventory> </Message> </AmazonEnvelope>

Hook

PreMap Hook: Formatting data needed for mapping. PostMap Hook: Setting default values based on mapped data. PostSubmit Hook: Validating the response from the target system.

Published
Categorized as Celigo

Sync Cancellation in Shopify-NetSuite Integration

In Shopify NetSuite integration app, there is provision to sync order cancellations from NetSuite to Shopify and vice-versa. This bi-directional behavior simplifies the cancellation process. Customers can choose to provide the reason for cancellation, auto restock inventory.  NetSuite Cancellation to Shopify Cancellation Add flow syncs fully canceled Shopify orders from NetSuite to Shopify when the… Continue reading Sync Cancellation in Shopify-NetSuite Integration