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
Author: Aishwarya M J
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.
Saved search formula to get transactions created before a specific time
The formula CASE WHEN ROUND((({today}-{datecreated})*1440),6) > 15 THEN 1 ELSE 0 END”, “equalto”, “1”] can be used to exclude the transactions which are created 15mins before the script execution. This formula becomes useful when we are running scripts in a schedule of 15 minutes of less where a record may have completed its creation before… Continue reading Saved search formula to get transactions created before a specific time
Transaction Saved Search shows Total Amount in base currency instead of foreign currency.
In a saved search for Customer Return the transaction total is shown different than the total shown in the Customer Return. The currency set in Customer Return is Euro but the total shown in saved search is in USD which is the base currency. There is a field named CONSOLIDATED EXCHANGE RATE in the saved… Continue reading Transaction Saved Search shows Total Amount in base currency instead of foreign currency.
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
Testing NetSuite Connector Product Sync
Before syncing your test item to the marketplace or cart, you must have selected a test item, noted its SKU, and flagged it for syncing. These are prerequisites for product sync testing. Product sync test will modify the data on your marketplace or cart. Ensure that you select a sample test item whose data if… Continue reading Testing NetSuite Connector Product Sync
Preview the Product Mapping in NetSuite Connector
You can preview the data NetSuite Connector sends to the marketplace or cart for a product. There are following two methods in which you can view the data: From the Products dashboard From the Products Mappings page To view data mapping from the Products dashboard: Go to Data Flows > Products.The Products dashboard opens and… Continue reading Preview the Product Mapping in NetSuite Connector
Adding a Shopify Metafield Product Mapping in NetSuite Connector(FarApp)
Log in to app.farapp.com. Select the Shopify connector and the relevant account. Go to Mappings > Products. Click Add Mapping. The Add Shopify Mapping window opens. You will be able to view all required, standard, and uncommonly used fields for the current channel, for a shopify metafield select the standard and there you can select metafields. In… Continue reading Adding a Shopify Metafield Product Mapping in NetSuite Connector(FarApp)
PROPOSAL FOR INTEGRATION OF CSV FILES FROM SFTP SERVER TO NETSUITE USING CELIGO
Requirement The requirement is to export the csv file from their SFTP server to NetSuite using the Celigo. Following are the integration to be implemented. Import Demographic files to NetSuite Import Appointment files to NetSuite Import of referral files is not included in this scope. Our Soultion Approach 1. Prerequisites NetSuite account (Sandbox and Production)… Continue reading PROPOSAL FOR INTEGRATION OF CSV FILES FROM SFTP SERVER TO NETSUITE USING CELIGO