There are four editions in Shopify NetSuite Integration app. The editions and the flows which come under them are listed as shown. 1.Starter (previously “standard”) edition: Imports/Updates Customers from Shopify to NetSuite Imports Sales Orders from Shopify to NetSuite Imports Cash Sale from Shopify to NetSuite Imports Order Transactions from Shopify to NetSuite Exports Fulfillments… Continue reading Editions Of Shopify-NetSuite Integration
Category: Celigo
Boolean selectors in celigo
Boolean selector: NOT is enabled by default in celigo, meaning that the filter excludes any data that meets the criteria you define with the rules. If NOT is disabled, the filter includes any data that meets your defined rule criteria. Ex: If you want to exclude all records that have customer ID 1256 , select… Continue reading Boolean selectors in celigo
Cron expressions
Examples of corn expressions: * * * * * Every minute 0 * * * * Every hour 0 0 * * * Every day at 12:00AM 0 0 ? * FRI At 12:00AM only on Friday 0 0 1 * ? At 12:00AM on the first day of the month
Error: “Failed to refund order #*********, No invoice/cash sale found in NetSuite”
Data Flow: Shopify refund to NetSuite refund (add) flow Error Code:billing_transaction_not_found Error Message: “Failed to refund order #*********, No invoice/cash sale found in NetSuite.” Reason: This error occurs when the flow could not filter and identify the cancelled orders and generate a customer refund. Resolution: Adding the import filters for the fields “transaction.length”, “cancel_reason” and “cancelled_at” should resolve… Continue reading Error: “Failed to refund order #*********, No invoice/cash sale found in NetSuite”
Error :”Failed to save record because Please choose an item to add”
Data Flow: Shopify refund to NetSuite refund (add) flow Error Code:user_error Error Message: “Failed to save record because Please choose an item to add.” Reason: This error occurs when the flow can’t find an SKU from the data to process. Resolution: Adding Items: eTail Order Linet ID field in the field mappings should correct the problem. Log… Continue reading Error :”Failed to save record because Please choose an item to add”
Export types in Celigo
When exporting data from NetSuite, integrator.io provides four options for the Export type All – Export all data returned in the search each time the export is run Delta – Export all data with a date/time value for the selected field that is greater than the last time the data flow was run Once – Export any data that… Continue reading Export types in Celigo
How to fetch the formatted output of html code from a custom field in item record to Magento
steps 1.Add the html code in the custom field in item record 2.Add formula(Text) field in the result tab of saved search 3.The saved search result will be displayed as shown. 4. Map this field in celigo mapping and when running the flow and verifying the result in Magento we can see that the formatted… Continue reading How to fetch the formatted output of html code from a custom field in item record to Magento
Field mapping type indicators
Letters next to mapped values indicate the field mapping type. none – Standard: Product is a standard mapping value. L – Lookup: Country is a lookup mapping value. M – Multi-field: Transaction_date is a multi-field mapping value. H – Hard-coded: City is a hard-coded mapping value
Display the visibility field in Magento as default if this is empty in NetSuite
Displaying the visibility field of Magento as Catalog, Search by default if no visibility is given in NetSuite. steps: For this some arrangements are done in the lookup mapping as shown. Here the check box for ‘use custom default value’ is checked. Since the purpose is to set “Catalog, Search” as the default value, enter… Continue reading Display the visibility field in Magento as default if this is empty in NetSuite
Relevance of integrator.io sandbox license
If you are building a custom integration, then you can create an integrator.io connection to the NetSuite sandbox environment without purchasing an integrator.io sandbox license. You can specify the Environment setting of the NetSuite connection. In this use case, NetSuite is taken as an example, but this applies to any other application. Integration app environment licensing requirements:… Continue reading Relevance of integrator.io sandbox license