Articles in this section

Resolve script execution time exceeded errors in the Shopify customer deposit flow

If the Shopify transaction to NetSuite customer deposit (add) flow fails with Script Execution Time Exceeded errors, and you haven’t changed the flow, you can add an input filter to stop the errors. This article explains why the errors occur, how to add the filter, and what changes when you use it.

Data flow: Shopify transaction to NetSuite customer deposit (add)

Symptom

The flow shows errors such as Failed to create Customer Deposit for Shopify Order: <order number>. Script Execution Time Exceeded.

Cause

The flow also checks orders that are already in NetSuite. This way, a customer deposit is still created when a payment is captured after its order is imported. On high-volume accounts, or accounts where NetSuite processes slowly, these extra checks can run past NetSuite’s five-minute script limit.

Resolution

If you don’t need deposits created for payments captured after the order is imported, add this input filter:

  1. Go to integrator.io and open the Shopify - NetSuite integration app tile.
  2. Go to Flows > Billing, and then select the Shopify transaction to NetSuite customer deposit (add) flow.
  3. On the Post customer deposit to NetSuite import, select Define input filter.
  4. Add the rule Sales Order Id is not empty, and leave NOT cleared. If the filter already has rules, add this rule to the same group joined with AND, not OR.

After you add the filter, retry a small set of the existing errors first, about 20 to 50, to confirm they succeed. Then retry the rest.

Note: The filter skips only the check for orders already in NetSuite, so it doesn’t break anything else in your integration. Deposits for newly imported orders are still created the same way. A payment captured in Shopify after its order is already in NetSuite doesn’t get a customer deposit automatically, so create that deposit in NetSuite. To have these deposits created automatically again, remove the filter.

If the errors continue after you add the filter, contact Celigo Support.

Related articles