Requirement The requirement is to integrate Amazon Seller Central with NetSuite using Celigo. The Amazon Seller Central account in US marketplace region has to be integrated with NetSuite using the prebuilt Celigo Integration App. Our Solution Prerequisites NetSuite account (Sandbox and Production) with administrator permissions. Access to Celigo integrator.io Access to Amazon Seller Central Description… Continue reading PROPOSAL FOR AMAZON SELLER CENTRAL TO NETSUITE INTEGRATION USING CELIGO
Category: Celigo
Mapping Dropdown not Displaying any Available Options in Celigo flow
Issue: When saved search driven mappings are opened, Integrator.io makes a preview call into NetSuite to obtain the values in the Saved Search. If that search has no records or if the first record has any invalid setup, it will not display the dropdown values. Resolution: Ensure the associated saved search is public, at least one record is available… Continue reading Mapping Dropdown not Displaying any Available Options in Celigo flow
Shipping bundled products separately in Magento 2 integration app
There is a requirement to ship Bundled products separately but each time a Fulfillment export occurs, it ships everything. Solution:In Magento, select ‘Separately’ under ‘Ship Bundle Items’ on the item in Magento2 and this will allow for Bundles to ship with multiple shipments.
Passing the data in response to the next step in Rest API connection – Celigo
After the import step go to the response mapping and create a mapping for the _json field as the following The HTTP response looks like the following Then in the field mapping add the path to this value in HTTP response and map it with the field in which we need to add this data
How to add a handlebar inside a handlebar
Use a bracket to separate the handlebars. Please check the following for an example {{#if line_items.0.properties.0.value }}{{#contains line_items.0.properties.0.value “Pre Order”}} {{dateFormat ‘MM/DD/YYYY’ (replace line_items.0.properties.0.value “Pre Order | Due In ” ”) ‘DD/MM/YYYY’}}{{/contains}}{{/if}}
Iterating through an array in the handlebar
If you have an array of objects, using the following way we can iterate through each object
Celigo Integration App vs Quickstart Integration Template
An Integration App offers much more than a Quickstart integration template. If you are planning to integrate two applications in a standard way (assuming you have an Integration App for those applications), then it is always best to go with the Integration App. With an Integration App, the integration will receive bug fixes and new functionality and settings.… Continue reading Celigo Integration App vs Quickstart Integration Template
HOW TO: Use handlebars to pass the value of a variable in an array as part of the Relative URI
In this scenario, you need to pass the value of a variable in an array. You have 3 items in your array and would like to send the product as part of the Relative URI { “Data”: [ { “product”: “bikes” }, { “product”: “snowboards” }, { “product”: “skis” } ] } Choose Yes (Advanced) on the One… Continue reading HOW TO: Use handlebars to pass the value of a variable in an array as part of the Relative URI
BigCommerce Order Status and Ids
Status id Name Description 0 Incomplete An incomplete order happens when a shopper reached the payment page, but did not complete the transaction. 1 Pending Customer started the checkout process, but did not complete it. 2 Shipped Order has been shipped, but receipt has not been confirmed; seller has used the Ship Items action. 3… Continue reading BigCommerce Order Status and Ids
Proposal For Wayfair – Netsuite Integration
Proposal summary The proposal covers the scope of Wayfair and NetSuite Integration. Requirement The requirement is to create two custom flows between Wayfair and NetSuite Import Dropship orders from Wayfair to NetSuite as Sales Orders Update Inventory Stock from NetSuite to Wayfair Our Solution We have gone through the way fair API documentation. We… Continue reading Proposal For Wayfair – Netsuite Integration