Troubleshoot Shopify – NetSuite integration app errors

1. Configure missing ship method mapping.
2. Then go back to the dashboard and view the Error dialog. Click Retry to re-run the Order Import flow successfully.

1. Configure missing payment method mapping.
2. Then go back to the Integrator dashboard and view the Error dialog. Click Retry to re-run the Order Import flow successfully.

1. In NetSuite, go to Lists > Accounting >Items > New.
2. Create a NetSuite Item with the “Name” field value as “White Tee” and Save.
3. Go to the dashboard and retry the Order Import flow.

1. In NetSuite, go to Setup > Company > Autogenerate numbers. Under Type, enable for the type Customer.
2. Go to the flowing dashboard and retry the Order Import flow.

1. Go to integrator.io and navigate to the Shopify Integration App tile.
2. Go to Flows > Order.
3. Next to the Shopify Customer to NetSuite Customer Add/Update flow, click Mappings to edit the Field mappings.
4. In the Mappings section, look for the 'desired field' in the left column fields and in the right column fields. Click Edit (Gear icon) to view the Settings page.
5. Choose Field mapping type and select Options.

6. Save your changes.

7. Now go to the Integrator dashboard and view the Error dialog. Click Retry to re-run the Order Import flow successfully.

1. Log in to your  Shopify account and navigate to the "Orders" section. Find order #1234.
2. Go to each individual item & ensure each of these items have a value populated for the "SKU" field on the Shopify item record.
3. In your integrator.io account, on the Dashboard, click Retry Data and locate the SKU field with a null value.
4. Replace the null value in the JSON with the correct SKU value as entered on the Shopify Item record.
5. Click Retry, to import the order into NetSuite.

The error occurred due to Shopify orders without SKU or the item in NetSuite is inactive. You will need to make sure that all your products have SKUs or the NetSuite items are active.

To resolve this issue:

1. In NetSuite, check if the item is inactive, update the status as active and retry the error.
2. In NetSuite, check if the item is active, then manually edit the retry data and add the SKU by viewing the error.
   1. In your integrator.io account, on the Dashboard, click Retry Data and locate the line item and add the SKU value.
   2. Save the changes and then retry the error.
3. If the issue persists, add a default item for all the items without SKUs, and then retry the error.

Once all your products have SKUs in Shopify, you may keep the settings so whenever you encounter the same error, you will still be able to import the order but using a default item in NetSuite.

Extension returned statusCode error: 504. 200 is a success.

These errors occur during the NetSuite or Shopify's downtime when the flow is run.

To resolve the error,  go to the Dashboard and retry the error.

Failed to add Shopify Order #EU1469. A mapping error occurred. Could not find a match for "["itemid","isempty"]" for the record type "item".'

Item lookup is broken or set to standard.

unexpected
{ [Error: socket hang up] code: 'ECONNRESET' }

When you try more than four orders (multi-order retry).

unexpected
{ [Error: connect ECONNREFUSED] code: 'ECONNREFUSED', errno: 'ECONNREFUSED', syscall: 'connect' }

The database might have disconnected.

user_error
Failed to add Shopify Order #1159. Please enter value(s) for: Bill To

When Bill to is marked mandatory in NetSuite.

user_error
Failed to add Shopify Order #1159. Please enter value(s) for: Ship To

When Ship to is marked mandatory in NetSuite.

invalid_key_or_ref

Invalid price reference key -1

If the custom price levels are not turned on and the item price level is set to the name field in intergrator.io, instead of internal ID.

• Enable custom/multiple price levels in the company setup.
• Look into the intergrator.io settings for the order import. The item price level is looking to export a name export field with a number on the export side.

unexpected

{ [invalid_extension_response: Extension result does't contain the same number of elements as the request object.] name: 'invalid_extension_response', source: 'sc4n' }

The error could appear for the following reasons:

• More than one order per job
• A conflict in configuration records in NetSuite

Resolution 1:

1. Go to the intergrator.io  dashboard, the error column contains the error descriptions.
2. Hover over the error.
3. Click View to open the error dialog.
4. In the error dialog, select the Checkbox for one Order and click Retry. Then select the next Order and Retry. Do not retry two orders at a time.

Resolution 2: Contact your NetSuite administrator to resolve conflicts in the configuration record.

500

Unable to get the required data from export due to the error: {"errors": "Internal Server Error"}. To resolve the error contact Celigo Support.

The endpoint server not responding.

1. Go to Connections > Shopify > Actions > Edit connections.
2. Click Save and authorize.

Click Update Unlisted App in the pop-up window if the Shopify app needs an update. Sign in to Shopify with admin permissions.

Unable to create the order in NetSuite for the Shopify order #XXXXXXXXX Failed to create, update/transform record because The field contained more than the maximum number ( 300 ) of characters

A field in your import contains too many characters. There is a 300-character limit for this field. 

Failed to add/update customer for Shopify order #1234567. Please enter value(s) for: Last Name

1. Go to integrator.io and navigate to the Shopify - NetSuite integration app tile.
2. Click the Flows > Order.
3. Navigate to "Shopify Customer to NetSuite Customer Add/Update" and click the Mapping icon to edit the Field mappings.
4. In the Mappings section, look for the 'desired field' (i.e. Last Name) in the left column fields.  Click Edit (Gear icon) to view the Settings.
5. Use the "Multi-Select" option & enter this expression:

{{#if $.last_name}}{{$.last_name}}{{else}}{{$.addresses[*].last_name}}{{/if}}

1. In NetSuite, from the global search, enter Page: Customers.
2. On the Customers page, click Edit next to the appropriate customer. 
3. Check the Active check box on the customer record.
4. Log in to your integrator.io account. 
5. Click on the Shopify - NetSuite integration app tile.
6. Go to Flows > Order, and re-run the order flow. 

A subsidiary of the Item record in NetSuite does not match with the Subsidiary on the Customer record.

1. In NetSuite, go to to Lists > Accounting > Items. Find the Item record with internal id "1009".
2. Edit the Item Record & set the Subsidiary with internal id "1" & Save the Item Record.

1. In NetSuite, navigate to Lists > Accounting > Shipping Items.
2. Find the ship method record with internal id "4115".
3. Edit the record & set the Subsidiary value to the value set on the Customer record with Internal Id "33676" 
4. Click Save.

A subsidiary of the Item record in NetSuite does not match the Subsidiary on the Customer record.

Generally, this error could occur because of permissions issues. For example, an item is designated to be sold only under  (Subsidiary 1) and nowhere else. Giving access to the rest of the subsidiaries should resolve this issue.

1. In NetSuite, go to to Lists > Accounting > Items. Find the item record with internal id "####".
2. Click Edit. 
3. Scroll to the Classification > Subsidiary section and check the INCLUDE CHILDREN checkbox.
4. Click Save. 

invalid_key_or_ref

Failed to create Customer Deposit for Shopify Order XXXXXX due to Invalid reference key of Order XXXXXX for Customer XXXXXX.

Reason 1: If you map the payment method on the sales order, NetSuite restricts to a create customer deposit.

(OR)

Reason 2: Occurs when the sales order bills before the deposit can be created in NetSuite from Shopify, orders that do not require fulfillment in Netsuite will automatically bill, which happens before the deposit can successfully be posted 

Solution 1:

1. Remove the payment method mappings on the Shopify order to NetSuite order (cash sale or sales order) flow.
2. Create the mappings on the Shopify transaction to NetSuite customer deposit (add) flow.
3. Remove the existing payment record on the NetSuite sales order.
4. Retry the error on the integration app Dashboard.

Solution 2:

Import such orders in a pending approval status and approve them once the deposit has been created.