When Importing the Orders from Amazon Seller Central using Celigo flows, the Item Price inclusive of tax is imported. The flow mapping by default is mapping the Item price inclusive of item tax. If there is requirement to exclude the tax the mapping for Item price can be modified as {{#if $.OrderItem[].ItemPrice.Amount}}{{ subtract $.OrderItem[].ItemPrice.Amount $.OrderItem[*].ItemTax.Amount}}… Continue reading Import Amazon Order without Tax
Category: Celigo
PROPOSAL FOR AMAZON SELLER CENTRAL TO NETSUITE INTEGRATION USING CELIGO
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
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