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.

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. 

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.

invalid_key_or_ref

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

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.

1. Log in to your NetSuite account with admin credentials.
2. In the global search box, enter "Page: Customers".
3. On the Customers page, next to the appropriate customer, click Edit.
4. Go to eTail tab > Celigo Shopify Customer Id Map sub-tab.
5. Delete the “Celigo Shopify customer ID map.”
6. Click Save.
7. From your Shopify NetSuite integration app, go to Flows > Order.
8. Run the NetSuite customer to Shopify customer (add or update) flow.

1. Log in to your NetSuite account with admin credentials.
2. In the global search box, enter "Page: Customers".
3. On the Customers page, next to the appropriate customer, click Edit.
4. Go to eTail tab.
5. Delete the eTail address IDs that are not found in Shopify.
6. Click Save.
7. From your Shopify - NetSuite integration app, go to Flows > Order.
8. Run the NetSuite customer to Shopify customer (add or update) flow.

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"

1. Go to Flows.
2. Next to the Shopify order to NetSuite order (cash sale or sales order) flow, click Mappings.
3. Next to the below mapping, click Settings.
   

   Export field (Shopify)	Import field (NetSuite)
   updated_at	Date

4. On the Settings window, in the Date format drop-down menu, select MM/DD/YYYY.
5. Click Save & Close.
6. Run the flow.

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"

1. Open the respective Order in NetSuite.
2. Check if a line item exists with the mentioned order line ID.
3. If the order line ID exists for the adjusted line, sync the updated order using the Shopify order to NetSuite order (cash sale or sales order) flow.
4. Go to Dashboard and retry the error.

As per the message mentioned in the "Error message" column, requires to configure the inventory detail for line 4. Perform the following steps:

1. Verify if the inventory status check box is checked in NetSuite.
2. If yes, please assign the sub-record mapping details by following the steps mentioned in Assign status details to Shopify inventory.

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: ##

1. In NetSuite, open the respective order.
2. Check the quantity for the order line. mentioned in the error.
3. If the quantity for the particular order line is updated as part of the order edit adjustment, then retry the error, the Shopify order to NetSuite order (cash sale or sales order) flow captures this edit and syncs to NetSuite.
4. Or else, if the order is manually fulfilled, then the error can be resolved on the Dashboard.

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

1. Be sure to check the location ID in the flow's mapping.
2. The subsidiary on the location and item is the same in NetSuite.

1. In your integrator.io account, click on the "Retry Data" button with the pencil icon & note down the "order_number" of the fulfillment that failed to export.
2. In Shopify, Navigate to the above-found order & check if the line item "ABC" is already fulfilled or refunded.
3. If all the items on the order are already fulfilled, skip steps 4 & 5 and jump to step 6.
4. In NetSuite, navigate to the fulfillment record & manually update the record to remove items that cannot be fulfilled anymore & uncheck the "ETAIL ORDER FULFILLMENT EXPORTED" checkbox so that you can re-trigger the export.
5. Save the NetSuite fulfillment record.
6. Once the record is successfully exported, mark the previous error as "Resolved" in your integrator.io account.

1. In your integrator.io account, click on the "Retry Data" button & locate the SKU field with a null value.

2. Populate the correct "SKU" value on the Shopify Item record.

3. Also, replace the null value in the JSON with the correct SKU value as entered on the Shopify Item record.
4. Click on the "Retry" button to re-import the data into NetSuite.

sss_time_limit_exceeded
Script Execution Time Exceeded.

1. In your integrator.io account, click on Actions > Edit flow.
2. Click Export.
3. In the Configure export type section, from the Export Type drop-down list, select Delta. 
4. Go to the Advanced section, leave the Batch size limit blank, and set the Page size to 15.
5. Click Save & Close.
6. Run the flow.

If the issue persists, change the page size to 10 and re-run the flow. Keep decreasing the page size until you find the value that would allow the flow to run successfully.

1. In your integrator.io account, click on the "Retry Data" button with the pencil icon & note down the "Internal Id/Id" of the item that failed to export.
2. In NetSuite, navigate to Lists > Accounting > Items. Find the item record with the above found internal ID.
3. Edit the record & set the correct Variant Id in the "Product Variant Id" field under the "eTail" tab as present on the item in Shopify.

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. 

1. Log in to your integrator.io account.
2. Go to Flows > Refund.
3. Next to the Shopify refund to NetSuite refund (add) flow, click Mappings.
4. On the Edit mapping window, click Post order refunds (invoice or cash sale) to NetSuite.
5. Configure the following mapping:
   

   Export field (Shopify)	Import field (NetSuite)
   You can hard code the value of the Shopify discount item configured in NetSuite in "quotes" or configure as a lookup	Discount (InternalId)

6. Click Save & close.
7. On the integration app Dashboard, you click Retry to resolve the error.

1. Check if the Payout ID mentioned in the error message exists in the NetSuite account.
2. If the Payout ID doesn’t exist, please trigger the Payout flow with a historic date selected as per the Payout.
3. This trigger will also create the Deposit record.
4. Once the flow is successful, mark the original error as Resolved.