Contents
- Shopify and NetSuite connection errors
- Shopify order flow errors
- Shopify and NetSuite customer flow errors
- Shopify and NetSuite fulfillment errors
- Shopify product flow errors
- Shopify inventory flow errors
- Shopify and NetSuite refund flow errors
- Source: Shopify
Connection errors
Error message | Reason | Resolution |
Connection could not be established. Target service might be inactive. | This error is usually encountered when the integration app tries to connect to NetSuite and took a long time to do so. It can be that your NetSuite server might not be available at that time. | If there is retry data available, then you can retry the error. If there is no retry data, then you can just mark the error as resolved since this will be resolved by NetSuite once the connection is established. |
Shopify order flow errors
Flow impacted | Error code/ Message |
Likely cause | Resolution |
Shopify order to NetSuite order (cash sale or sales order) | missing_static_lookup Failed to add Shopify Order#1234. Could not find the mapping in static lookup. { Source: shipmethodLookup} { Key: Free Shipping} |
Shopify ship Method "Free Shipping" is not yet mapped to the corresponding ship method in NetSuite. |
|
Shopify order to NetSuite order (cash sale or sales order) | missing_static_lookup Failed to add Shopify Order#1234. Could not find the mapping in static lookup. { Source: paymentmethodLookup} { Key: direct} |
Shopify Payment Method "direct" is not yet mapped to the corresponding payment method in NetSuite. |
|
Shopify order to NetSuite order (cash sale or sales order) | value_lookup_failed Failed to add Shopify Order#1234. A mapping error occurred. Could not find "White Tee" in the "Name" field of the record type "item". |
An item with the following SKU "White Tee" not found in NetSuite. |
|
Shopify order to NetSuite order (cash sale or sales order) | unique_cust_id_reqd Failed to add Shopify Order#1234. Failed while creating customer, message: A customer record with this ID already exists. You must enter a unique customer ID for each record you create. To correct this record, click back and enter a new customer ID in the Customer field. Then, click Submit. |
A Customer record with the same First and Last Name already exists in NetSuite. | There are multiple ways to resolve this error: One way is to enable NetSuite 'Auto Generate Numbers' feature for Type Customer.
|
Shopify order to NetSuite order (cash sale or sales order) | user_error Failed to add Shopify Order #1234. Failed while creating customer, message: Please enter a value(s) for: Subsidiary. |
No mappings were found for Subsidiary under Customer Mappings section |
|
Shopify order to NetSuite order (cash sale or sales order) | user_error Failed to add Shopify Order#1234. Please choose an item to add |
SKU field on one of the items on the order in Shopify was empty at the time order was placed. |
|
Error code: "invalid_key_or_ref"
Flow impacted |
Error code/
Message |
Likely cause |
Resolution |
Shopify order to NetSuite order (cash sale or sales order) | invalid_key_or_ref Failed to add Shopify Order #1011. Invalid entity reference key 35007 |
This error indicates that the particular customer that is referencing, reference key 35007, is no longer an Active Customer. |
|
Shopify order to NetSuite order (cash sale or sales order) | invalid_key_or_ref Failed to add Shopify Order #1234. Invalid item reference key 1009 for subsidiary 1. |
A subsidiary of the Item record in NetSuite does not match with the Subsidiary on the Customer record. |
|
Shopify order to NetSuite order (cash sale or sales order) | invalid_key_or_ref Failed to add Shopify Order #1234. Invalid shipmethod reference key 4115 for entity 33676. |
A subsidiary of the shipping method does not match with the Subsidiary of the Customer. |
|
Shopify transaction to NetSuite customer deposit (add) |
invalid_key_or_ref Failed to create Customer Deposit for Shopify Order XXXXXX due to Invalid reference key of Order XXXXXX for Customer XXXXXX. |
If you map the payment method on the sales order, NetSuite restricts to a create customer deposit. |
|
Shopify and NetSuite customer flow errors
Flow impacted | Error code/ Message |
Likely cause | Resolution |
NetSuite customer to Shopify customer (add or update) | Unable to find the customer ID #1234567 in Shopify. To resolve the error, see Troubleshoot Shopify – NetSuite integration app errors. |
|
|
NetSuite customer to Shopify customer (add or update) | Unable to find the eTail customer address ID's ["1234567", "12434545"] for Shopify customer ID #123444567. To resolve the error, see Troubleshoot Shopify – NetSuite integration app errors. |
|
Shopify and NetSuite fulfillment errors
Flow impacted | Error code/ Message |
Likely cause | Resolution | ||||
Shopify fulfillment to NetSuite fulfillment (add) |
Failed to save the fulfillment record for the order #2966243868805 as Failed to create, update/transform record because You have entered an Invalid Field Value NaN/NaN/ NaN for the following field: trandate. For more information to resolve this error, refer to Troubleshoot Shopify - NetSuite errors" |
|
|||||
Shopify fulfillment to NetSuite fulfillment (add) |
Error code: item_not_found Error message: Failed to save the fulfillment record for the order #2966243868805 as The item with ETAIL ORDER LINE ID 642362317222911 is not available on the NetSuite sales order 2966243868805. For more information to resolve this error, refer to Troubleshoot Shopify - NetSuite errors" |
|
|||||
Shopify fulfillment to NetSuite fulfillment (add) | Failed to save the fulfillment record for the order #3650601517189 as Failed to save record because Please configure the inventory detail in line 4 of the item list.. For more information to resolve this error, refer to Troubleshoot Shopify - NetSuite errors" |
As per the message mentioned in the "Error message" column, requires to configure the inventory detail for line 4. Perform the following steps:
|
|||||
Shopify fulfillment to NetSuite fulfillment (add) |
Error code: item_already_fulfilled Error message: The requested fulfillment quantity for the order line item #### (order ####) is either more than the available quantity or already fulfilled. Available quantity in NetSuite: ## Order item quantity: ## |
Quantity mismatch |
|
||||
Shopify fulfillment to NetSuite fulfillment (add) |
Error code: invalid_key_or_ref Error message: Failed to save the fulfillment record for the order #3660927926405 as Failed to save record because Invalid location reference key 700 for subsidiary 3.. For more information to resolve this error, refer to Troubleshoot Shopify - NetSuite errors |
Location not found OR subsidiary mismatch on item and location in NetSuite. |
|
||||
NetSuite fulfillment to Shopify fulfillment (add) | 422 {"errors":{"base":["Line item \'ABC\' is already fulfilled"]}} |
Line Item cannot be fulfilled in Shopify. It has either been already fulfilled or refunded in Shopify. |
|
Shopify product flow errors
Flow impacted | Error code/ Message |
Likely cause | Resolution |
Shopify product ID to NetSuite item (mass update) | value_lookup_failed A mapping error occurred. Could not find a match for "["itemid","isempty"]" for the record type "item". |
SKU field on the corresponding item in Shopify is empty. |
|
NetSuite Matrix item to Shopify Product Add/Update |
sss_time_limit_exceeded |
It is possible that the data is too large and you might need to break the data into smaller pieces so that the flow could handle it. This can happen if the Export Type has been set to All. The default export type is Delta which means it will only export the data that has changed since the last run. |
|
Shopify inventory flow errors
Flow impacted | Error code/ Message |
Likely cause | Resolution |
NetSuite inventory to Shopify inventory | 404 {"errors":"Not Found"} |
Variant Id on the NetSuite Item is incorrect/nonexistent in Shopify. |
|
Shopify and NetSuite refund errors
Flow impacted | Error code/ Message |
Likely cause | Resolution | ||||
Shopify refund to NetSuite refund (add) |
Transaction Not in balance. Amount: <> |
This error is most commonly seen in NS accounts that have some specific tax-related setup like AvaTax or SuiteTax. The error might occur while refunding orders paid via gift card in addition to the refund adjustment scenario. |
|
Source: Shopify
Error message | Resolution |
In NetSuite, you are trying to refund more than the Shopify expected amount for the order ####. NetSuite refund amount #### and Shopify expected amount - ###. | |
The "Product title" field is a mandatory field in Shopify and the value is empty. | Enter a value in the field and retry to sync your products. |
Map at least one location in the "Map NetSuite locations with Shopify locations" setting or select a default Shopify location from the "Use Custom Default Value" drop-down list. | See Support for Shopify multi-inventory. |
Unable to find the corresponding payout custom record in NetSuite for the Shopify payout ###. |
|
Comments
0 comments
Please sign in to leave a comment.