In Shopify NetSuite integration app, there is provision to sync order cancellations from NetSuite to Shopify and vice-versa. This bi-directional behavior simplifies the cancellation process. Customers can choose to provide the reason for cancellation, auto restock inventory. NetSuite Cancellation to Shopify Cancellation Add flow syncs fully canceled Shopify orders from NetSuite to Shopify when the… Continue reading Sync Cancellation in Shopify-NetSuite Integration
Author: Jismol Johnson P
Editions Of Shopify-NetSuite Integration
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
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”
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
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
How to distingush between normal item and Matrix child item in a saved search?
To distingush between normal item and matrix child item, we can use Formula(Numeric) field in the result tab of item saved search. Before applying this formula, we need to display the ‘parent’ field in the result tab. Then on saving the search we will get the results i.e 4 and 1 accordingly.
Set Visibility field in Magento based on item type in NetSuite
The visibility field of Magento can be arranged on the basis of the type of item in NetSuite. This can be done by creating a custom visibility field in NetSuite and performing lookup mapping in the NetSuite Magento integration flow. In Netsuite item record, a List/Record type custom field named “visibility” is created as shown… Continue reading Set Visibility field in Magento based on item type in NetSuite
error: “NetSuite transaction not found”
Solution: After you run the Amazon Settlement Report to NetSuite Custom Settlement Records flow successfully, the integration app automatically triggers the NetSuite Settlement Transaction to NetSuite Payment Add flow. If you receive errors related to “NetSuite transaction not found” after the settlement flow is run, check if there are any FBA orders with Pending state… Continue reading error: “NetSuite transaction not found”
Display the full content of a custom field in the saved search result
As a standard, the saved search will not display all the content of the long text field. Solution: Change the field type for the existing field from Long Text to Text Area.Please note that changing the field type may cause in the removal of existing content.Take a backup of the field details if possible.ORCreate a… Continue reading Display the full content of a custom field in the saved search result