Imports the Magento Attribute Sets into NetSuite. The imported Attribute Sets list is then provided as a dropdown option (MAGENTO1 ATTRIBUTE SET) for the NetSuite Items under the ‘Magento 1’ tab. The Attribute Set information is stored in the custom record Magento1 Product Attribute Set. After running the above dataflow, you should see all the Attribute Sets along… Continue reading Sync Magento Attribute Sets from Magento to NetSuite
Tag: Celigo
PROPOSAL FOR AUTOMATING CARRIER SELECTION DURING SALES ORDER IMPORT FROM SHOPIFY
Proposal Summary This proposal summarizes the functionality for automatically setting a default shipping carrier in NetSuite sales order from the corresponding Shopify sales order while performing the order import via Celigo. Requirement The customers should be able to choose a shipping carrier in Shopify and then have that selection be set as the default carrier… Continue reading PROPOSAL FOR AUTOMATING CARRIER SELECTION DURING SALES ORDER IMPORT FROM SHOPIFY
Error in Customer flow, unable to add new Shopify customer to NetSuite.
Error: Multiple matches were found for customer record with criteria: [[“email”,”is”,”test@gmail.com”],”AND”,[“custentity_celigo_shopify_store”,”is”,”@NONE@”]]. Please use different secondary lookup criteria and try again. Solution: Check if there are multiple customer records in NetSuite for test@gmail.com. To resolve this, t’s either you need to make sure that there’s no duplicate customer record in NetSuite with email address or you… Continue reading Error in Customer flow, unable to add new Shopify customer to NetSuite.
Error: Extension returned statusCode 504. Expected 200.
The mentioned error occurred in the pre built Shopify-NetSuite Celigo Integration. Error: Extension returned statusCode 504. Expected 200. Response body = Solution: The 504 error is a gateway timeout error that usually occurs when the remote endpoint is not responding in a timely manner (perhaps due to downtime or a heavy load). Either Netsuite or… Continue reading Error: Extension returned statusCode 504. Expected 200.
Dynamically assign default customer for Magento Orders
The Magento2-NetSuite Integration app provides an option to assign one default customer to all Magento Orders. For this the internal id of the customer is to be specified and the Add all orders against the NetSuite customer is to be marked true. We can assign different default customer to Magento Orders from different Stores. For… Continue reading Dynamically assign default customer for Magento Orders
Setting current date in Celigo mapping
Go to the field mapping and on the source side give the following multifield expression. This will add the current date and time in Netsuite records. {{dateFormat “MM-DD-YYYY HH:mm:ss” timeStamp}} The date format in the middle should be the one that the specific Netsuite connection is using
Shopify Netsuite IA Error – Failed to create Customer Deposit for Shopify Order
Error: Failed to create Customer Deposit for Shopify Order XXXXXX due to the Invalid reference key of Order XXXXXX for Customer XXXXXX. Reason: If you map the payment method on the sales order, NetSuite restricts to a create customer deposit. Solution: Remove the payment method mappings on the Shopify order to NetSuite order (cash sale or… Continue reading Shopify Netsuite IA Error – Failed to create Customer Deposit for Shopify Order
Import Not paid Shopify orders to Netsuite using IA
There are two options to do this We have two options for bringing pending payment orders from Shopify to Netsuite. 1 ) First, we have to go to celigo settings > Order There give the Shopify order id. The Shopify order id will be the id in the order URL. Then save it. Also you… Continue reading Import Not paid Shopify orders to Netsuite using IA
Import Amazon Order without Tax
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
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