Resolve Shopify refund errors

Error 1: 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.

1. Log in to your integrator.io account.
2. Click Shopify - NetSuite integration app.
3. Go to Flows > Refund section.
4. Next to the Shopify refund to NetSuite refund (add) flow, click Mappings.
5. Click the respective import, Post order refunds (invoice or cash sale) to NetSuite, or Post customer refunds to NetSuite.
6. Configure the following mapping:
   

   Export field (REST API)	Import field (NetSuite)
   refund_line_items[*].line_item.id	Items:eTail Order Line Id

7. Click Save & close.
8. Go back to the Dashboard and click Retry to solve the error.

Error 2: 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 the problem. Apply the import filters as shown in the following image.

For the cancelled orders, the "cancel_reason" and "cancelled_at" fields will have some values, so by adding another filter on the refund flow, on the field "transaction.length", will import only refunds with value as empty. This will ensure that none of the cancelled orders reach to NS Import Adapter.

This import filter will first check if "transactions.length" is ​not empty. In addition to this, the flow will also check if the refunds have empty "cancel_reason" and "cancelled_at" nodes. With this resolution, the flow will not miss any normal refunds, cancelled orders with transactions array. 

Error 3: Script Execution Time Exceeded

Data Flow: Shopify refund to NetSuite refund (add) flow

Error Code: sss_time_limit_exceeded

Error Message: "Script Execution Time Exceeded."

Reason: This error occurs when the flow is handling and processing a high volume of refunds.

Resolution: Adding item: searchInventoryByInternalID field in the field mappings should correct the problem.

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

   Export field (REST API)	Import field (NetSuite)
   "true"	Items:searchInventoryByInternalID

7. Click Save & close.
8. Go back to the Dashboard and click Retry to solve the error.

Error 4: Failed to create, update/transform record because You have attempted an invalid sublist or line item operation

Data Flow: Shopify refund to NetSuite refund (add) flow

Error Code: sss_time_limit_exceeded

Error message: Failed to create, update/transform record because You have attempted an invalid sublist or line item operation. You are either trying to access a field on a non-existent line or you are trying to add or remove lines from a static sublist. Tip: Please make sure that all the line items that you're trying to use exist on the record.

Reason: Settlement Payment flow creates Customer Payments in NetSuite via Transactions > Customer > Accept Customer payment. This page has a limit of 10,000 transactions. If the Invoice the Settlement is trying to pay does not show on this page, that is when you will see this error. Due to NetSuite limitation, customer payments can’t be applied against an invoice when the customer has more than 10000 open invoices. 
Resolution: Usually, this gets resolved when you click Retry data. If it doesn't determine you'll need to check further:

• If the invoice is showing on this page or if it is included in the 10,000 limit.
• If it is not showing, you'll need to check why it is not showing or process those showing on the page first to free up some space so that other Invoices will get in the 10,000 limit. 

Error 5: Failed to save record because Please enter value(s) for: Refund Method

Data Flow: Shopify refund to NetSuite refund (add)

Error Code: user_error

Error message: Failed to save record because Please enter value(s) for: Refund Method

Reason: The refund gateway and refund method lookup are not the same or a refund method lookup is not added.

Resolution: In the Post customer refunds to NetSuite import > Refund method field mappings, add the export field value and match it with the NetSuite refund method under the import field value. 

1. Log in to your integrator.io account.
2. Click Shopify - NetSuite integration app.
3. Go to Flows > Refund section.
4. Next to the Shopify refund to NetSuite refund (add) flow, click Mappings.
5. On the Refund method field, click Settings.
6. In the Field mapping type, select Lookup.
7. In the Options, select Static: Value to value.
8. In the Export field value, select or type the required payment method.
9. In the Import field value, select or type the NetSuite refund method.
10. Click Save & close.
11. Go back to the Dashboard and click Retry to solve the error.

Error 6: Unable to Export Netsuite Refund to Shopify. Getting an Error message: Errors : {“refund_line_items.quantity”:[“cannot refund more items than were purchased”]}, Status Code: 422

Data Flow: NetSuite refund to Shopify refund (add)

Error Code: refund_error

Error message: Unable to Export Netsuite Refund to Shopify. Getting an Error message: Errors : {“refund_line_items.quantity”:[“cannot refund more items than were purchased”]}, Status Code: 422

Reason: In the NetSuite saved search ‘Celigo Shopify Refund Export,’ the default filter ‘Main Line: is false’ is missing.

Resolution: Add the default filter ‘Main Line: false’ and run the flow to resolve the error.

1. In NetSuite, go to the Transactions search and type Celigo Shopify Refund Export.
2. In the Celigo Shopify Refund Export > Criteria.
3. Add the ‘Main Line’ filter as ‘is false’.
4. Click Save.
5. Go to the integrator.io dashboard and retry the refund flow.